db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mi...@apache.org
Subject svn commit: r1469445 - in /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests: master/ tests/store/
Date Thu, 18 Apr 2013 17:04:12 GMT
Author: mikem
Date: Thu Apr 18 17:04:11 2013
New Revision: 1469445

URL: http://svn.apache.org/r1469445
Log:
DERBY-6183 rlliso2multi and rlliso3multi failing with [WARNING 01004: Data truncation] 

Removed casts from lock_table2 view, which was only used in a few
places.  I was not able to reproduce, but assumption is that a
system background lock when running full suite sometimes triggered
a problem with the cast.  



Modified:
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule1.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule2.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule3.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule4.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/RowLockIso.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/heapscan.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/readlocks.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/rlliso2multi.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/rlliso3multi.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/updatelocksJDBC30.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/xaOffline1.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/LockTableQuery.subsql

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule1.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule1.out?rev=1469445&r1=1469444&r2=1469445&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule1.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule1.out
Thu Apr 18 17:04:11 2013
@@ -69,18 +69,21 @@ from 
 on l.xid = t.xid where l.tableType <> 'S' ;
 0 rows inserted/updated/deleted
 ij(CONNECTION1)> -- lock table with no join.
+-- DERBY-6183, removing CAST's to avoid background locks causing
+-- data trunction warnings.
+
 create view lock_table2 as
 select 
-    cast(l.xid as char(8)) as xid,
-    cast(l.type as char(8)) as type,
-    cast(lockcount as char(3)) as cnt,
+    xid,
+    type,
+    lockcount as cnt,
     mode,
-    cast(tablename as char(12)) as tabname,
-    cast(lockname as char(10)) as lockname,
+    tablename as tabname,
+    lockname,
     state
 from 
-    syscs_diag.lock_table l  
-where l.tableType <> 'S' ;
+    syscs_diag.lock_table
+where tableType <> 'S' ;
 0 rows inserted/updated/deleted
 ij(CONNECTION1)> -- transaction table with no join.
 create view tran_table as

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule2.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule2.out?rev=1469445&r1=1469444&r2=1469445&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule2.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule2.out
Thu Apr 18 17:04:11 2013
@@ -69,18 +69,20 @@ from 
 on l.xid = t.xid where l.tableType <> 'S' ;
 0 rows inserted/updated/deleted
 ij> -- lock table with no join.
+-- DERBY-6183, removing CAST's to avoid background locks causing
+-- data trunction warnings.
 create view lock_table2 as
 select 
-    cast(l.xid as char(8)) as xid,
-    cast(l.type as char(8)) as type,
-    cast(lockcount as char(3)) as cnt,
+    xid,
+    type,
+    lockcount as cnt,
     mode,
-    cast(tablename as char(12)) as tabname,
-    cast(lockname as char(10)) as lockname,
+    tablename as tabname,
+    lockname,
     state
 from 
-    syscs_diag.lock_table l  
-where l.tableType <> 'S' ;
+    syscs_diag.lock_table
+where tableType <> 'S' ;
 0 rows inserted/updated/deleted
 ij> -- transaction table with no join.
 create view tran_table as

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule3.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule3.out?rev=1469445&r1=1469444&r2=1469445&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule3.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule3.out
Thu Apr 18 17:04:11 2013
@@ -69,18 +69,21 @@ from 
 on l.xid = t.xid where l.tableType <> 'S' ;
 0 rows inserted/updated/deleted
 ij(CONNECTION1)> -- lock table with no join.
+-- DERBY-6183, removing CAST's to avoid background locks causing
+-- data trunction warnings.
+
 create view lock_table2 as
 select 
-    cast(l.xid as char(8)) as xid,
-    cast(l.type as char(8)) as type,
-    cast(lockcount as char(3)) as cnt,
+    xid,
+    type,
+    lockcount as cnt,
     mode,
-    cast(tablename as char(12)) as tabname,
-    cast(lockname as char(10)) as lockname,
+    tablename as tabname,
+    lockname,
     state
 from 
-    syscs_diag.lock_table l  
-where l.tableType <> 'S' ;
+    syscs_diag.lock_table
+where tableType <> 'S' ;
 0 rows inserted/updated/deleted
 ij(CONNECTION1)> -- transaction table with no join.
 create view tran_table as

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule4.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule4.out?rev=1469445&r1=1469444&r2=1469445&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule4.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule4.out
Thu Apr 18 17:04:11 2013
@@ -69,18 +69,21 @@ from 
 on l.xid = t.xid where l.tableType <> 'S' ;
 0 rows inserted/updated/deleted
 ij(CONNECTION1)> -- lock table with no join.
