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 [5/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/updatelocksJDBC30.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/updatelocksJDBC30.out?rev=1341046&r1=1341045&r2=1341046&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/updatelocksJDBC30.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/updatelocksJDBC30.out 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,
@@ -201,87 +201,87 @@ ij> ------------------------------------
get with hold cursor scan_cursor as
'select a, b, c from a for update';
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 |IX |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |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 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,7) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,7) |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 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,8) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,8) |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 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,9) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,9) |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 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,10) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,10) |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 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,11) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,11) |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 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,12) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,12) |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 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,13) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,13) |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 |IX |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |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
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
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 full cursor scan which deletes "even" rows.
@@ -291,18 +291,18 @@ ij> ------------------------------------
get with hold cursor scan_cursor as
'select a, b, c from a for update';
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 |IX |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |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 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,7) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,7) |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
@@ -310,21 +310,21 @@ A |B |C
ij> delete from a where current of scan_cursor;
1 row 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 |2 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,8) |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,8) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |2 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,8) |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,8) |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 |2 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,9) |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,8) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |2 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,9) |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,8) |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
@@ -332,23 +332,23 @@ A |B |C
ij> delete from a where current of scan_cursor;
1 row 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 |3 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,10) |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,10) |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,8) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |3 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,10) |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,10) |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,8) |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 |3 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,11) |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,10) |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,8) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |3 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,11) |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,10) |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,8) |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
@@ -356,42 +356,42 @@ A |B |C
ij> delete from a where current of scan_cursor;
1 row 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 |4 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,12) |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,10) |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,12) |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,8) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |4 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,12) |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,10) |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,12) |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,8) |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 |4 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,13) |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,10) |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,12) |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,8) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |4 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,13) |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,10) |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,12) |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,8) |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 |4 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,10) |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,12) |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,8) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |4 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,10) |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,12) |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,8) |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
----------------------------------------------------------------------------
-APP |UserTran|TABLE |4 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,10) |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,12) |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,8) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |4 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,10) |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,12) |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,8) |GRANT|ACTIVE
ij> commit;
ij> -- 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
@@ -403,8 +403,8 @@ ij> -- The above delete and commit can a
CALL WAIT_FOR_POST_COMMIT();
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
----------------------------------------------------------------------------
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
ij> commit;
ij> select * from a;
A |B |C
@@ -428,60 +428,60 @@ ij> ------------------------------------
get with hold cursor scan_cursor as
'select a, b, c from a for update';
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 |IX |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |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 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,7) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,7) |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 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,9) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,9) |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 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,11) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,11) |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 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,13) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,13) |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 |IX |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |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
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
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> select * from a;
A |B |C
@@ -505,18 +505,18 @@ ij> ------------------------------------
get with hold cursor scan_cursor as
'select a, b, c from a for update';
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 |IX |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |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 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,7) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,7) |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
@@ -524,11 +524,11 @@ A |B |C
ij> update a set a=-3,b=-30,c='-three' where current of scan_cursor;
1 row 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 |2 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,9) |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,9) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |2 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,9) |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,9) |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
@@ -536,42 +536,42 @@ A |B |C
ij> update a set a=-5,b=-50,c='-five' where current of scan_cursor;
1 row 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 |3 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,11) |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,11) |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,9) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |3 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,11) |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,11) |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,9) |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 |3 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,13) |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,11) |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,9) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |3 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,13) |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,11) |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,9) |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 |3 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,11) |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,9) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |3 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,11) |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,9) |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
----------------------------------------------------------------------------
-APP |UserTran|TABLE |3 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,11) |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,9) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |3 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,11) |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,9) |GRANT|ACTIVE
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> select * from a;
A |B |C
@@ -593,42 +593,42 @@ ij> ------------------------------------
get with hold cursor scan_cursor as
'select a, b, c from a where a < 0 for update';
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 |IX |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |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 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,9) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,9) |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 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,11) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,11) |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 |IX |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |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
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
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> select * from a;
A |B |C
@@ -650,9 +650,9 @@ ij> ------------------------------------
get with hold cursor scan_cursor as
'select a, b, c from a where a > 0 for update';
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 |IX |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
@@ -660,11 +660,11 @@ A |B |C
ij> delete from a where current of scan_cursor;
1 row 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 |2 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,7) |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,7) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |2 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,7) |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,7) |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
@@ -672,27 +672,27 @@ A |B |C
ij> delete from a where current of scan_cursor;
1 row 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 |3 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,13) |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,13) |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,7) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |3 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,13) |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,13) |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,7) |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 |3 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,13) |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,7) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |3 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,13) |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,7) |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
----------------------------------------------------------------------------
-APP |UserTran|TABLE |3 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,13) |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,7) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |3 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,13) |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,7) |GRANT|ACTIVE
ij> commit;
ij> -- 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
@@ -704,8 +704,8 @@ ij> -- The above delete and commit can a
CALL WAIT_FOR_POST_COMMIT();
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
----------------------------------------------------------------------------
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
ij> commit;
ij> select * from a;
A |B |C
@@ -723,9 +723,9 @@ ij> ------------------------------------
get with hold cursor scan_cursor as
'select a, b, c from a where a >= -5 for update';
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 |IX |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
@@ -733,31 +733,31 @@ A |B |C
ij> update a set a=3,b=30,c='three' where current of scan_cursor;
1 row 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 |2 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,9) |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,9) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |2 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,9) |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,9) |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 |2 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,11) |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,9) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |2 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,11) |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,9) |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
----------------------------------------------------------------------------
-APP |UserTran|TABLE |2 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,9) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |2 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,9) |GRANT|ACTIVE
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> select * from a;
A |B |C
@@ -775,9 +775,9 @@ ij> ------------------------------------
get with hold cursor scan_cursor as
'select a, b, c from a where a >= -5 for update';
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 |IX |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
@@ -785,11 +785,11 @@ A |B |C
ij> update a set a=33,b=3030,c='threethree' where current of scan_cursor;
1 row 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 |2 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,9) |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,9) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |2 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,9) |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,9) |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
@@ -797,19 +797,19 @@ A |B |C
ij> delete from a where current of scan_cursor;
1 row 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 |3 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,11) |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,11) |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,9) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |3 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,11) |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,11) |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,9) |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
----------------------------------------------------------------------------
-APP |UserTran|TABLE |3 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,11) |GRANT|ACTIVE
-APP |UserTran|ROW |1 |X |A |(1,9) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |3 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,11) |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |X |A |(1,9) |GRANT|ACTIVE
ij> commit;
ij> -- 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
@@ -821,8 +821,8 @@ ij> -- The above delete and commit can a
CALL WAIT_FOR_POST_COMMIT();
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
----------------------------------------------------------------------------
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
ij> commit;
ij> -------------------------------------------------------------------------------
-- At this point the table should look like:
@@ -919,87 +919,87 @@ ij> ------------------------------------
get with hold cursor scan_cursor as
'select a, b, c from a where a >= 1 and a < 20 for update of b, c';
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 |IX |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |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 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,7) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,7) |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 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,8) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,8) |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 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,9) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,9) |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 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,10) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,10) |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 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,11) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,11) |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 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,12) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,12) |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 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,13) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,13) |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 |IX |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |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
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
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 full cursor scan which does no updates, which exits in middle of scan.
@@ -1007,54 +1007,54 @@ ij> ------------------------------------
get with hold cursor scan_cursor as
'select a, b, c from a where a >= 1 and a < 20 for update of b, c';
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 |IX |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |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 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,7) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,7) |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 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,8) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,8) |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 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,9) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,9) |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 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,10) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,10) |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
----------------------------------------------------------------------------
-APP |UserTran|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
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 full cursor scan which deletes "even" rows.
@@ -1062,45 +1062,45 @@ ij> ------------------------------------
get with hold cursor scan_cursor as
'select a, b, c from a where a >= 1 and a < 20 for update of b, c';
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 |IX |A |Tablelock |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |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 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,7) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,7) |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 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,8) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,8) |GRANT|ACTIVE
ij> delete from a where current of scan_cursor;
1 row 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 |3 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,8) |GRANT|ACTIVE
-APP |UserTran|ROW |2 |X |A |(1,8) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |3 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,8) |GRANT|ACTIVE
+APP |UserTransaction|ROW |2 |X |A |(1,8) |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 |3 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,9) |GRANT|ACTIVE
-APP |UserTran|ROW |2 |X |A |(1,8) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |3 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,9) |GRANT|ACTIVE
+APP |UserTransaction|ROW |2 |X |A |(1,8) |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
--------------------------------------------------------------------------------------------------------------------------------------------------------
@@ -1108,23 +1108,23 @@ A |B |C
ij> delete from a where current of scan_cursor;
1 row 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 |5 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,10) |GRANT|ACTIVE
-APP |UserTran|ROW |2 |X |A |(1,10) |GRANT|ACTIVE
-APP |UserTran|ROW |2 |X |A |(1,8) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |5 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,10) |GRANT|ACTIVE
+APP |UserTransaction|ROW |2 |X |A |(1,10) |GRANT|ACTIVE
+APP |UserTransaction|ROW |2 |X |A |(1,8) |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 |5 |IX |A |Tablelock |GRANT|ACTIVE
-APP |UserTran|ROW |1 |U |A |(1,11) |GRANT|ACTIVE
-APP |UserTran|ROW |2 |X |A |(1,10) |GRANT|ACTIVE
-APP |UserTran|ROW |2 |X |A |(1,8) |GRANT|ACTIVE
+USERNAME|TRANTYPE |TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
+----------------------------------------------------------------------------------
+APP |UserTransaction|TABLE |5 |IX |A |Tablelock |GRANT|ACTIVE
+APP |UserTransaction|ROW |1 |U |A |(1,11) |GRANT|ACTIVE
+APP |UserTransaction|ROW |2 |X |A |(1,10) |GRANT|ACTIVE
+APP |UserTransaction|ROW |2 |X |A |(1,8) |GRANT|ACTIVE
ij> next scan_cursor;
A |B |C
[... 17836 lines stripped ...]