You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by mi...@apache.org on 2013/04/19 00:51:16 UTC
svn commit: r1469624 - in /db/derby/code/branches/10.10: ./
java/testing/org/apache/derbyTesting/functionTests/master/
java/testing/org/apache/derbyTesting/functionTests/tests/store/
Author: mikem
Date: Thu Apr 18 22:51:15 2013
New Revision: 1469624
URL: http://svn.apache.org/r1469624
Log:
DERBY-6183 rlliso2multi and rlliso3multi failing with [WARNING 01004: Data truncation]
backported change #1469445 from trunk to 10.10 branch.
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/branches/10.10/ (props changed)
db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule1.out
db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule2.out
db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule3.out
db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule4.out
db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/RowLockIso.out
db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/heapscan.out
db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/readlocks.out
db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/rlliso2multi.out
db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/rlliso3multi.out
db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/updatelocksJDBC30.out
db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/xaOffline1.out
db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/tests/store/LockTableQuery.subsql
Propchange: db/derby/code/branches/10.10/
------------------------------------------------------------------------------
Merged /db/derby/code/trunk:r1469445
Modified: db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule1.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule1.out?rev=1469624&r1=1469623&r2=1469624&view=diff
==============================================================================
--- db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule1.out (original)
+++ db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule1.out Thu Apr 18 22:51:15 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/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule2.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule2.out?rev=1469624&r1=1469623&r2=1469624&view=diff
==============================================================================
--- db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule2.out (original)
+++ db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule2.out Thu Apr 18 22:51:15 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/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule3.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule3.out?rev=1469624&r1=1469623&r2=1469624&view=diff
==============================================================================
--- db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule3.out (original)
+++ db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule3.out Thu Apr 18 22:51:15 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/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule4.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule4.out?rev=1469624&r1=1469623&r2=1469624&view=diff
==============================================================================
--- db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule4.out (original)
+++ db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule4.out Thu Apr 18 22:51:15 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/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/RowLockIso.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/RowLockIso.out?rev=1469624&r1=1469623&r2=1469624&view=diff
==============================================================================
--- db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/RowLockIso.out (original)
+++ db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/RowLockIso.out Thu Apr 18 22:51:15 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/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/heapscan.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/heapscan.out?rev=1469624&r1=1469623&r2=1469624&view=diff
==============================================================================
--- db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/heapscan.out (original)
+++ db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/heapscan.out Thu Apr 18 22:51:15 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/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/readlocks.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/readlocks.out?rev=1469624&r1=1469623&r2=1469624&view=diff
==============================================================================
--- db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/readlocks.out (original)
+++ db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/readlocks.out Thu Apr 18 22:51:15 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/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/rlliso2multi.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/rlliso2multi.out?rev=1469624&r1=1469623&r2=1469624&view=diff
==============================================================================
--- db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/rlliso2multi.out (original)
+++ db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/rlliso2multi.out Thu Apr 18 22:51:15 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/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/rlliso3multi.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/rlliso3multi.out?rev=1469624&r1=1469623&r2=1469624&view=diff
==============================================================================
--- db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/rlliso3multi.out (original)
+++ db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/rlliso3multi.out Thu Apr 18 22:51:15 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/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/updatelocksJDBC30.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/updatelocksJDBC30.out?rev=1469624&r1=1469623&r2=1469624&view=diff
==============================================================================
--- db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/updatelocksJDBC30.out (original)
+++ db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/updatelocksJDBC30.out Thu Apr 18 22:51:15 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/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/xaOffline1.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/xaOffline1.out?rev=1469624&r1=1469623&r2=1469624&view=diff
==============================================================================
--- db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/xaOffline1.out (original)
+++ db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/master/xaOffline1.out Thu Apr 18 22:51:15 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/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/tests/store/LockTableQuery.subsql
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/tests/store/LockTableQuery.subsql?rev=1469624&r1=1469623&r2=1469624&view=diff
==============================================================================
--- db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/tests/store/LockTableQuery.subsql (original)
+++ db/derby/code/branches/10.10/java/testing/org/apache/derbyTesting/functionTests/tests/store/LockTableQuery.subsql Thu Apr 18 22:51:15 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