+-- DERBY-6183, removing CAST's to avoid background locks causing
+-- data trunction warnings.
+
 create view lock_table2 as
 select 
-    cast(l.xid as char(8)) as xid,
-    cast(l.type as char(8)) as type,
-    cast(lockcount as char(3)) as cnt,
+    xid,
+    type,
+    lockcount as cnt,
     mode,
-    cast(tablename as char(12)) as tabname,
-    cast(lockname as char(10)) as lockname,
+    tablename as tabname,
+    lockname,
     state
 from 
-    syscs_diag.lock_table l  
-where l.tableType <> 'S' ;
+    syscs_diag.lock_table
+where tableType <> 'S' ;
 0 rows inserted/updated/deleted
 ij(CONNECTION1)> -- transaction table with no join.
 create view tran_table as

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/RowLockIso.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/RowLockIso.out?rev=1469445&r1=1469444&r2=1469445&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/RowLockIso.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/RowLockIso.out
Thu Apr 18 17:04:11 2013
@@ -97,18 +97,21 @@ from 
 on l.xid = t.xid where l.tableType <> 'S' ;
 0 rows inserted/updated/deleted
 ij(CONNECTION1)> -- lock table with no join.
+-- DERBY-6183, removing CAST's to avoid background locks causing
+-- data trunction warnings.
+
 create view lock_table2 as
 select 
-    cast(l.xid as char(8)) as xid,
-    cast(l.type as char(8)) as type,
-    cast(lockcount as char(3)) as cnt,
+    xid,
+    type,
+    lockcount as cnt,
     mode,
-    cast(tablename as char(12)) as tabname,
-    cast(lockname as char(10)) as lockname,
+    tablename as tabname,
+    lockname,
     state
 from 
-    syscs_diag.lock_table l  
-where l.tableType <> 'S' ;
+    syscs_diag.lock_table
+where tableType <> 'S' ;
 0 rows inserted/updated/deleted
 ij(CONNECTION1)> -- transaction table with no join.
 create view tran_table as
@@ -786,4 +789,4 @@ APP     |UserTransaction|TABLE   |3   |X
 ij(CONNECTION1)> commit;
 ij(CONNECTION1)> drop table a;
 0 rows inserted/updated/deleted
-ij(CONNECTION1)> 
+ij(CONNECTION1)> 
\ No newline at end of file

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/heapscan.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/heapscan.out?rev=1469445&r1=1469444&r2=1469445&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/heapscan.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/heapscan.out
Thu Apr 18 17:04:11 2013
@@ -102,18 +102,21 @@ from 
 on l.xid = t.xid where l.tableType <> 'S' ;
 0 rows inserted/updated/deleted
 ij(SCANNER)> -- lock table with no join.
+-- DERBY-6183, removing CAST's to avoid background locks causing
+-- data trunction warnings.
+
 create view lock_table2 as
 select 
-    cast(l.xid as char(8)) as xid,
-    cast(l.type as char(8)) as type,
-    cast(lockcount as char(3)) as cnt,
+    xid,
+    type,
+    lockcount as cnt,
     mode,
-    cast(tablename as char(12)) as tabname,
-    cast(lockname as char(10)) as lockname,
+    tablename as tabname,
+    lockname,
     state
 from 
-    syscs_diag.lock_table l  
-where l.tableType <> 'S' ;
+    syscs_diag.lock_table
+where tableType <> 'S' ;
 0 rows inserted/updated/deleted
 ij(SCANNER)> -- transaction table with no join.
 create view tran_table as

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/readlocks.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/readlocks.out?rev=1469445&r1=1469444&r2=1469445&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/readlocks.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/readlocks.out
Thu Apr 18 17:04:11 2013
@@ -91,18 +91,21 @@ from 
 on l.xid = t.xid where l.tableType <> 'S' ;
 0 rows inserted/updated/deleted
 ij(CONNECTION1)> -- lock table with no join.
+-- DERBY-6183, removing CAST's to avoid background locks causing
+-- data trunction warnings.
+
 create view lock_table2 as
 select 
-    cast(l.xid as char(8)) as xid,
-    cast(l.type as char(8)) as type,
-    cast(lockcount as char(3)) as cnt,
+    xid,
+    type,
+    lockcount as cnt,
     mode,
