db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kmars...@apache.org
Subject svn commit: r591061 - in /db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests: master/largeCodeGen.out tests/lang/largeCodeGen.java
Date Thu, 01 Nov 2007 15:50:01 GMT
Author: kmarsden
Date: Thu Nov  1 08:50:00 2007
New Revision: 591061

URL: http://svn.apache.org/viewvc?rev=591061&view=rev
Log:
DERBY-176 backport to 10.1.  Change largeCodeGen test to open up a new connection for union
testing, because 99,000 paramters causes loss of connection in 10.1


Modified:
    db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/largeCodeGen.out
    db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/tests/lang/largeCodeGen.java

Modified: db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/largeCodeGen.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/largeCodeGen.out?rev=591061&r1=591060&r2=591061&view=diff
==============================================================================
--- db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/largeCodeGen.out
(original)
+++ db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/largeCodeGen.out
Thu Nov  1 08:50:00 2007
@@ -15,8 +15,6 @@
 FAILED QUERY: Logical operators with 900 parameters.
 PASS: PREPARE: IN clause with 3400 parameters
 PASS: IN clause with 3400 parameters
-PASS: PREPARE: IN clause with 97000 parameters
-PASS: IN clause with 97000 parameters
 PASS: PREPARE: IN clause with 98000 parameters
 PASS: IN clause with 98000 parameters
 FAILED QUERY: IN clause with 99000 parameters.

Modified: db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/tests/lang/largeCodeGen.java
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/tests/lang/largeCodeGen.java?rev=591061&r1=591060&r2=591061&view=diff
==============================================================================
--- db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/tests/lang/largeCodeGen.java
(original)
+++ db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/tests/lang/largeCodeGen.java
Thu Nov  1 08:50:00 2007
@@ -48,9 +48,14 @@
         createTestTable(con);
         testLogicalOperators(con);
         testInClause(con);
-        testUnions(con);
-        con.commit();
-        con.close();
+	con.rollback();
+	con.close();
+	// need to make a new connetion for unions as 
+	// 99000 parameters in the in clause causes loss of connection.
+	Connection con2 = ij.startJBMS();
+        testUnions(con2);
+        con2.rollback();
+        con2.close();
     }
     
     private static void createTestTable(Connection con) throws SQLException
@@ -162,11 +167,12 @@
 	  
 		// DERBY-739 raised number of parameters from 2700 to 3400
         // svn 372388 trunk - passed @ 3400
-        // fixes for DERBY-766 to split methods with individual statements
-        // bumps the limit to 98,000 parameters.
-        testInClause(con, 3400);
-		 for (int count = 97000; count <= 200000 ; count += 1000)
+	    testInClause(con,3400);
+		 for (int count = 98000; count <= 100000 ; count += 1000)
 		 {
+		     // In 10.1 when the query fails at 99000 parameter we see 
+		     // a ClassCastException in the derby.log and lose 
+		     //the connection. This is different than trunk.
 			 // keep testing until it fails.
 			 if (testInClause(con, count))
 			 	break;
@@ -217,6 +223,7 @@
 		{
 			createView.append(" UNION ALL (SELECT * FROM t0 )");
 		}
+		String createViewString = createView.toString();
 		//System.out.println(createViewString);
 		stmt.executeUpdate(createView.toString());
 		



Mime
View raw message