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 km...@apache.org on 2005/06/02 16:43:07 UTC
svn commit: r179592 - in
/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests:
master/DerbyNetClient/updatableResultSet.out tests/lang/copyfiles.ant
tests/lang/updatableResultSet_sed.properties
Author: kmarsden
Date: Thu Jun 2 07:43:05 2005
New Revision: 179592
URL: http://svn.apache.org/viewcvs?rev=179592&view=rev
Log:
DERBY-320 - Failed test: derbyall/derbynetclientmats/derbynetmats.fail:lang/updatableResultSet.java
created a sed file to filter out
the cursor name. I did this only for DerbyNetClient as this has not been
an issue for embedded.
Contributed by David Van Couvering
Added:
incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/updatableResultSet_sed.properties (with props)
Modified:
incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/updatableResultSet.out
incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/copyfiles.ant
Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/updatableResultSet.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/updatableResultSet.out?rev=179592&r1=179591&r2=179592&view=diff
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/updatableResultSet.out (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/updatableResultSet.out Thu Jun 2 07:43:05 2005
@@ -64,7 +64,7 @@
Make sure that we got CONCUR_UPDATABLE? true
Now attempt a deleteRow without first doing next on the resultset.
SQL State : XCL08
-Got expected exception Cursor 'SQL_CURLH000C8' is not on a row.
+Got expected exception Cursor '<xxx-cursor-name-xxx>' is not on a row.
Now attempt a updateRow without first doing next on the resultset.
updateRow will check if it is on a row or not even though no changes have been made to the row using updateXXX
SQL State : null
@@ -307,14 +307,14 @@
delete using first resultset
attempt to send deleteRow on the same row through a different resultset should throw an exception
SQL State : XCL08
-Got expected exception Cursor 'SQL_CURLH000C52' is not on a row.
+Got expected exception Cursor '<xxx-cursor-name-xxx>' is not on a row.
Move to next row in the 2nd resultset and then delete using the second resultset
Positive Test11 - setting the fetch size to > 1 will be ignored by updatable resultset. Same as updatable cursors
Notice the Fetch Size in run time statistics output.
1
-----
Statement Name:
- SQL_CURLH000C55
+ <xxx-cursor-name-xxx>
Statement Text:
SELECT * FROM t1 FOR UPDATE of c1
Parse Time: 0
Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/copyfiles.ant
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/copyfiles.ant?rev=179592&r1=179591&r2=179592&view=diff
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/copyfiles.ant (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/copyfiles.ant Thu Jun 2 07:43:05 2005
@@ -204,6 +204,7 @@
unlimited2.sql
update.sql
updateCursor_derby.properties
+updatableResultSet_sed.properties
valuesclause.sql
views.sql
wisconsin.sql
Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/updatableResultSet_sed.properties
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/updatableResultSet_sed.properties?rev=179592&view=auto
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/updatableResultSet_sed.properties (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/updatableResultSet_sed.properties Thu Jun 2 07:43:05 2005
@@ -0,0 +1,11 @@
+# Filters and substitutes for SED
+# Multiple patterns for DELETE: comma separated
+# delete=pattern1,pattern2,...,patternn
+# No commas can be allowed in the patterns.
+#
+# Multiple patterns for SUBSTITUTE: comma separated <pattern;substitute> pair
+# substitute=pattern1;substitute1,pattern2;substitute2,...,patternn;substituten
+# No commas or semicolons can be allowed in the patterns/subsitutes.
+---------------------------------------------------------------------------------
+# cursor names appear to change
+substitute=SQL_CURLH.*[0-9];<xxx-cursor-name-xxx>
Propchange: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/updatableResultSet_sed.properties
------------------------------------------------------------------------------
svn:eol-style = native