-    cast(tablename as char(12)) as tabname,
-    cast(lockname as char(10)) as lockname,
+    tablename as tabname,
+    lockname,
     state
 from 
-    syscs_diag.lock_table l  
-where l.tableType <> 'S' ;
+    syscs_diag.lock_table
+where tableType <> 'S' ;
 0 rows inserted/updated/deleted
 ij(CONNECTION1)> -- transaction table with no join.
 create view tran_table as

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/rlliso2multi.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/rlliso2multi.out?rev=1469445&r1=1469444&r2=1469445&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/rlliso2multi.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/rlliso2multi.out
Thu Apr 18 17:04:11 2013
@@ -1002,18 +1002,21 @@ from 
 on l.xid = t.xid where l.tableType <> 'S' ;
 0 rows inserted/updated/deleted
 ij(DDL)> -- lock table with no join.
+-- DERBY-6183, removing CAST's to avoid background locks causing
+-- data trunction warnings.
+
 create view lock_table2 as
 select 
-    cast(l.xid as char(8)) as xid,
-    cast(l.type as char(8)) as type,
-    cast(lockcount as char(3)) as cnt,
+    xid,
+    type,
+    lockcount as cnt,
     mode,
-    cast(tablename as char(12)) as tabname,
-    cast(lockname as char(10)) as lockname,
+    tablename as tabname,
+    lockname,
     state
 from 
-    syscs_diag.lock_table l  
-where l.tableType <> 'S' ;
+    syscs_diag.lock_table
+where tableType <> 'S' ;
 0 rows inserted/updated/deleted
 ij(DDL)> -- transaction table with no join.
 create view tran_table as
@@ -1182,11 +1185,11 @@ ij(T11SCANNER)> --
 get cursor update_cursor3 as
     'select b from test_11 where a=8 for update of b';
 ij(T11SCANNER)> select type, cnt, mode, tabname, lockname, state from lock_table2 order
by tabname, type desc, mode, cnt, lockname;
-TYPE    |CNT|MODE|TABNAME     |LOCKNAME  |STATE
------------------------------------------------
-TABLE   |1  |IX  |TEST_11     |Tablelock |GRANT
-TABLE   |1  |IX  |TEST_11     |Tablelock |GRANT
-ROW     |1  |U   |TEST_11     |(1,7)     |GRANT
+TYPE |CNT  |MODE|TABNAME                                                                
                                                        |LOCKNAME            |STATE
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+TABLE|1    |IX  |TEST_11                                                                
                                                        |Tablelock           |GRANT
+TABLE|1    |IX  |TEST_11                                                                
                                                        |Tablelock           |GRANT
+ROW  |1    |U   |TEST_11                                                                
                                                        |(1,7)               |GRANT
 ij(T11SCANNER)> next update_cursor3;
 B          
 -----------

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/rlliso3multi.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/rlliso3multi.out?rev=1469445&r1=1469444&r2=1469445&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/rlliso3multi.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/rlliso3multi.out
Thu Apr 18 17:04:11 2013
@@ -458,18 +458,21 @@ from 
 on l.xid = t.xid where l.tableType <> 'S' ;
 0 rows inserted/updated/deleted
 ij(T6WRITER)> -- lock table with no join.
+-- DERBY-6183, removing CAST's to avoid background locks causing
+-- data trunction warnings.
+
 create view lock_table2 as
 select 
-    cast(l.xid as char(8)) as xid,
-    cast(l.type as char(8)) as type,
-    cast(lockcount as char(3)) as cnt,
+    xid,
+    type,
+    lockcount as cnt,
     mode,
-    cast(tablename as char(12)) as tabname,
-    cast(lockname as char(10)) as lockname,
+    tablename as tabname,
+    lockname,
     state
 from 
-    syscs_diag.lock_table l  
-where l.tableType <> 'S' ;
+    syscs_diag.lock_table
+where tableType <> 'S' ;
 0 rows inserted/updated/deleted
 ij(T6WRITER)> -- transaction table with no join.
 create view tran_table as
@@ -596,12 +599,12 @@ ij(T6SCANNER)> --
 get cursor update_cursor3 as
     'select b from test_6 where a=8 for update of b';
 ij(T6SCANNER)> select type, cnt, mode, tabname, lockname, state from lock_table2 order
