db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mi...@apache.org
Subject svn commit: r633986 - in /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests: master/TransactionTable.out tests/store/TransactionTable.sql
Date Wed, 05 Mar 2008 19:20:02 GMT
Author: mikem
Date: Wed Mar  5 11:19:56 2008
New Revision: 633986

URL: http://svn.apache.org/viewvc?rev=633986&view=rev
Log:
DERBY-1626

Change test to only look at User transactions.  Was getting intermittent diffs
due to timing of background internal and system transactions.


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

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/TransactionTable.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/TransactionTable.out?rev=633986&r1=633985&r2=633986&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/TransactionTable.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/TransactionTable.out
Wed Mar  5 11:19:56 2008
@@ -19,11 +19,14 @@
 ij> connect 'wombat' as c1;
 ij(C1)> set isolation to rr;
 0 rows inserted/updated/deleted
-ij(C1)> create view xactTable as
+ij(C1)> -- Only look at user transactions.  Depending on timing of background 
+-- threads for post commit and checkpoint there may be system and 
+-- and internal transactions that vary from machine to machine.
+create view xactTable as
 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 syscs_diag.transaction_table
-    where type != 'InternalTransaction';
+    where type = 'UserTransaction';
 0 rows inserted/updated/deleted
 ij(C1)> commit;
 ij(C1)> select * from xactTable order by username, sql_text, status, type;

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/TransactionTable.sql
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/TransactionTable.sql?rev=633986&r1=633985&r2=633986&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/TransactionTable.sql
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/TransactionTable.sql
Wed Mar  5 11:19:56 2008
@@ -19,11 +19,15 @@
 
 connect 'wombat' as c1;
 set isolation to rr;
+
+-- Only look at user transactions.  Depending on timing of background 
+-- threads for post commit and checkpoint there may be system and 
+-- and internal transactions that vary from machine to machine.
 create view xactTable as
 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 syscs_diag.transaction_table
-    where type != 'InternalTransaction';
+    where type = 'UserTransaction';
 commit;
 select * from xactTable order by username, sql_text, status, type;
 



Mime
View raw message