db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From myrn...@apache.org
Subject svn commit: r1443812 [4/6] - in /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests: master/ suites/ tests/store/
Date Fri, 08 Feb 2013 00:51:10 GMT
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=1443812&r1=1443811&r2=1443812&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 Fri Feb  8 00:51:09 2013
@@ -1,4 +1,4 @@
-ij> --
+ij(CONNECTION1)> --
 --   Licensed to the Apache Software Foundation (ASF) under one or more
 --   contributor license agreements.  See the NOTICE file distributed with
 --   this work for additional information regarding copyright ownership.
@@ -15,9 +15,10 @@ ij> --
 --   limitations under the License.
 --
 -- Very basic single user testing of update row locking.
+
 autocommit off;
-ij> run resource 'createTestProcedures.subsql';
-ij> --
+ij(CONNECTION1)> run resource '/org/apache/derbyTesting/functionTests/tests/store/createTestProcedures.subsql';
+ij(CONNECTION1)> --
 --   Licensed to the Apache Software Foundation (ASF) under one or more
 --   contributor license agreements.  See the NOTICE file distributed with
 --   this work for additional information regarding copyright ownership.
@@ -35,10 +36,10 @@ ij> --
 --
 CREATE FUNCTION  PADSTRING (DATA VARCHAR(32000), LENGTH INTEGER) RETURNS VARCHAR(32000) EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.Formatters.padString' LANGUAGE JAVA PARAMETER STYLE JAVA;
 0 rows inserted/updated/deleted
-ij> CREATE PROCEDURE WAIT_FOR_POST_COMMIT() DYNAMIC RESULT SETS 0 LANGUAGE JAVA EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.T_Access.waitForPostCommitToFinish' PARAMETER STYLE JAVA;
+ij(CONNECTION1)> CREATE PROCEDURE WAIT_FOR_POST_COMMIT() DYNAMIC RESULT SETS 0 LANGUAGE JAVA EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.T_Access.waitForPostCommitToFinish' PARAMETER STYLE JAVA;
 0 rows inserted/updated/deleted
-ij> run resource 'LockTableQuery.subsql';
-ij> --
+ij(CONNECTION1)> run resource '/org/apache/derbyTesting/functionTests/tests/store/LockTableQuery.subsql';
+ij(CONNECTION1)> --
 --   Licensed to the Apache Software Foundation (ASF) under one or more
 --   contributor license agreements.  See the NOTICE file distributed with
 --   this work for additional information regarding copyright ownership.
@@ -69,9 +70,10 @@ from 
     syscs_diag.lock_table l  right outer join syscs_diag.transaction_table t
 on l.xid = t.xid where l.tableType <> 'S' and t.type='UserTransaction';
 0 rows inserted/updated/deleted
-ij> --on l.xid = t.xid where l.tableType <> 'S' or l.tableType is null
+ij(CONNECTION1)> --on l.xid = t.xid where l.tableType <> 'S' or l.tableType is null
 -- order by
 --     tabname, type desc, mode, cnt, lockname
+
 -- lock table with system catalog locks included.
 create view full_lock_table as
 select 
@@ -88,7 +90,7 @@ from 
     syscs_diag.lock_table l right outer join syscs_diag.transaction_table t
 on l.xid = t.xid where l.tableType <> 'S' ;
 0 rows inserted/updated/deleted
-ij> -- lock table with no join.
+ij(CONNECTION1)> -- lock table with no join.
 create view lock_table2 as
 select 
     cast(l.xid as char(8)) as xid,
@@ -102,48 +104,50 @@ from 
     syscs_diag.lock_table l  
 where l.tableType <> 'S' ;
 0 rows inserted/updated/deleted
-ij> -- transaction table with no join.
+ij(CONNECTION1)> -- transaction table with no join.
 create view tran_table as
 select 
     *
 from 
     syscs_diag.transaction_table;
 0 rows inserted/updated/deleted
-ij> commit;
-ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.storage.pageSize', '4096');
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.storage.pageSize', '4096');
 0 rows inserted/updated/deleted
-ij> -- READ UNCOMMITTED TEST
+ij(CONNECTION1)> -- READ UNCOMMITTED TEST
 set isolation read uncommitted;
 0 rows inserted/updated/deleted
