db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From d..@apache.org
Subject svn commit: r125120 - /incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/TransactionTable.out /incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/TransactionTable.sql
Date Fri, 14 Jan 2005 00:05:25 GMT
Author: djd
Date: Thu Jan 13 16:05:24 2005
New Revision: 125120

URL: http://svn.apache.org/viewcvs?view=rev&rev=125120
Log:
Fix TransactionTable test for linux build (hopefully).

Modified:
   incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/TransactionTable.out
   incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/TransactionTable.sql

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/TransactionTable.out
Url: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/TransactionTable.out?view=diff&rev=125120&p1=incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/TransactionTable.out&r1=125119&p2=incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/TransactionTable.out&r2=125120
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/TransactionTable.out	(original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/TransactionTable.out	Thu Jan 13 16:05:24 2005
@@ -4,9 +4,9 @@
 ij(C1)> set isolation to rr;
 0 rows inserted/updated/deleted
 ij(C1)> create view xactTable as
-select username, type, status, 
+select username, type, status,
 case when first_instant is NULL then 'readonly' else 'not readonly' end as readOnly, cast(sql_text as varchar(512)) sql_text
-	from new org.apache.derby.diag.TransactionTable() t
+  from new org.apache.derby.diag.TransactionTable() t
     where type != 'InternalTransaction';
 0 rows inserted/updated/deleted
 ij(C1)> commit;
@@ -33,10 +33,10 @@
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 APP                                                                                                                             |UserTransaction               |ACTIVE  |readonly    |select * from xactTable order by username, sql_text, status, type                                                                                                                                                                                                                                                                                                                                                                                                                                                               
 APP                                                                                                                             |UserTransaction               |IDLE    |readonly    |NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
-ij(C1)> select type, lockcount as cnt, mode, tablename, lockname, state 
-	from new org.apache.derby.diag.LockTable() t
-	where tableType <> 'S'  
-	order by lockname, mode, cnt, state;
+ij(C1)> select type, lockcount as cnt, mode, tablename, lockname, state
+from new org.apache.derby.diag.LockTable() t
+where tableType <> 'S' 
+order by lockname, mode, cnt, state;
 TYPE |CNT  |MODE|TABLENAME                                                                                                                       |LOCKNAME            |STATE
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 TABLE|1    |S   |FOO                                                                                                                             |Tablelock           |GRANT
@@ -46,8 +46,8 @@
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 APP                                                                                                                             |UserTransaction               |IDLE    |readonly    |select * from xactTable order by username, sql_text, status, type                                                                                                                                                                                                                                                                                                                                                                                                                                                               
 APP                                                                                                                             |UserTransaction               |IDLE    |readonly    |NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
-ij(C1)> select type, lockcount as cnt, mode, tablename, lockname, state 
-	from new org.apache.derby.diag.LockTable() t ;
+ij(C1)> select type, lockcount as cnt, mode, tablename, lockname, state
+from new org.apache.derby.diag.LockTable() t ;
 TYPE |CNT  |MODE|TABLENAME                                                                                                                       |LOCKNAME            |STATE
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ij(C1)> insert into foo values (1), (3), (5), (7), (9);
@@ -57,10 +57,10 @@
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 APP                                                                                                                             |UserTransaction               |ACTIVE  |not readonly|select * from xactTable order by username, sql_text, status, type                                                                                                                                                                                                                                                                                                                                                                                                                                                               
 APP                                                                                                                             |UserTransaction               |IDLE    |readonly    |NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
-ij(C1)> select type, lockcount as cnt, mode, tablename, lockname, state 
-	from new org.apache.derby.diag.LockTable() t
-	where tableType <> 'S' 
-	order by lockname, mode, cnt, state;
+ij(C1)> select type, lockcount as cnt, mode, tablename, lockname, state
+from new org.apache.derby.diag.LockTable() t
+where tableType <> 'S'
+order by lockname, mode, cnt, state;
 TYPE |CNT  |MODE|TABLENAME                                                                                                                       |LOCKNAME            |STATE
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ROW  |1    |X   |FOO                                                                                                                             |(1,10)              |GRANT
@@ -75,8 +75,8 @@
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 APP                                                                                                                             |UserTransaction               |IDLE    |readonly    |select * from xactTable order by username, sql_text, status, type                                                                                                                                                                                                                                                                                                                                                                                                                                                               
 APP                                                                                                                             |UserTransaction               |IDLE    |readonly    |NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
-ij(C1)> select type, lockcount as cnt, mode, tablename, lockname, state 
-	from new org.apache.derby.diag.LockTable() t;
+ij(C1)> select type, lockcount as cnt, mode, tablename, lockname, state
+from new org.apache.derby.diag.LockTable() t;
 TYPE |CNT  |MODE|TABLENAME                                                                                                                       |LOCKNAME            |STATE
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ij(C1)> insert into foo values (6), (10);
@@ -86,33 +86,31 @@
 ij(C2)> set isolation to rr;
 0 rows inserted/updated/deleted
 ij(C2)> autocommit off;
-ij(C2)> select * from xactTable	order by username, sql_text, status, type;
+ij(C2)> select * from xactTable order by username, sql_text, status, type;
 USERNAME                                                                                                                        |TYPE                          |STATUS  |READONLY    |SQL_TEXT                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-APP                                                                                                                             |UserTransaction               |IDLE    |readonly    |select * from xactTable	order by username, sql_text, status, type                                                                                                                                                                                                                                                                                                                                                                                                                                                               
+APP                                                                                                                             |UserTransaction               |IDLE    |readonly    |select * from xactTable order by username, sql_text, status, type                                                                                                                                                                                                                                                                                                                                                                                                                                                               
 APP                                                                                                                             |UserTransaction               |ACTIVE  |not readonly|NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
 APP                                                                                                                             |UserTransaction               |IDLE    |readonly    |NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
-ij(C2)> select type, lockcount as cnt, mode, tablename, lockname, state 
-	from new org.apache.derby.diag.LockTable() t 
-	where tableType <> 'S' 
-	order by lockname, mode, cnt, state;
+ij(C2)> select type, lockcount as cnt, mode, tablename, lockname, state
+from new org.apache.derby.diag.LockTable() t
+where tableType <> 'S'
+order by lockname, mode, cnt, state;
 TYPE |CNT  |MODE|TABLENAME                                                                                                                       |LOCKNAME            |STATE
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ROW  |1    |X   |FOO                                                                                                                             |(1,12)              |GRANT
 ROW  |1    |X   |FOO                                                                                                                             |(1,13)              |GRANT
 TABLE|2    |IX  |FOO                                                                                                                             |Tablelock           |GRANT
-ij(C2)> -- make sure class alias works
-select * from xactTable	order by username, sql_text, status, type;
+ij(C2)> select * from xactTable order by username, sql_text, status, type;
 USERNAME                                                                                                                        |TYPE                          |STATUS  |READONLY    |SQL_TEXT                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-APP                                                                                                                             |UserTransaction               |ACTIVE  |readonly    |-- make sure class alias works
-select * from xactTable	order by username, sql_text, status, type                                                                                                                                                                                                                                                                                                                                                                                                                               
+APP                                                                                                                             |UserTransaction               |ACTIVE  |readonly    |select * from xactTable order by username, sql_text, status, type                                                                                                                                                                                                                                                                                                                                                                                                                                                               
 APP                                                                                                                             |UserTransaction               |ACTIVE  |not readonly|NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
 APP                                                                                                                             |UserTransaction               |IDLE    |readonly    |NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
-ij(C2)> select type, lockcount as cnt, mode, tablename, lockname, state 
-	from new org.apache.derby.diag.LockTable() t
-	where tableType <> 'S' 
-	order by lockname, mode, cnt, state;
+ij(C2)> select type, lockcount as cnt, mode, tablename, lockname, state
+from new org.apache.derby.diag.LockTable() t
+where tableType <> 'S'
+order by lockname, mode, cnt, state;
 TYPE |CNT  |MODE|TABLENAME                                                                                                                       |LOCKNAME            |STATE
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ROW  |1    |X   |FOO                                                                                                                             |(1,12)              |GRANT
@@ -123,16 +121,16 @@
 A          
 -----------
 1          
-ij(C2)> select * from xactTable	order by username, sql_text, status, type;
+ij(C2)> select * from xactTable order by username, sql_text, status, type;
 USERNAME                                                                                                                        |TYPE                          |STATUS  |READONLY    |SQL_TEXT                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-APP                                                                                                                             |UserTransaction               |ACTIVE  |readonly    |select * from xactTable	order by username, sql_text, status, type                                                                                                                                                                                                                                                                                                                                                                                                                                                               
+APP                                                                                                                             |UserTransaction               |ACTIVE  |readonly    |select * from xactTable order by username, sql_text, status, type                                                                                                                                                                                                                                                                                                                                                                                                                                                               
 APP                                                                                                                             |UserTransaction               |ACTIVE  |not readonly|NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
 APP                                                                                                                             |UserTransaction               |IDLE    |readonly    |NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
-ij(C2)> select type, lockcount as cnt, mode, tablename, lockname, state 
-	from new org.apache.derby.diag.LockTable() t
-	where tableType <> 'S' 
-	order by lockname, mode, cnt, state;
+ij(C2)> select type, lockcount as cnt, mode, tablename, lockname, state
+from new org.apache.derby.diag.LockTable() t
+where tableType <> 'S'
+order by lockname, mode, cnt, state;
 TYPE |CNT  |MODE|TABLENAME                                                                                                                       |LOCKNAME            |STATE
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ROW  |1    |X   |FOO                                                                                                                             |(1,12)              |GRANT
@@ -143,16 +141,16 @@
 TABLE|2    |IX  |FOO                                                                                                                             |Tablelock           |GRANT
 ij(C2)> insert into foo values (2), (4);
 2 rows inserted/updated/deleted
-ij(C2)> select * from xactTable	order by username, sql_text, status, type;
+ij(C2)> select * from xactTable order by username, sql_text, status, type;
 USERNAME                                                                                                                        |TYPE                          |STATUS  |READONLY    |SQL_TEXT                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-APP                                                                                                                             |UserTransaction               |ACTIVE  |not readonly|select * from xactTable	order by username, sql_text, status, type                                                                                                                                                                                                                                                                                                                                                                                                                                                               
+APP                                                                                                                             |UserTransaction               |ACTIVE  |not readonly|select * from xactTable order by username, sql_text, status, type                                                                                                                                                                                                                                                                                                                                                                                                                                                               
 APP                                                                                                                             |UserTransaction               |ACTIVE  |not readonly|NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
 APP                                                                                                                             |UserTransaction               |IDLE    |readonly    |NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
-ij(C2)> select type, lockcount as cnt, mode, tablename, lockname, state 
-	from new org.apache.derby.diag.LockTable() t
-	where tableType <> 'S' 
-	order by lockname, mode, cnt, state;
+ij(C2)> select type, lockcount as cnt, mode, tablename, lockname, state
+from new org.apache.derby.diag.LockTable() t
+where tableType <> 'S'
+order by lockname, mode, cnt, state;
 TYPE |CNT  |MODE|TABLENAME                                                                                                                       |LOCKNAME            |STATE
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ROW  |1    |X   |FOO                                                                                                                             |(1,12)              |GRANT
@@ -167,18 +165,18 @@
 ij(C2)> -- this should block and result in a timeout
 select * from foo;
 ERROR 40XL1: A lock could not be obtained within the time requested
-ij(C2)> -- when this finished rolling back, this transaction should be IDLE
-select * from xactTable	order by username, sql_text, status, type;
+ij(C2)> -- when this finished rolling back, this transaction should be IDLE;
+select * from xactTable order by username, sql_text, status, type;
 USERNAME                                                                                                                        |TYPE                          |STATUS  |READONLY    |SQL_TEXT                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-APP                                                                                                                             |UserTransaction               |IDLE    |readonly    |-- when this finished rolling back, this transaction should be IDLE
-select * from xactTable	order by username, sql_text, status, type                                                                                                                                                                                                                                                                                                                                                                                          
+APP                                                                                                                             |UserTransaction               |IDLE    |readonly    |-- when this finished rolling back, this transaction should be IDLE;
+select * from xactTable order by username, sql_text, status, type                                                                                                                                                                                                                                                                                                                                                                                         
 APP                                                                                                                             |UserTransaction               |ACTIVE  |not readonly|NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
 APP                                                                                                                             |UserTransaction               |IDLE    |readonly    |NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
-ij(C2)> select type, lockcount as cnt, mode, tablename, lockname, state 
-	from new org.apache.derby.diag.LockTable() t
-	where tableType <> 'S' 
-	order by lockname, mode, cnt, state;
+ij(C2)> select type, lockcount as cnt, mode, tablename, lockname, state
+from new org.apache.derby.diag.LockTable() t
+where tableType <> 'S'
+order by lockname, mode, cnt, state;
 TYPE |CNT  |MODE|TABLENAME                                                                                                                       |LOCKNAME            |STATE
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ROW  |1    |X   |FOO                                                                                                                             |(1,12)              |GRANT
@@ -187,16 +185,16 @@
 ij(C2)> -- this should also block
 drop table foo;
 ERROR 40XL1: A lock could not be obtained within the time requested
-ij(C2)> select * from xactTable	order by username, sql_text, status, type;
+ij(C2)> select * from xactTable order by username, sql_text, status, type;
 USERNAME                                                                                                                        |TYPE                          |STATUS  |READONLY    |SQL_TEXT                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-APP                                                                                                                             |UserTransaction               |IDLE    |readonly    |select * from xactTable	order by username, sql_text, status, type                                                                                                                                                                                                                                                                                                                                                                                                                                                               
+APP                                                                                                                             |UserTransaction               |IDLE    |readonly    |select * from xactTable order by username, sql_text, status, type                                                                                                                                                                                                                                                                                                                                                                                                                                                               
 APP                                                                                                                             |UserTransaction               |ACTIVE  |not readonly|NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
 APP                                                                                                                             |UserTransaction               |IDLE    |readonly    |NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
-ij(C2)> select type, lockcount as cnt, mode, tablename, lockname, state 
-	from new org.apache.derby.diag.LockTable() t
-	where tableType <> 'S' 
-	order by lockname, mode, cnt, state;
+ij(C2)> select type, lockcount as cnt, mode, tablename, lockname, state
+from new org.apache.derby.diag.LockTable() t
+where tableType <> 'S'
+order by lockname, mode, cnt, state;
 TYPE |CNT  |MODE|TABLENAME                                                                                                                       |LOCKNAME            |STATE
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ROW  |1    |X   |FOO                                                                                                                             |(1,12)              |GRANT
@@ -205,15 +203,15 @@
 ij(C2)> commit;
 ij(C2)> disconnect;
 ij> set connection c1;
-ij(C1)> select * from xactTable	order by username, sql_text, status, type;
+ij(C1)> select * from xactTable order by username, sql_text, status, type;
 USERNAME                                                                                                                        |TYPE                          |STATUS  |READONLY    |SQL_TEXT                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-APP                                                                                                                             |UserTransaction               |ACTIVE  |not readonly|select * from xactTable	order by username, sql_text, status, type                                                                                                                                                                                                                                                                                                                                                                                                                                                               
+APP                                                                                                                             |UserTransaction               |ACTIVE  |not readonly|select * from xactTable order by username, sql_text, status, type                                                                                                                                                                                                                                                                                                                                                                                                                                                               
 APP                                                                                                                             |UserTransaction               |IDLE    |readonly    |NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
-ij(C1)> select type, lockcount as cnt, mode, tablename, lockname, state 
-	from new org.apache.derby.diag.LockTable() t
-	where tableType <> 'S'
-	order by lockname, mode, cnt, state;
+ij(C1)> select type, lockcount as cnt, mode, tablename, lockname, state
+from new org.apache.derby.diag.LockTable() t
+where tableType <> 'S'
+order by lockname, mode, cnt, state;
 TYPE |CNT  |MODE|TABLENAME                                                                                                                       |LOCKNAME            |STATE
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ROW  |1    |X   |FOO                                                                                                                             |(1,12)              |GRANT
@@ -222,15 +220,15 @@
 ij(C1)> drop table foo;
 0 rows inserted/updated/deleted
 ij(C1)> commit;
-ij(C1)> select * from xactTable	order by username, sql_text, status, type;
+ij(C1)> select * from xactTable order by username, sql_text, status, type;
 USERNAME                                                                                                                        |TYPE                          |STATUS  |READONLY    |SQL_TEXT                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-APP                                                                                                                             |UserTransaction               |IDLE    |readonly    |select * from xactTable	order by username, sql_text, status, type                                                                                                                                                                                                                                                                                                                                                                                                                                                               
+APP                                                                                                                             |UserTransaction               |IDLE    |readonly    |select * from xactTable order by username, sql_text, status, type                                                                                                                                                                                                                                                                                                                                                                                                                                                               
 APP                                                                                                                             |UserTransaction               |IDLE    |readonly    |NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
-ij(C1)> select l.type, lockcount as cnt, mode, tablename, lockname, state 
-	from   new org.apache.derby.diag.LockTable() l right outer join new org.apache.derby.diag.TransactionTable() t
+ij(C1)> select l.type, lockcount as cnt, mode, tablename, lockname, state
+from   new org.apache.derby.diag.LockTable() l right outer join new org.apache.derby.diag.TransactionTable() t
        on l.xid = t.xid where l.tableType <> 'S' and t.type='UserTransaction'
-	order by lockname, mode, cnt, state;
+order by lockname, mode, cnt, state;
 TYPE |CNT  |MODE|TABLENAME                                                                                                                       |LOCKNAME            |STATE
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ij(C1)> commit;

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/TransactionTable.sql
Url: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/TransactionTable.sql?view=diff&rev=125120&p1=incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/TransactionTable.sql&r1=125119&p2=incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/TransactionTable.sql&r2=125120
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/TransactionTable.sql	(original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/TransactionTable.sql	Thu Jan 13 16:05:24 2005
@@ -4,47 +4,47 @@
 connect 'wombat' as c1;
 set isolation to rr;
 create view xactTable as
-select username, type, status, 
+select username, type, status,
 case when first_instant is NULL then 'readonly' else 'not readonly' end as readOnly, cast(sql_text as varchar(512)) sql_text
-	from new org.apache.derby.diag.TransactionTable() t
+  from new org.apache.derby.diag.TransactionTable() t
     where type != 'InternalTransaction';
 commit;
-select * from xactTable order by username, sql_text, status, type; 
+select * from xactTable order by username, sql_text, status, type;
 
 create table foo (a int);
 create index fooi on foo (a);
 
-select * from xactTable order by username, sql_text, status, type; 
+select * from xactTable order by username, sql_text, status, type;
 
 autocommit off;
 select * from foo;
 
-select * from xactTable order by username, sql_text, status, type; 
+select * from xactTable order by username, sql_text, status, type;
 
-select type, lockcount as cnt, mode, tablename, lockname, state 
-	from new org.apache.derby.diag.LockTable() t
-	where tableType <> 'S'  
-	order by lockname, mode, cnt, state;
+select type, lockcount as cnt, mode, tablename, lockname, state
+from new org.apache.derby.diag.LockTable() t
+where tableType <> 'S' 
+order by lockname, mode, cnt, state;
 commit;
-select * from xactTable order by username, sql_text, status, type; 
+select * from xactTable order by username, sql_text, status, type;
 
-select type, lockcount as cnt, mode, tablename, lockname, state 
-	from new org.apache.derby.diag.LockTable() t ;
+select type, lockcount as cnt, mode, tablename, lockname, state
+from new org.apache.derby.diag.LockTable() t ;
 
 
 insert into foo values (1), (3), (5), (7), (9);
-select * from xactTable order by username, sql_text, status, type; 
+select * from xactTable order by username, sql_text, status, type;
 
-select type, lockcount as cnt, mode, tablename, lockname, state 
-	from new org.apache.derby.diag.LockTable() t
-	where tableType <> 'S' 
-	order by lockname, mode, cnt, state;
+select type, lockcount as cnt, mode, tablename, lockname, state
+from new org.apache.derby.diag.LockTable() t
+where tableType <> 'S'
+order by lockname, mode, cnt, state;
 
 commit;
-select * from xactTable order by username, sql_text, status, type; 
+select * from xactTable order by username, sql_text, status, type;
 
-select type, lockcount as cnt, mode, tablename, lockname, state 
-	from new org.apache.derby.diag.LockTable() t; 
+select type, lockcount as cnt, mode, tablename, lockname, state
+from new org.apache.derby.diag.LockTable() t;
 
 
 insert into foo values (6), (10);
@@ -56,86 +56,85 @@
 
 autocommit off;
 
-select * from xactTable	order by username, sql_text, status, type; 
+select * from xactTable order by username, sql_text, status, type;
 
-select type, lockcount as cnt, mode, tablename, lockname, state 
-	from new org.apache.derby.diag.LockTable() t 
-	where tableType <> 'S' 
-	order by lockname, mode, cnt, state;
-
--- make sure class alias works
-select * from xactTable	order by username, sql_text, status, type; 
-
-select type, lockcount as cnt, mode, tablename, lockname, state 
-	from new org.apache.derby.diag.LockTable() t
-	where tableType <> 'S' 
-	order by lockname, mode, cnt, state;
+select type, lockcount as cnt, mode, tablename, lockname, state
+from new org.apache.derby.diag.LockTable() t
+where tableType <> 'S'
+order by lockname, mode, cnt, state;
+
+select * from xactTable order by username, sql_text, status, type;
+
+select type, lockcount as cnt, mode, tablename, lockname, state
+from new org.apache.derby.diag.LockTable() t
+where tableType <> 'S'
+order by lockname, mode, cnt, state;
 
 
 autocommit off;
 
 select * from foo where a < 2;
 
-select * from xactTable	order by username, sql_text, status, type; 
+select * from xactTable order by username, sql_text, status, type;
 
 
-select type, lockcount as cnt, mode, tablename, lockname, state 
-	from new org.apache.derby.diag.LockTable() t
-	where tableType <> 'S' 
-	order by lockname, mode, cnt, state;
+select type, lockcount as cnt, mode, tablename, lockname, state
+from new org.apache.derby.diag.LockTable() t
+where tableType <> 'S'
+order by lockname, mode, cnt, state;
 
 insert into foo values (2), (4);
-select * from xactTable	order by username, sql_text, status, type; 
+select * from xactTable order by username, sql_text, status, type;
 
-select type, lockcount as cnt, mode, tablename, lockname, state 
-	from new org.apache.derby.diag.LockTable() t
-	where tableType <> 'S' 
-	order by lockname, mode, cnt, state;
+select type, lockcount as cnt, mode, tablename, lockname, state
+from new org.apache.derby.diag.LockTable() t
+where tableType <> 'S'
+order by lockname, mode, cnt, state;
 
 -- this should block and result in a timeout
 
 select * from foo;
 
--- when this finished rolling back, this transaction should be IDLE
-select * from xactTable	order by username, sql_text, status, type; 
+-- when this finished rolling back, this transaction should be IDLE;
+select * from xactTable order by username, sql_text, status, type;
 
-select type, lockcount as cnt, mode, tablename, lockname, state 
-	from new org.apache.derby.diag.LockTable() t
-	where tableType <> 'S' 
-	order by lockname, mode, cnt, state;
+select type, lockcount as cnt, mode, tablename, lockname, state
+from new org.apache.derby.diag.LockTable() t
+where tableType <> 'S'
+order by lockname, mode, cnt, state;
 
 
 -- this should also block
 
 drop table foo;
 
-select * from xactTable	order by username, sql_text, status, type; 
+select * from xactTable order by username, sql_text, status, type;
 
-select type, lockcount as cnt, mode, tablename, lockname, state 
-	from new org.apache.derby.diag.LockTable() t
-	where tableType <> 'S' 
-	order by lockname, mode, cnt, state;
+select type, lockcount as cnt, mode, tablename, lockname, state
+from new org.apache.derby.diag.LockTable() t
+where tableType <> 'S'
+order by lockname, mode, cnt, state;
 
 commit;
 disconnect;
 
 set connection c1;
-select * from xactTable	order by username, sql_text, status, type; 
+select * from xactTable order by username, sql_text, status, type;
 
-select type, lockcount as cnt, mode, tablename, lockname, state 
-	from new org.apache.derby.diag.LockTable() t
-	where tableType <> 'S'
-	order by lockname, mode, cnt, state;
+select type, lockcount as cnt, mode, tablename, lockname, state
+from new org.apache.derby.diag.LockTable() t
+where tableType <> 'S'
+order by lockname, mode, cnt, state;
 
 drop table foo;
 
 commit;
-select * from xactTable	order by username, sql_text, status, type; 
+select * from xactTable order by username, sql_text, status, type;
 
-select l.type, lockcount as cnt, mode, tablename, lockname, state 
-	from   new org.apache.derby.diag.LockTable() l right outer join new org.apache.derby.diag.TransactionTable() t
+select l.type, lockcount as cnt, mode, tablename, lockname, state
+from   new org.apache.derby.diag.LockTable() l right outer join new org.apache.derby.diag.TransactionTable() t
        on l.xid = t.xid where l.tableType <> 'S' and t.type='UserTransaction'
-	order by lockname, mode, cnt, state;
+order by lockname, mode, cnt, state;
 
 commit;
 disconnect;

Mime
View raw message