Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Development" <derby-dev@db.apache.org>
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Subject: svn commit: r590548 - in
 /db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests:
 master/largeCodeGen.out tests/lang/largeCodeGen.java
Date: Wed, 31 Oct 2007 02:46:54 -0000
To: derby-commits@db.apache.org
From: kmarsden@apache.org
Message-Id: <20071031024655.5BACF1A9832@eris.apache.org>

Author: kmarsden
Date: Tue Oct 30 19:46:54 2007
New Revision: 590548

URL: http://svn.apache.org/viewvc?rev=590548&view=rev
Log:
DERBY-766 update largeCodeGen to have master so it can run as harness test.

Merge from trunk revision 372934, 373644


Added:
    db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/largeCodeGen.out
      - copied, changed from r373644, db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/largeCodeGen.out
Modified:
    db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/tests/lang/largeCodeGen.java

Copied: db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/largeCodeGen.out (from r373644, db/derby/code/trunk/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?p2=db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/largeCodeGen.out&p1=db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/largeCodeGen.out&r1=373644&r2=590548&rev=590548&view=diff
==============================================================================
--- db/derby/code/trunk/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 Tue Oct 30 19:46:54 2007
@@ -1,8 +1,21 @@
+PASS: PREPARE: Logical operators with 200 parameters
 PASS: Logical operators with 200 parameters
+PASS: PREPARE: Logical operators with 300 parameters
 PASS: Logical operators with 300 parameters
+PASS: PREPARE: Logical operators with 400 parameters
 PASS: Logical operators with 400 parameters
-FAILED QUERY: Logical operators with 500 parameters.
+PASS: PREPARE: Logical operators with 500 parameters
+PASS: Logical operators with 500 parameters
+PASS: PREPARE: Logical operators with 600 parameters
+PASS: Logical operators with 600 parameters
+PASS: PREPARE: Logical operators with 700 parameters
+PASS: Logical operators with 700 parameters
+PASS: PREPARE: Logical operators with 800 parameters
+PASS: Logical operators with 800 parameters
+FAILED QUERY: Logical operators with 900 parameters.
+PASS: PREPARE: IN clause with 3300 parameters
 PASS: IN clause with 3300 parameters
+PASS: PREPARE: IN clause with 3400 parameters
 PASS: IN clause with 3400 parameters
 FAILED QUERY: IN clause with 3500 parameters.
 PASS: PREPARE: SELECT with 800 unions

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=590548&r1=590547&r2=590548&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 Tue Oct 30 19:46:54 2007
@@ -37,6 +37,7 @@
 public class largeCodeGen
 {
 	private static boolean TEST_QUERY_EXECUTION = true;
+	private static boolean PRINT_FAILURE_EXCEPTION = false;
 	
     public static void main(String argv[]) 
        throws Exception
@@ -160,6 +161,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.
@@ -216,7 +218,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
@@ -251,17 +253,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;
      
@@ -298,11 +304,11 @@
 	 */
 	private static void reportFailure(String testName, Exception e)
 	{
-		System.out.print("FAILED QUERY: " + testName +". ");
+		System.out.println("FAILED QUERY: " + testName +".");
 		if (e instanceof SQLException)
 		{
 			SQLException se = (SQLException) e;
-			while (se != null)
+			while (se != null  && PRINT_FAILURE_EXCEPTION)
 			{
 				se.printStackTrace(System.out);
 				se = se.getNextException();