svn commit: r383062 - in /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests: master/predicatePushdown.out tests/lang/predicatePushdown.sql

[fu...@apache.org]

Author: fuzzylogic
Date: Fri Mar  3 22:46:06 2006
New Revision: 383062

URL: http://svn.apache.org/viewcvs?rev=383062&view=rev
Log:
DERBY-805: test fix to prevent truncating query plans in predicatePushdown.sql

Committed for Army Brown <qo...@sbcglobal.net>

Modified:
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/predicatePushdown.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/predicatePushdown.sql

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/predicatePushdown.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/predicatePushdown.out?rev=383062&r1=383061&r2=383062&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/predicatePushdown.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/predicatePushdown.out Fri Mar  3 22:46:06 2006
@@ -111,7 +111,7 @@
 0 rows inserted/updated/deleted
 ij> call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1);
 0 rows inserted/updated/deleted
-ij> maximumdisplaywidth 15000;
+ij> maximumdisplaywidth 20000;
 ij> -- Predicate push-down should occur for next two queries.  Thus we
 -- we should see Index scans for T3 and T4--and this should be the
 -- case regardless of the order of the FROM list.
@@ -6062,7 +6062,17 @@
 									Number of deleted rows visited=0
 									Number of pages visited=1
 									Number of rows qualified=1
-									Number of row&
+									Number of rows visited=2
+									Scan type=btree
+									Tree height=1
+									start position: 
+	>= on first 1 column(s).
+	Ordered null semantics on the following columns: 
+									stop position: 
+	> on first 1 column(s).
+	Ordered null semantics on the following columns: 
+									qualifiers:
+None
 ij> -- Predicates pushed from outer queries shouldn't interfere with inner
 -- predicates for subqueries.  Mostly checking for correct results here.
 select * from

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/predicatePushdown.sql
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/predicatePushdown.sql?rev=383062&r1=383061&r2=383062&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/predicatePushdown.sql (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/predicatePushdown.sql Fri Mar  3 22:46:06 2006
@@ -81,7 +81,7 @@
 create view yyunion as select all ii, jj, kk, aa from yy1 union all select ii, jj, kk, aa from yy1 union all select ii, jj, kk, aa from yy1 union all select ii, jj, kk, aa from yy1 union all select ii, jj, kk, aa from yy1 union all select ii, jj, kk, aa from yy1 union all select ii, jj, kk, aa from yy1 union all select ii, jj, kk, aa from yy1 union all select ii, jj, kk, aa from yy1 union all select ii, jj, kk, aa from yy1 union all select ii, jj, kk, aa from yy1 union all select ii, jj, kk, aa from yy1 union all select ii, jj, kk, aa from yy1 union all select ii, jj, kk, aa from yy1 union all select ii, jj, kk, aa from yy1 union all select ii, jj, kk, aa from yy1 union all select ii, jj, kk, aa from yy1 union all select ii, jj, kk, aa from yy1 union all select ii, jj, kk, aa from yy1 union all select ii, jj, kk, aa from yy1 union all select ii, jj, kk, aa from yy1 union all select ii, jj, kk, aa from yy1 union all select ii, jj, kk, aa from yy1 union all select ii, jj, kk, 
 aa from yy1 union all select ii, jj, kk, aa from yy1;
 
 call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1);
-maximumdisplaywidth 15000;
+maximumdisplaywidth 20000;
 
 -- Predicate push-down should occur for next two queries.  Thus we
 -- we should see Index scans for T3 and T4--and this should be the