db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kmars...@apache.org
Subject svn commit: r159335 [1/2] - in incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient: forupdate.out runtimeinfo.out scrollCursors1.out wisconsin.out
Date Tue, 29 Mar 2005 00:03:37 GMT
Author: kmarsden
Date: Mon Mar 28 16:03:35 2005
New Revision: 159335

URL: http://svn.apache.org/viewcvs?view=rev&rev=159335
Log:
Client master updates. Isolation not associated with the statement, but the connection per
JDBC, so not encoded in cursor name

Added:
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/runtimeinfo.out
  (with props)
Modified:
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/forupdate.out
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/scrollCursors1.out
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/wisconsin.out

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/forupdate.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/forupdate.out?view=diff&r1=159334&r2=159335
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/forupdate.out
(original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/forupdate.out
Mon Mar 28 16:03:35 2005
@@ -43,7 +43,7 @@
 ----- with a 'cursor not updatable' message
 get cursor c as 'select i, v from t1, t2';
 ij> delete from t1 where current of c;
-ERROR 42X23: Cursor SQL_CURSH200C1 is not updatable.
+ERROR 42X23: Cursor SQL_CURSH000C1 is not updatable.
 ij> --  cursor with same name already exists
 get cursor c as 'select i, v from t1, t2';
 ERROR (no SQLState): Duplicate cursor names are not allowed.
@@ -62,13 +62,13 @@
 ----- we know because the delete is refused with a 'cursor not updatable' message
 get cursor c2 as 'select i, v from t1, t2 for read only';
 ij> delete from t1 where current of c2;
-ERROR 42X23: Cursor SQL_CURSH200C1 is not updatable.
+ERROR 42X23: Cursor SQL_CURSH000C1 is not updatable.
 ij> close c2;
 ij> -- . read only for updatable cursor spec
 ----- we know because the delete is refused with a 'cursor not updatable' message
 get cursor c3 as 'select i, v from t1 where i is not null for read only';
 ij> delete from t1 where current of c3;
-ERROR 42X23: Cursor SQL_CURSH200C1 is not updatable.
+ERROR 42X23: Cursor SQL_CURSH000C1 is not updatable.
 ij> close c3;
 ij> -- . for update col not in select list
 ----- this is allowed:
@@ -167,7 +167,7 @@
 ij> -- i (renamed v in the select) is an integer; but v is still the
 ----- varchar column, so this compiles (gets a no current row error):
 update t1 set v='hello' where current of c5;
-ERROR XCL08: Cursor 'SQL_CURSH200C1' is not on a row.
+ERROR XCL08: Cursor 'SQL_CURSH000C1' is not on a row.
 ij> close c5;
 ij> -- . include duplicate column name
 ----- expect an error:
@@ -219,7 +219,7 @@
 1                                                                                       
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                   
 -----
 Statement Name: 
-	SQL_CURSH200C1
+	SQL_CURSH000C1
 Statement Text: 
 	select i, b from t3 FOR UPDATE
 Parse Time: 0
@@ -264,7 +264,7 @@
 1                                                                                       
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                   
 -----
 Statement Name: 
-	SQL_CURSH200C1
+	SQL_CURSH000C1
 Statement Text: 
 	select i, b from t3  where i = ? FOR UPDATE
 Parse Time: 0
@@ -330,7 +330,7 @@
 1                                                                                       
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                   
 -----
 Statement Name: 
-	SQL_CURSH200C3
+	SQL_CURSH000C3
 Statement Text: 
 	select i, b from t3 where i < ? FOR UPDATE
 Parse Time: 0
@@ -390,7 +390,7 @@
 1                                                                                       
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                   
 -----
 Statement Name: 
-	SQL_CURSH200C3
+	SQL_CURSH000C3
 Statement Text: 
 	select i, b from t3  where b = ? FOR UPDATE
 Parse Time: 0

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/runtimeinfo.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/runtimeinfo.out?view=auto&rev=159335
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/runtimeinfo.out
(added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/runtimeinfo.out
Mon Mar 28 16:03:35 2005
@@ -0,0 +1,65 @@
+Testing Runtimeinfo
+org.apache.derby.drda.NetworkServerControl runtimeinfo 
+----- Derby Network Server Runtime Information ---
+----- Session Information ---------------
+Session # :2
+Database :wombat;create=true
+User :APP
+# Statements:0
+Prepared Statement Information: 
+	Stmt ID		SQLText
+	-------------	-----------
+Session # :3
+-----
+# Connection Threads : 2
+# Active Sessions : 2
+# Waiting  Sessions : 0
+Total Memory : #####	Free Memory : #####
+End test
+Testing Runtimeinfo (locale)
+-----Duser.language=err -Duser.country=DE org.apache.derby.drda.NetworkServerControl runtimeinfo

+----- Derby Network Server Runtime Information ---
+----- Session Information ---------------
+Session # :2
+Database :wombat;create=true
+User :APP
+# Statements:2
+Prepared Statement Information: 
+	Stmt ID		SQLText
+	-------------	-----------
+	SYSSH0001	SELECT count(*) from sys.systables
+	SYSSH0002	VALUES(1)
+Session # :4
+Database :wombat;create=true
+User :APP
+# Statements:2
+Prepared Statement Information: 
+	Stmt ID		SQLText
+	-------------	-----------
+	SYSSH0001	SELECT count(*) from sys.systables
+	SYSSH0002	VALUES(2)
+Session # :5
+Database :wombat;create=true
+User :APP
+# Statements:0
+Prepared Statement Information: 
+	Stmt ID		SQLText
+	-------------	-----------
+Session # :6
+-----
+# Connection Threads : 4
+# Active Sessions : 4
+# Waiting  Sessions : 0
+Total Memory : #####	Free Memory : #####
+End test (locale)
+Testing Runtimeinfo after closing connectiosn
+org.apache.derby.drda.NetworkServerControl runtimeinfo 
+----- Derby Network Server Runtime Information ---
+----- Session Information ---------------
+Session # :7
+-----
+# Connection Threads : 4
+# Active Sessions : 1
+# Waiting  Sessions : 0
+Total Memory : #####	Free Memory : #####
+End test

Propchange: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/runtimeinfo.out
------------------------------------------------------------------------------
    svn:eol-style = native

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/scrollCursors1.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/scrollCursors1.out?view=diff&r1=159334&r2=159335
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/scrollCursors1.out
(original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/scrollCursors1.out
Mon Mar 28 16:03:35 2005
@@ -561,7 +561,7 @@
 1                                                                                       
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                   
 -----
 Statement Name: 
-	SQL_CURSH200C3
+	SQL_CURSH000C3
 Statement Text: 
 	select * from t1
 Parse Time: 0



Mime
View raw message