by tabname, type desc, mode, cnt, lockname;
-TYPE    |CNT|MODE|TABNAME     |LOCKNAME  |STATE
------------------------------------------------
-TABLE   |1  |IX  |TEST_6      |Tablelock |GRANT
-TABLE   |1  |IX  |TEST_6      |Tablelock |GRANT
-ROW     |1  |U   |TEST_6      |(1,3)     |GRANT
-ROW     |1  |U   |TEST_6      |(1,7)     |GRANT
+TYPE |CNT  |MODE|TABNAME                                                                
                                                        |LOCKNAME            |STATE
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+TABLE|1    |IX  |TEST_6                                                                 
                                                        |Tablelock           |GRANT
+TABLE|1    |IX  |TEST_6                                                                 
                                                        |Tablelock           |GRANT
+ROW  |1    |U   |TEST_6                                                                 
                                                        |(1,3)               |GRANT
+ROW  |1    |U   |TEST_6                                                                 
                                                        |(1,7)               |GRANT
 ij(T6SCANNER)> next update_cursor3;
 B          
 -----------

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/updatelocksJDBC30.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/updatelocksJDBC30.out?rev=1469445&r1=1469444&r2=1469445&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/updatelocksJDBC30.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/updatelocksJDBC30.out
Thu Apr 18 17:04:11 2013
@@ -89,18 +89,20 @@ from 
 on l.xid = t.xid where l.tableType <> 'S' ;
 0 rows inserted/updated/deleted
 ij> -- lock table with no join.
+-- DERBY-6183, removing CAST's to avoid background locks causing
+-- data trunction warnings.
 create view lock_table2 as
 select 
-    cast(l.xid as char(8)) as xid,
-    cast(l.type as char(8)) as type,
-    cast(lockcount as char(3)) as cnt,
+    xid,
+    type,
+    lockcount as cnt,
     mode,
-    cast(tablename as char(12)) as tabname,
-    cast(lockname as char(10)) as lockname,
+    tablename as tabname,
+    lockname,
     state
 from 
-    syscs_diag.lock_table l  
-where l.tableType <> 'S' ;
+    syscs_diag.lock_table
+where tableType <> 'S' ;
 0 rows inserted/updated/deleted
 ij> -- transaction table with no join.
 create view tran_table as

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/xaOffline1.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/xaOffline1.out?rev=1469445&r1=1469444&r2=1469445&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/xaOffline1.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/xaOffline1.out
Thu Apr 18 17:04:11 2013
@@ -110,18 +110,20 @@ from 
 on l.xid = t.xid where l.tableType <> 'S' ;
 0 rows inserted/updated/deleted
 ij(XA)> -- lock table with no join.
+-- DERBY-6183, removing CAST's to avoid background locks causing
+-- data trunction warnings.
 create view lock_table2 as
 select 
-    cast(l.xid as char(8)) as xid,
-    cast(l.type as char(8)) as type,
-    cast(lockcount as char(3)) as cnt,
+    xid,
+    type,
+    lockcount as cnt,
     mode,
-    cast(tablename as char(12)) as tabname,
-    cast(lockname as char(10)) as lockname,
+    tablename as tabname,
+    lockname,
     state
 from 
-    syscs_diag.lock_table l  
-where l.tableType <> 'S' ;
+    syscs_diag.lock_table
+where tableType <> 'S' ;
 0 rows inserted/updated/deleted
 ij(XA)> -- transaction table with no join.
 create view tran_table as

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/LockTableQuery.subsql
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/LockTableQuery.subsql?rev=1469445&r1=1469444&r2=1469445&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/LockTableQuery.subsql
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/LockTableQuery.subsql
Thu Apr 18 17:04:11 2013
@@ -49,18 +49,21 @@ from 
 on l.xid = t.xid where l.tableType <> 'S' ;
 
 -- lock table with no join.
+-- DERBY-6183, removing CAST's to avoid background locks causing
+-- data trunction warnings.
+
 create view lock_table2 as
 select 
-    cast(l.xid as char(8)) as xid,
-    cast(l.type as char(8)) as type,
-    cast(lockcount as char(3)) as cnt,
+    xid,
+    type,
+    lockcount as cnt,
     mode,
-    cast(tablename as char(12)) as tabname,
-    cast(lockname as char(10)) as lockname,
+    tablename as tabname,
+    lockname,
     state
 from 
-    syscs_diag.lock_table l  
-where l.tableType <> 'S' ;
+    syscs_diag.lock_table
+where tableType <> 'S' ;
 
 -- transaction table with no join.
 create view tran_table as



Mime
View raw message