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 ka...@apache.org on 2012/05/21 16:30:25 UTC
svn commit: r1341046 [3/6] - in /db/derby/code/trunk/java:
drda/org/apache/derby/impl/drda/ engine/org/apache/derby/iapi/services/io/
engine/org/apache/derby/iapi/sql/ engine/org/apache/derby/iapi/types/
engine/org/apache/derby/impl/sql/execute/ shared...
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=1341046&r1=1341045&r2=1341046&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 Mon May 21 14:30:24 2012
@@ -57,7 +57,7 @@ ij> --
create view lock_table as
select
cast(username as char(8)) as username,
- cast(t.type as char(8)) as trantype,
+ cast(t.type as char(15)) as trantype,
cast(l.type as char(8)) as type,
cast(lockcount as char(3)) as cnt,
mode,
@@ -217,79 +217,79 @@ ij> get cursor scan_cursor as
ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault', '16');
0 rows inserted/updated/deleted
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
1 |10 |one
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
2 |20 |two
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
3 |30 |three
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
4 |40 |four
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
5 |50 |five
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
6 |60 |six
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
7 |70 |seven
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
No current row
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> close scan_cursor;
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
ij> commit;
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
ij> commit;
ij> --------------------------------------------------------------------------------
-- TEST 1: heap cursor scan, group fetch = 2
@@ -314,79 +314,79 @@ ij> get cursor scan_cursor as
ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault', '16');
0 rows inserted/updated/deleted
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
1 |10 |one
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
2 |20 |two
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
3 |30 |three
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
4 |40 |four
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
5 |50 |five
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
6 |60 |six
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
7 |70 |seven
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
No current row
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> close scan_cursor;
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
ij> commit;
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
ij> commit;
ij> --------------------------------------------------------------------------------
-- TEST 2: heap cursor scan, group fetch = 1, stop scan in middle of set
@@ -411,33 +411,33 @@ ij> get cursor scan_cursor as
ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault', '16');
0 rows inserted/updated/deleted
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
1 |10 |one
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
2 |20 |two
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> close scan_cursor;
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
ij> commit;
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
ij> commit;
ij> --------------------------------------------------------------------------------
-- TEST 3: heap cursor scan, group fetch = 4, stop scan in middle of set
@@ -462,33 +462,33 @@ ij> get cursor scan_cursor as
ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault', '16');
0 rows inserted/updated/deleted
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
1 |10 |one
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
2 |20 |two
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> close scan_cursor;
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
ij> commit;
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
ij> commit;
ij> --------------------------------------------------------------------------------
-- TEST 4: heap cursor scan, group fetch = 1 (scan table with some deleted rows)
@@ -532,55 +532,55 @@ ij> get cursor scan_cursor as
ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault', '16');
0 rows inserted/updated/deleted
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
1 |10 |one
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
3 |30 |three
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
5 |50 |five
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
7 |70 |seven
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
No current row
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> close scan_cursor;
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
ij> commit;
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
ij> commit;
ij> --------------------------------------------------------------------------------
-- TEST 5: heap cursor scan, group fetch = 2 (scan with committed deleted rows)
@@ -612,55 +612,55 @@ ij> get cursor scan_cursor as
ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault', '16');
0 rows inserted/updated/deleted
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
1 |10 |one
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
3 |30 |three
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
5 |50 |five
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
7 |70 |seven
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
No current row
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> close scan_cursor;
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
ij> commit;
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
ij> commit;
ij> --------------------------------------------------------------------------------
-- TEST 6: heap cursor scan, group fetch = 1 (scan with "<" qualifier)
@@ -684,27 +684,27 @@ ij> get cursor scan_cursor as
ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault', '16');
0 rows inserted/updated/deleted
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
1 |10 |one
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
No current row
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> close scan_cursor;
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
ij> commit;
ij> --------------------------------------------------------------------------------
-- TEST 7: heap cursor scan, group fetch = 2 (scan with "<" qualifier)
@@ -736,27 +736,27 @@ ij> get cursor scan_cursor as
ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault', '16');
0 rows inserted/updated/deleted
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
1 |10 |one
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
No current row
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> close scan_cursor;
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
ij> commit;
ij> --------------------------------------------------------------------------------
-- TEST 8: heap cursor scan, group fetch = 1 (scan with equals qualifier)
@@ -780,27 +780,27 @@ ij> get cursor scan_cursor as
ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault', '16');
0 rows inserted/updated/deleted
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
5 |50 |five
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
No current row
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> close scan_cursor;
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
ij> commit;
ij> --------------------------------------------------------------------------------
-- TEST 9: heap cursor scan, group fetch = 2 (scan with equals qualifier)
@@ -824,27 +824,27 @@ ij> get cursor scan_cursor as
ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault', '16');
0 rows inserted/updated/deleted
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
7 |70 |seven
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
No current row
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> close scan_cursor;
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
ij> commit;
ij> --------------------------------------------------------------------------------
-- TEST 10: heap cursor scan, group fetch = 1 (equals qualifier, no rows return)
@@ -876,27 +876,27 @@ ij> get cursor scan_cursor as
ij> CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault','16');
0 rows inserted/updated/deleted
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
7 |70 |seven
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
No current row
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> close scan_cursor;
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
ij> commit;
ij> drop table a;
0 rows inserted/updated/deleted
@@ -999,12 +999,12 @@ A |B |C
6 |60 |six
7 |70 |seven
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
ij> commit;
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
ij> commit;
ij> --------------------------------------------------------------------------------
-- TEST 1: heap scan, some rows deleted.
@@ -1047,12 +1047,12 @@ A |B |C
5 |50 |five
7 |70 |seven
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
ij> commit;
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
ij> commit;
ij> --------------------------------------------------------------------------------
-- TEST 2: heap scan, (scan with "<" qualifier)
@@ -1078,12 +1078,12 @@ A |B |C
5 |50 |five
7 |70 |seven
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
ij> commit;
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
ij> commit;
ij> --------------------------------------------------------------------------------
-- TEST 3: heap scan, (scan with equals qualifier)
@@ -1106,12 +1106,12 @@ A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
5 |50 |five
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
ij> commit;
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
ij> commit;
ij> --------------------------------------------------------------------------------
-- TEST 4: heap scan, (equals qualifier, no rows return)
@@ -1134,12 +1134,12 @@ A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
7 |70 |seven
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
ij> commit;
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
ij> commit;
ij> drop table a;
0 rows inserted/updated/deleted
@@ -1256,79 +1256,79 @@ ij> get cursor scan_cursor as
ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault', '16');
0 rows inserted/updated/deleted
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A
-----------
1
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A
-----------
2
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A
-----------
3
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A
-----------
4
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A
-----------
5
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A
-----------
6
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A
-----------
7
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
No current row
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> close scan_cursor;
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
ij> commit;
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
ij> commit;
ij> --------------------------------------------------------------------------------
-- TEST 1: btree cursor scan, group fetch = 2
@@ -1355,79 +1355,79 @@ ij> get cursor scan_cursor as
ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault', '16');
0 rows inserted/updated/deleted
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A
-----------
1
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A
-----------
2
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A
-----------
3
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A
-----------
4
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A
-----------
5
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A
-----------
6
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A
-----------
7
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
No current row
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> close scan_cursor;
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
ij> commit;
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
ij> commit;
ij> --------------------------------------------------------------------------------
-- TEST 2: btree cursor scan, group fetch = 1, stop scan in middle of set
@@ -1454,33 +1454,33 @@ ij> get cursor scan_cursor as
ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault', '16');
0 rows inserted/updated/deleted
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A
-----------
1
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A
-----------
2
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> close scan_cursor;
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
ij> commit;
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
ij> commit;
ij> --------------------------------------------------------------------------------
-- TEST 3: btree cursor scan, group fetch = 4, stop scan in middle of set
@@ -1507,33 +1507,33 @@ ij> get cursor scan_cursor as
ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault', '16');
0 rows inserted/updated/deleted
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A
-----------
1
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A
-----------
2
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> close scan_cursor;
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
ij> commit;
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
ij> commit;
ij> --------------------------------------------------------------------------------
-- TEST 4: btree cursor scan, group fetch = 1 (scan table with some deleted rows)
@@ -1578,55 +1578,55 @@ ij> get cursor scan_cursor as
ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault', '16');
0 rows inserted/updated/deleted
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A
-----------
1
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A
-----------
3
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A
-----------
5
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A
-----------
7
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
No current row
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> close scan_cursor;
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
ij> commit;
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
ij> commit;
ij> --------------------------------------------------------------------------------
-- TEST 5: btree cursor scan, group fetch = 2 (scan with committed deleted rows)
@@ -1659,55 +1659,55 @@ ij> get cursor scan_cursor as
ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault', '16');
0 rows inserted/updated/deleted
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A
-----------
1
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A
-----------
3
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A
-----------
5
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A
-----------
7
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IS |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
[... 19858 lines stripped ...]