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/23 19:13:43 UTC
svn commit: r1471049 - in /db/derby/code/branches/10.8: ./
java/testing/org/apache/derbyTesting/functionTests/master/
java/testing/org/apache/derbyTesting/functionTests/tests/store/
Author: mikem
Date: Tue Apr 23 17:13:42 2013
New Revision: 1471049
URL: http://svn.apache.org/r1471049
Log:
DERBY-6183 rlliso2multi and rlliso3multi failing with [WARNING 01004: Data truncation]
backported change #1469445 from trunk to 10.8 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.8/ (props changed)
db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule1.out
db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule2.out
db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule3.out
db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule4.out
db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/RowLockBasic.out
db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/RowLockIso.out
db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/TableLockBasic.out
db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/heapscan.out
db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/readlocks.out
db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/rlliso2multi.out
db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/rlliso3multi.out
db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/updatelocksJDBC30.out
db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/xaOffline1.out
db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/tests/store/LockTableQuery.subsql
Propchange: db/derby/code/branches/10.8/
------------------------------------------------------------------------------
Merged /db/derby/code/branches/10.9:r1469868
Merged /db/derby/code/trunk:r1469445
Modified: db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule1.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule1.out?rev=1471049&r1=1471048&r2=1471049&view=diff
==============================================================================
--- db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule1.out (original)
+++ db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule1.out Tue Apr 23 17:13:42 2013
@@ -68,18 +68,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.8/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule2.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule2.out?rev=1471049&r1=1471048&r2=1471049&view=diff
==============================================================================
--- db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule2.out (original)
+++ db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule2.out Tue Apr 23 17:13:42 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.8/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule3.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule3.out?rev=1471049&r1=1471048&r2=1471049&view=diff
==============================================================================
--- db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule3.out (original)
+++ db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule3.out Tue Apr 23 17:13:42 2013
@@ -68,18 +68,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.8/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule4.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule4.out?rev=1471049&r1=1471048&r2=1471049&view=diff
==============================================================================
--- db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule4.out (original)
+++ db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule4.out Tue Apr 23 17:13:42 2013
@@ -68,18 +68,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.8/java/testing/org/apache/derbyTesting/functionTests/master/RowLockBasic.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/RowLockBasic.out?rev=1471049&r1=1471048&r2=1471049&view=diff
==============================================================================
--- db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/RowLockBasic.out (original)
+++ db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/RowLockBasic.out Tue Apr 23 17:13:42 2013
@@ -98,18 +98,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.8/java/testing/org/apache/derbyTesting/functionTests/master/RowLockIso.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/RowLockIso.out?rev=1471049&r1=1471048&r2=1471049&view=diff
==============================================================================
--- db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/RowLockIso.out (original)
+++ db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/RowLockIso.out Tue Apr 23 17:13:42 2013
@@ -96,18 +96,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.8/java/testing/org/apache/derbyTesting/functionTests/master/TableLockBasic.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/TableLockBasic.out?rev=1471049&r1=1471048&r2=1471049&view=diff
==============================================================================
--- db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/TableLockBasic.out (original)
+++ db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/TableLockBasic.out Tue Apr 23 17:13:42 2013
@@ -116,18 +116,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.8/java/testing/org/apache/derbyTesting/functionTests/master/heapscan.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/heapscan.out?rev=1471049&r1=1471048&r2=1471049&view=diff
==============================================================================
--- db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/heapscan.out (original)
+++ db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/heapscan.out Tue Apr 23 17:13:42 2013
@@ -101,18 +101,20 @@ 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.8/java/testing/org/apache/derbyTesting/functionTests/master/readlocks.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/readlocks.out?rev=1471049&r1=1471048&r2=1471049&view=diff
==============================================================================
--- db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/readlocks.out (original)
+++ db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/readlocks.out Tue Apr 23 17:13:42 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.8/java/testing/org/apache/derbyTesting/functionTests/master/rlliso2multi.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/rlliso2multi.out?rev=1471049&r1=1471048&r2=1471049&view=diff
==============================================================================
--- db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/rlliso2multi.out (original)
+++ db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/rlliso2multi.out Tue Apr 23 17:13:42 2013
@@ -981,18 +981,20 @@ 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
@@ -1157,11 +1159,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.8/java/testing/org/apache/derbyTesting/functionTests/master/rlliso3multi.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/rlliso3multi.out?rev=1471049&r1=1471048&r2=1471049&view=diff
==============================================================================
--- db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/rlliso3multi.out (original)
+++ db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/rlliso3multi.out Tue Apr 23 17:13:42 2013
@@ -451,18 +451,20 @@ 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
@@ -588,12 +590,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.8/java/testing/org/apache/derbyTesting/functionTests/master/updatelocksJDBC30.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/updatelocksJDBC30.out?rev=1471049&r1=1471048&r2=1471049&view=diff
==============================================================================
--- db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/updatelocksJDBC30.out (original)
+++ db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/updatelocksJDBC30.out Tue Apr 23 17:13:42 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.8/java/testing/org/apache/derbyTesting/functionTests/master/xaOffline1.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/xaOffline1.out?rev=1471049&r1=1471048&r2=1471049&view=diff
==============================================================================
--- db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/xaOffline1.out (original)
+++ db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/master/xaOffline1.out Tue Apr 23 17:13:42 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.8/java/testing/org/apache/derbyTesting/functionTests/tests/store/LockTableQuery.subsql
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/tests/store/LockTableQuery.subsql?rev=1471049&r1=1471048&r2=1471049&view=diff
==============================================================================
--- db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/tests/store/LockTableQuery.subsql (original)
+++ db/derby/code/branches/10.8/java/testing/org/apache/derbyTesting/functionTests/tests/store/LockTableQuery.subsql Tue Apr 23 17:13:42 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