Return-Path: X-Original-To: apmail-db-derby-commits-archive@www.apache.org Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id B837FF5AF for ; Thu, 18 Apr 2013 17:04:39 +0000 (UTC) Received: (qmail 45282 invoked by uid 500); 18 Apr 2013 17:04:39 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 45241 invoked by uid 500); 18 Apr 2013 17:04:39 -0000 Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: "Derby Development" List-Id: Delivered-To: mailing list derby-commits@db.apache.org Received: (qmail 45226 invoked by uid 99); 18 Apr 2013 17:04:39 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 18 Apr 2013 17:04:39 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED,FILL_THIS_FORM X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO eris.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 18 Apr 2013 17:04:34 +0000 Received: from eris.apache.org (localhost [127.0.0.1]) by eris.apache.org (Postfix) with ESMTP id E3C4123888E7; Thu, 18 Apr 2013 17:04:12 +0000 (UTC) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit 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 -0000 To: derby-commits@db.apache.org From: mikem@apache.org X-Mailer: svnmailer-1.0.8-patched Message-Id: <20130418170412.E3C4123888E7@eris.apache.org> X-Virus-Checked: Checked by ClamAV on apache.org 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