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 dj...@apache.org on 2006/01/27 19:14:34 UTC

svn commit: r372934 - /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/largeCodeGen.java

Author: djd
Date: Fri Jan 27 10:14:20 2006
New Revision: 372934

URL: http://svn.apache.org/viewcvs?rev=372934&view=rev
Log:
DERBY-766 Add some comments to largeCodeGen.java indicating what passes
with reference to an svn revision number. Made all the data fetching/execution switchable.
Note this is still not run as a regular test.

Modified:
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/largeCodeGen.java

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/largeCodeGen.java
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/largeCodeGen.java?rev=372934&r1=372933&r2=372934&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/largeCodeGen.java (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/largeCodeGen.java Fri Jan 27 10:14:20 2006
@@ -99,6 +99,7 @@
 	 */
 	private static void testLogicalOperators(Connection con)  throws SQLException {
 		 
+		// svn 372388 trunk - passed @ 400
 		 for (int count = 200; count <= 10000 ; count += 100)
 		 {
 			 // keep testing until it fails with linkage error
@@ -138,6 +139,7 @@
 	private static void testInClause(Connection con)  throws SQLException {
 	  
 		// DERBY-739 raised number of parameters from 2700 to 3400
+        // svn 372388 trunk - passed @ 3400
 		 for (int count = 3300; count <= 10000 ; count += 100)
 		 {
 			 // keep testing until it fails.
@@ -194,7 +196,7 @@
 		//System.out.println(createViewString);
 		stmt.executeUpdate(createView.toString());
 		
-		
+		// svn 372388 trunk - passed @ 900
 		for (int count = 800; count <= 10000; count += 100)
 		{
 			// keep testing until it fails
@@ -229,17 +231,21 @@
 		String selectSQL = selectSQLBuffer.toString();
 		//System.out.println(selectSQL);
         PreparedStatement pstmt = con.prepareStatement(selectSQL);
-        ResultSet rs = pstmt.executeQuery();
-		int numRowsExpected = (numUnions/100 * 100);
-		int numRows = 0;
-		while (rs.next())
-		{
-			numRows++;
-			if ((numRows % 100) == 0)
-			checkRowData(rs);
-		}
-		System.out.println("PASS: " + testName + " Row data check ok");
-        con.commit();
+        System.out.println("PASS: PREPARE: " + testName);
+        if (largeCodeGen.TEST_QUERY_EXECUTION)
+        {
+	        ResultSet rs = pstmt.executeQuery();
+			int numRowsExpected = (numUnions/100 * 100);
+			int numRows = 0;
+			while (rs.next())
+			{
+				numRows++;
+				if ((numRows % 100) == 0)
+				checkRowData(rs);
+			}
+			System.out.println("PASS: EXECUTE " + testName + " Row data check ok");
+	        con.commit();
+        }
         pstmt.close();
         return false;