-ij> commit;
-ij> -- run each test with rows on one page in the interesting conglomerate (heap in
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> -- run each test with rows on one page in the interesting conglomerate (heap in
 -- the non-index tests, and in the index in the index based tests).
+
 -- cursor, no index run
     drop table a;
 ERROR 42Y55: 'DROP TABLE' cannot be performed on 'A' because it does not exist.
-ij> -- to create tables of page size 4k and still keep the following tbl 
+ij(CONNECTION1)> -- to create tables of page size 4k and still keep the following tbl 
     -- create table a (a int, b int, c varchar(1900));
+    
     create table a(a int, b int);
 0 rows inserted/updated/deleted
-ij> alter table a add column c varchar(1900);
+ij(CONNECTION1)> alter table a add column c varchar(1900);
 0 rows inserted/updated/deleted
-ij> insert into a values (1, 10, 'one');
+ij(CONNECTION1)> insert into a values (1, 10, 'one');
 1 row inserted/updated/deleted
-ij> insert into a values (2, 20, 'two');
+ij(CONNECTION1)> insert into a values (2, 20, 'two');
 1 row inserted/updated/deleted
-ij> insert into a values (3, 30, 'three');
+ij(CONNECTION1)> insert into a values (3, 30, 'three');
 1 row inserted/updated/deleted
-ij> insert into a values (4, 40, 'four');
+ij(CONNECTION1)> insert into a values (4, 40, 'four');
 1 row inserted/updated/deleted
-ij> insert into a values (5, 50, 'five');
+ij(CONNECTION1)> insert into a values (5, 50, 'five');
 1 row inserted/updated/deleted
-ij> insert into a values (6, 60, 'six');
+ij(CONNECTION1)> insert into a values (6, 60, 'six');
 1 row inserted/updated/deleted
-ij> insert into a values (7, 70, 'seven');
+ij(CONNECTION1)> insert into a values (7, 70, 'seven');
 1 row inserted/updated/deleted
-ij> commit;
-ij> run resource 'readCursorLocks.subsql';
-ij> --
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> run resource '/org/apache/derbyTesting/functionTests/tests/store/readCursorLocks.subsql';
+ij(CONNECTION1)> --
 --   Licensed to the Apache Software Foundation (ASF) under one or more
 --   contributor license agreements.  See the NOTICE file distributed with
 --   this work for additional information regarding copyright ownership.
@@ -167,6 +171,7 @@ ij> --
 --
 -- assume's caller has already done: run 'LockTableQuery.subsql'; to get 
 -- easy access to the lock VTI.
+
 -- TEST 0: heap cursor scan, group fetch = 1
 -- TEST 1: heap cursor scan, group fetch = 2
 -- TEST 2: heap cursor scan, group fetch = 1, stop scan in middle of set
@@ -178,8 +183,9 @@ ij> --
 -- TEST 8: heap cursor scan, group fetch = 1 (scan with equals qualifier)
 -- TEST 9: heap cursor scan, group fetch = 2 (scan with equals qualifier)
 -- TEST 10: heap cursor scan, group fetch = 1 (equals qualifier, no rows return)
+
 autocommit off;
-ij> --------------------------------------------------------------------------------
+ij(CONNECTION1)> --------------------------------------------------------------------------------
 -- Assumes that calling routine has set up the following simple dataset, 
 -- a heap, no indexes with following initial values:
 --     create table (a int, b int, c somesortofchar);
@@ -201,8 +207,8 @@ A          |B          |C               
 5          |50         |five                                                                                                                            
 6          |60         |six                                                                                                                             
 7          |70         |seven                                                                                                                           
-ij> commit;
-ij> --------------------------------------------------------------------------------
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> --------------------------------------------------------------------------------
 -- TEST 0: heap cursor scan, group fetch = 1
 -- Test full cursor scan which does no updates.
 --    SERIALIZABLE     - will get table level S lock.
@@ -212,86 +218,86 @@ ij> ------------------------------------
 --------------------------------------------------------------------------------
 CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault','1');
 0 rows inserted/updated/deleted
-ij> get cursor scan_cursor as
+ij(CONNECTION1)> get cursor scan_cursor as
     'select a, b, c from a';
-ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault', '16');
+ij(CONNECTION1)> 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;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 1          |10         |one                                                                                                                             
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 2          |20         |two                                                                                                                             
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 3          |30         |three                                                                                                                           
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 4          |40         |four                                                                                                                            
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 5          |50         |five                                                                                                                            
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 6          |60         |six                                                                                                                             
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 7          |70         |seven                                                                                                                           
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 No current row
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 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;
+ij(CONNECTION1)> close scan_cursor;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> --------------------------------------------------------------------------------
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> --------------------------------------------------------------------------------
 -- TEST 1: heap cursor scan, group fetch = 2
 -- Test full cursor scan which does no updates.
 --    SERIALIZABLE     - will get table level S lock.
@@ -301,94 +307,94 @@ ij> ------------------------------------
 --------------------------------------------------------------------------------
 CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault','2');
 0 rows inserted/updated/deleted
-ij> -- RESOLVE: missing row locks
+ij(CONNECTION1)> -- RESOLVE: missing row locks
 -- WORKAROUND: creating an index and dropping it 
 -- to force the query 'select a, b, c from a' to be recompiled
 create index ix1 on a(a);
 0 rows inserted/updated/deleted
-ij> drop index ix1;
+ij(CONNECTION1)> drop index ix1;
 0 rows inserted/updated/deleted
-ij> commit;
-ij> get cursor scan_cursor as
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> get cursor scan_cursor as
     'select a, b, c from a';
-ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault', '16');
+ij(CONNECTION1)> 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;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 1          |10         |one                                                                                                                             
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 2          |20         |two                                                                                                                             
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 3          |30         |three                                                                                                                           
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 4          |40         |four                                                                                                                            
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 5          |50         |five                                                                                                                            
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 6          |60         |six                                                                                                                             
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 7          |70         |seven                                                                                                                           
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 No current row
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 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;
+ij(CONNECTION1)> close scan_cursor;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> --------------------------------------------------------------------------------
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> --------------------------------------------------------------------------------
 -- TEST 2: heap cursor scan, group fetch = 1, stop scan in middle of set
 -- Test full cursor scan which does no updates.
 --    SERIALIZABLE     - will get table level S lock.
@@ -398,48 +404,48 @@ ij> ------------------------------------
 --------------------------------------------------------------------------------
 CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault','1');
 0 rows inserted/updated/deleted
-ij> -- RESOLVE: missing row locks
+ij(CONNECTION1)> -- RESOLVE: missing row locks
 -- WORKAROUND: creating an index and dropping it 
 -- to force the query 'select a, b, c from a' to be recompiled
 create index ix1 on a(a);
 0 rows inserted/updated/deleted
-ij> drop index ix1;
+ij(CONNECTION1)> drop index ix1;
 0 rows inserted/updated/deleted
-ij> commit;
-ij> get cursor scan_cursor as
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> get cursor scan_cursor as
     'select a, b, c from a';
-ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault', '16');
+ij(CONNECTION1)> 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;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 1          |10         |one                                                                                                                             
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 2          |20         |two                                                                                                                             
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 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;
+ij(CONNECTION1)> close scan_cursor;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> --------------------------------------------------------------------------------
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> --------------------------------------------------------------------------------
 -- TEST 3: heap cursor scan, group fetch = 4, stop scan in middle of set
 -- Test full cursor scan which does no updates.
 --    SERIALIZABLE     - will get table level S lock.
@@ -449,48 +455,48 @@ ij> ------------------------------------
 --------------------------------------------------------------------------------
 CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault','4');
 0 rows inserted/updated/deleted
-ij> -- RESOLVE: missing row locks
+ij(CONNECTION1)> -- RESOLVE: missing row locks
 -- WORKAROUND: creating an index and dropping it 
 -- to force the query 'select a, b, c from a' to be recompiled
 create index ix1 on a(a);
 0 rows inserted/updated/deleted
-ij> drop index ix1;
+ij(CONNECTION1)> drop index ix1;
 0 rows inserted/updated/deleted
-ij> commit;
-ij> get cursor scan_cursor as
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> get cursor scan_cursor as
     'select a, b, c from a';
-ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault', '16');
+ij(CONNECTION1)> 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;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 1          |10         |one                                                                                                                             
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 2          |20         |two                                                                                                                             
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 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;
+ij(CONNECTION1)> close scan_cursor;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> --------------------------------------------------------------------------------
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> --------------------------------------------------------------------------------
 -- TEST 4: heap cursor scan, group fetch = 1 (scan table with some deleted rows)
 -- Test full cursor scan on a data set with some deleted rows (the "even" ones).
 --    SERIALIZABLE     - will get table level S lock.
@@ -507,8 +513,8 @@ ij> ------------------------------------
 --------------------------------------------------------------------------------
 delete from a where a = 2 or a = 4 or a = 6;
 3 rows inserted/updated/deleted
-ij> commit;
-ij> -- The above delete and commit can allow post commit processing to run before
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> -- The above delete and commit can allow post commit processing to run before
 -- the subsequent select is run, most likely if this run is on a table where
 -- there is one row per page.  To get reproducible results from the subsequent
 -- lock calls, wait for post commit to finish before running the select.  
@@ -517,72 +523,72 @@ ij> -- The above delete and commit can a
 -- on timing.
 CALL WAIT_FOR_POST_COMMIT();
 0 rows inserted/updated/deleted
-ij> CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault','1');
+ij(CONNECTION1)> CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault','1');
 0 rows inserted/updated/deleted
-ij> -- RESOLVE: missing row locks
+ij(CONNECTION1)> -- RESOLVE: missing row locks
 -- WORKAROUND: creating an index and dropping it 
 -- to force the query 'select a, b, c from a' to be recompiled
 create index ix1 on a(a);
 0 rows inserted/updated/deleted
-ij> drop index ix1;
+ij(CONNECTION1)> drop index ix1;
 0 rows inserted/updated/deleted
-ij> commit;
-ij> get cursor scan_cursor as
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> get cursor scan_cursor as
     'select a, b, c from a';
-ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault', '16');
+ij(CONNECTION1)> 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;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 1          |10         |one                                                                                                                             
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 3          |30         |three                                                                                                                           
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 5          |50         |five                                                                                                                            
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 7          |70         |seven                                                                                                                           
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 No current row
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 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;
+ij(CONNECTION1)> close scan_cursor;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> --------------------------------------------------------------------------------
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> --------------------------------------------------------------------------------
 -- TEST 5: heap cursor scan, group fetch = 2 (scan with committed deleted rows)
 -- Test full cursor scan on a data set with some deleted rows (the "even" ones).
 --    SERIALIZABLE     - will get table level S lock.
@@ -597,72 +603,73 @@ ij> ------------------------------------
 -- 5, 50, 'five'
 -- 7, 70, 'seven'
 --------------------------------------------------------------------------------
+
 CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault','2');
 0 rows inserted/updated/deleted
-ij> -- RESOLVE: missing row locks
+ij(CONNECTION1)> -- RESOLVE: missing row locks
 -- WORKAROUND: creating an index and dropping it 
 -- to force the query 'select a, b, c from a' to be recompiled
 create index ix1 on a(a);
 0 rows inserted/updated/deleted
-ij> drop index ix1;
+ij(CONNECTION1)> drop index ix1;
 0 rows inserted/updated/deleted
-ij> commit;
-ij> get cursor scan_cursor as
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> get cursor scan_cursor as
     'select a, b, c from a';
-ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault', '16');
+ij(CONNECTION1)> 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;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 1          |10         |one                                                                                                                             
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 3          |30         |three                                                                                                                           
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 5          |50         |five                                                                                                                            
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 7          |70         |seven                                                                                                                           
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 No current row
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 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;
+ij(CONNECTION1)> close scan_cursor;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> --------------------------------------------------------------------------------
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> --------------------------------------------------------------------------------
 -- TEST 6: heap cursor scan, group fetch = 1 (scan with "<" qualifier)
 -- Test "less than" qualified cursor scan on a data set.
 --    SERIALIZABLE     - will get table level S lock.
@@ -677,36 +684,37 @@ ij> ------------------------------------
 -- 5, 50, 'five'
 -- 7, 70, 'seven'
 --------------------------------------------------------------------------------
+
 CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault','1');
 0 rows inserted/updated/deleted
-ij> get cursor scan_cursor as
+ij(CONNECTION1)> get cursor scan_cursor as
     'select a, b, c from a where a < 3';
-ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault', '16');
+ij(CONNECTION1)> 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;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 1          |10         |one                                                                                                                             
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 No current row
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 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;
+ij(CONNECTION1)> close scan_cursor;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> --------------------------------------------------------------------------------
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> --------------------------------------------------------------------------------
 -- TEST 7: heap cursor scan, group fetch = 2 (scan with "<" qualifier)
 -- Test "less than" qualified cursor scan on a data set.
 --    SERIALIZABLE     - will get table level S lock.
@@ -721,44 +729,45 @@ ij> ------------------------------------
 -- 5, 50, 'five'
 -- 7, 70, 'seven'
 --------------------------------------------------------------------------------
+
 CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault','2');
 0 rows inserted/updated/deleted
-ij> -- RESOLVE: missing row locks
+ij(CONNECTION1)> -- RESOLVE: missing row locks
 -- WORKAROUND: creating an index and dropping it 
 -- to force the statement to be recompiled
 create index ix1 on a(a);
 0 rows inserted/updated/deleted
-ij> drop index ix1;
+ij(CONNECTION1)> drop index ix1;
 0 rows inserted/updated/deleted
-ij> commit;
-ij> get cursor scan_cursor as
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> get cursor scan_cursor as
     'select a, b, c from a where a < 3';
-ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault', '16');
+ij(CONNECTION1)> 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;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 1          |10         |one                                                                                                                             
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 No current row
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 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;
+ij(CONNECTION1)> close scan_cursor;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> --------------------------------------------------------------------------------
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> --------------------------------------------------------------------------------
 -- TEST 8: heap cursor scan, group fetch = 1 (scan with equals qualifier)
 -- Test "equals" qualified cursor scan on a data set.
 --    SERIALIZABLE     - will get table level S lock.
@@ -773,36 +782,37 @@ ij> ------------------------------------
 -- 5, 50, 'five'
 -- 7, 70, 'seven'
 --------------------------------------------------------------------------------
+
 CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault','1');
 0 rows inserted/updated/deleted
-ij> get cursor scan_cursor as
+ij(CONNECTION1)> get cursor scan_cursor as
     'select a, b, c from a where a = 5';
-ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault', '16');
+ij(CONNECTION1)> 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;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 5          |50         |five                                                                                                                            
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 No current row
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 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;
+ij(CONNECTION1)> close scan_cursor;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> --------------------------------------------------------------------------------
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> --------------------------------------------------------------------------------
 -- TEST 9: heap cursor scan, group fetch = 2 (scan with equals qualifier)
 -- Test "equals" qualified cursor scan on a data set.
 --    SERIALIZABLE     - will get table level S lock.
@@ -817,36 +827,37 @@ ij> ------------------------------------
 -- 5, 50, 'five'
 -- 7, 70, 'seven'
 --------------------------------------------------------------------------------
+
 CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault','2');
 0 rows inserted/updated/deleted
-ij> get cursor scan_cursor as
+ij(CONNECTION1)> get cursor scan_cursor as
     'select a, b, c from a where a = 7';
-ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault', '16');
+ij(CONNECTION1)> 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;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 7          |70         |seven                                                                                                                           
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 No current row
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 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;
+ij(CONNECTION1)> close scan_cursor;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> --------------------------------------------------------------------------------
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> --------------------------------------------------------------------------------
 -- TEST 10: heap cursor scan, group fetch = 1 (equals qualifier, no rows return)
 -- Test "equals" qualified cursor scan on a data set, no rows returned.
 --    SERIALIZABLE     - will get table level S lock.
@@ -861,71 +872,73 @@ ij> ------------------------------------
 -- 5, 50, 'five'
 -- 7, 70, 'seven'
 --------------------------------------------------------------------------------
+
 CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault','1');
 0 rows inserted/updated/deleted
-ij> -- RESOLVE: missing row locks
+ij(CONNECTION1)> -- RESOLVE: missing row locks
 -- WORKAROUND: creating an index and dropping it 
 -- to force the statement to be recompiled
 create index ix1 on a(a);
 0 rows inserted/updated/deleted
-ij> drop index ix1;
+ij(CONNECTION1)> drop index ix1;
 0 rows inserted/updated/deleted
-ij> commit;
-ij> get cursor scan_cursor as
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> get cursor scan_cursor as
     'select a, b, c from a where a = 7';
-ij> CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault','16');
+ij(CONNECTION1)> 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;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 7          |70         |seven                                                                                                                           
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 No current row
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 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;
+ij(CONNECTION1)> close scan_cursor;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> drop table a;
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> drop table a;
 0 rows inserted/updated/deleted
-ij> -- non cursor, no index run
+ij(CONNECTION1)> -- non cursor, no index run
     drop table a;
 ERROR 42Y55: 'DROP TABLE' cannot be performed on 'A' because it does not exist.
-ij> -- to create tables of page size 4k and still keep the following tbl 
+ij(CONNECTION1)> -- to create tables of page size 4k and still keep the following tbl 
       -- create table a (a int, b int, c varchar(1900));
+      
     create table a(a int, b int);
 0 rows inserted/updated/deleted
-ij> alter table a add column c varchar(1900);
+ij(CONNECTION1)> alter table a add column c varchar(1900);
 0 rows inserted/updated/deleted
-ij> insert into a values (1, 10, 'one');
+ij(CONNECTION1)> insert into a values (1, 10, 'one');
 1 row inserted/updated/deleted
-ij> insert into a values (2, 20, 'two');
+ij(CONNECTION1)> insert into a values (2, 20, 'two');
 1 row inserted/updated/deleted
-ij> insert into a values (3, 30, 'three');
+ij(CONNECTION1)> insert into a values (3, 30, 'three');
 1 row inserted/updated/deleted
-ij> insert into a values (4, 40, 'four');
+ij(CONNECTION1)> insert into a values (4, 40, 'four');
 1 row inserted/updated/deleted
-ij> insert into a values (5, 50, 'five');
+ij(CONNECTION1)> insert into a values (5, 50, 'five');
 1 row inserted/updated/deleted
-ij> insert into a values (6, 60, 'six');
+ij(CONNECTION1)> insert into a values (6, 60, 'six');
 1 row inserted/updated/deleted
-ij> insert into a values (7, 70, 'seven');
+ij(CONNECTION1)> insert into a values (7, 70, 'seven');
 1 row inserted/updated/deleted
-ij> commit;
-ij> run resource 'readSetLocks.subsql';
-ij> --
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> run resource '/org/apache/derbyTesting/functionTests/tests/store/readSetLocks.subsql';
+ij(CONNECTION1)> --
 --   Licensed to the Apache Software Foundation (ASF) under one or more
 --   contributor license agreements.  See the NOTICE file distributed with
 --   this work for additional information regarding copyright ownership.
@@ -949,13 +962,16 @@ ij> --
 --
 -- assume's caller has already done: run 'LockTableQuery.subsql'; to get 
 -- easy access to the lock VTI.
+
 -- TEST  0: heap scan.
 -- TEST  1: heap scan, some rows deleted.
 -- TEST  2: heap scan, (scan with "<" qualifier)
 -- TEST  3: heap scan, (scan with equals qualifier)
 -- TEST  4: heap scan, (equals qualifier, no rows return)
+
+
 autocommit off;
-ij> --------------------------------------------------------------------------------
+ij(CONNECTION1)> --------------------------------------------------------------------------------
 -- Assumes that calling routine has set up the following simple dataset, 
 -- a heap, no indexes with following initial values:
 --     create table (a int, b int, c somesortofchar);
@@ -977,8 +993,8 @@ A          |B          |C               
 5          |50         |five                                                                                                                            
 6          |60         |six                                                                                                                             
 7          |70         |seven                                                                                                                           
-ij> commit;
-ij> --------------------------------------------------------------------------------
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> --------------------------------------------------------------------------------
 -- TEST 0: heap scan.
 -- Test full cursor scan which does no updates.
 --    SERIALIZABLE     - will get table level S lock, held to end of xact.
@@ -988,6 +1004,7 @@ ij> ------------------------------------
 --                         locks held when statement completes.
 --    READ UNCOMMITTED - TABLE IS, no row locks.  No locks after statement ends.
 --------------------------------------------------------------------------------
+
 select a, b, c from a;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
@@ -998,15 +1015,15 @@ A          |B          |C               
 5          |50         |five                                                                                                                            
 6          |60         |six                                                                                                                             
 7          |70         |seven                                                                                                                           
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> --------------------------------------------------------------------------------
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> --------------------------------------------------------------------------------
 -- TEST 1: heap scan, some rows deleted.
 -- Test full cursor scan on a data set with some deleted rows (the "even" ones).
 --    SERIALIZABLE     - will get table level S lock.
@@ -1029,8 +1046,8 @@ ij> ------------------------------------
 --------------------------------------------------------------------------------
 delete from a where a = 2 or a = 4 or a = 6;
 3 rows inserted/updated/deleted
-ij> commit;
-ij> -- The above delete and commit can allow post commit processing to run before
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> -- The above delete and commit can allow post commit processing to run before
 -- the subsequent select is run, most likely if this run is on a table where
 -- there is one row per page.  To get reproducible results from the subsequent
 -- lock calls, wait for post commit to finish before running the select.  
@@ -1039,22 +1056,22 @@ ij> -- The above delete and commit can a
 -- on timing.
 CALL WAIT_FOR_POST_COMMIT();
 0 rows inserted/updated/deleted
-ij> select a, b, c from a;
+ij(CONNECTION1)> select a, b, c from a;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 1          |10         |one                                                                                                                             
 3          |30         |three                                                                                                                           
 5          |50         |five                                                                                                                            
 7          |70         |seven                                                                                                                           
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> --------------------------------------------------------------------------------
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> --------------------------------------------------------------------------------
 -- TEST 2: heap scan, (scan with "<" qualifier)
 -- Test "less than" qualified cursor scan on a data set.
 --    SERIALIZABLE     - will get table level S lock, held to end of xact.
@@ -1070,6 +1087,7 @@ ij> ------------------------------------
 -- 5, 50, 'five'
 -- 7, 70, 'seven'
 --------------------------------------------------------------------------------
+
 select a, b, c from a;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
@@ -1077,15 +1095,15 @@ A          |B          |C               
 3          |30         |three                                                                                                                           
 5          |50         |five                                                                                                                            
 7          |70         |seven                                                                                                                           
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> --------------------------------------------------------------------------------
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> --------------------------------------------------------------------------------
 -- TEST 3: heap scan, (scan with equals qualifier)
 -- Test "equals" qualified cursor scan on a data set.
 --    SERIALIZABLE     - will get table level S lock, held to end of xact.
@@ -1101,19 +1119,20 @@ ij> ------------------------------------
 -- 5, 50, 'five'
 -- 7, 70, 'seven'
 --------------------------------------------------------------------------------
+
 select a, b, c from a where a = 5;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 5          |50         |five                                                                                                                            
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> --------------------------------------------------------------------------------
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> --------------------------------------------------------------------------------
 -- TEST  4: heap scan, (equals qualifier, no rows return)
 -- Test "equals" qualified cursor scan on a data set, no rows returned.
 --    SERIALIZABLE     - will get table level S lock, held to end of xact.
@@ -1129,48 +1148,50 @@ ij> ------------------------------------
 -- 5, 50, 'five'
 -- 7, 70, 'seven'
 --------------------------------------------------------------------------------
+
 select a, b, c from a where a = 7;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 7          |70         |seven                                                                                                                           
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> drop table a;
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> drop table a;
 0 rows inserted/updated/deleted
-ij> -- cursor, unique index run
+ij(CONNECTION1)> -- cursor, unique index run
     drop table a;
 ERROR 42Y55: 'DROP TABLE' cannot be performed on 'A' because it does not exist.
-ij> -- to create tables of page size 4k and still keep the following tbl 
+ij(CONNECTION1)> -- to create tables of page size 4k and still keep the following tbl 
         -- create table a (a int, b int, c varchar(1900));
+        
     create table a(a int, b int);
 0 rows inserted/updated/deleted
-ij> alter table a add column c varchar(1900);
+ij(CONNECTION1)> alter table a add column c varchar(1900);
 0 rows inserted/updated/deleted
-ij> insert into a values (1, 10, 'one');
+ij(CONNECTION1)> insert into a values (1, 10, 'one');
 1 row inserted/updated/deleted
-ij> insert into a values (2, 20, 'two');
+ij(CONNECTION1)> insert into a values (2, 20, 'two');
 1 row inserted/updated/deleted
-ij> insert into a values (3, 30, 'three');
+ij(CONNECTION1)> insert into a values (3, 30, 'three');
 1 row inserted/updated/deleted
-ij> insert into a values (4, 40, 'four');
+ij(CONNECTION1)> insert into a values (4, 40, 'four');
 1 row inserted/updated/deleted
-ij> insert into a values (5, 50, 'five');
+ij(CONNECTION1)> insert into a values (5, 50, 'five');
 1 row inserted/updated/deleted
-ij> insert into a values (6, 60, 'six');
+ij(CONNECTION1)> insert into a values (6, 60, 'six');
 1 row inserted/updated/deleted
-ij> insert into a values (7, 70, 'seven');
+ij(CONNECTION1)> insert into a values (7, 70, 'seven');
 1 row inserted/updated/deleted
-ij> create unique index a_idx on a (a);
+ij(CONNECTION1)> create unique index a_idx on a (a);
 0 rows inserted/updated/deleted
-ij> commit;
-ij> run resource 'readBtreeCursorLocks.subsql';
-ij> --
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> run resource '/org/apache/derbyTesting/functionTests/tests/store/readBtreeCursorLocks.subsql';
+ij(CONNECTION1)> --
 --   Licensed to the Apache Software Foundation (ASF) under one or more
 --   contributor license agreements.  See the NOTICE file distributed with
 --   this work for additional information regarding copyright ownership.
@@ -1194,6 +1215,7 @@ ij> --
 --
 -- assume's caller has already done: run 'LockTableQuery.subsql'; to get 
 -- easy access to the lock VTI.
+
 -- TEST  0: btree cursor scan, group fetch = 1
 -- TEST  1: btree cursor scan, group fetch = 2
 -- TEST  2: btree cursor scan, group fetch = 1 stop scan in middle of set
@@ -1205,8 +1227,9 @@ ij> --
 -- TEST  8: btree cursor scan, group fetch = 1 (scan with equals qualifier)
 -- TEST  9: btree cursor scan, group fetch = 2 (scan with equals qualifier)
 -- TEST 10: btree cursor scan, group fetch = 1 ("=" qualifier, no rows return)
+
 autocommit off;
-ij> --------------------------------------------------------------------------------
+ij(CONNECTION1)> --------------------------------------------------------------------------------
 -- Assumes that calling routine has set up the following simple dataset, 
 -- a heap, and index with following initial values:
 --     create table a (a int, b int, c somesortofchar, [index_pad]);
@@ -1230,8 +1253,8 @@ A          |B          |C               
 5          |50         |five                                                                                                                            
 6          |60         |six                                                                                                                             
 7          |70         |seven                                                                                                                           
-ij> commit;
-ij> --------------------------------------------------------------------------------
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> --------------------------------------------------------------------------------
 -- TEST 0: btree cursor scan, group fetch = 1
 -- Test full cursor scan which does no updates.
 --    ALL MODES        - TABLE IS, "scan page lockname of form (pageno, 1) 
@@ -1242,95 +1265,95 @@ ij> ------------------------------------
 -------------------------------------------------------------------------------
 CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault','1');
 0 rows inserted/updated/deleted
-ij> -- RESOLVE: missing row locks
+ij(CONNECTION1)> -- RESOLVE: missing row locks
 -- WORKAROUND: creating an index and dropping it 
 -- to force the statement to be recompiled
 create index ix1 on a(a);
 0 rows inserted/updated/deleted
 WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
-ij> drop index ix1;
+ij(CONNECTION1)> drop index ix1;
 ERROR 42X65: Index 'IX1' does not exist.
-ij> commit;
-ij> get cursor scan_cursor as
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> get cursor scan_cursor as
     'select a from a';
-ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault', '16');
+ij(CONNECTION1)> 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;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          
 -----------
 1          
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          
 -----------
 2          
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          
 -----------
 3          
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          
 -----------
 4          
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          
 -----------
 5          

[... 27829 lines stripped ...]


Mime
View raw message