db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From fuzzylo...@apache.org
Subject svn commit: r383062 - in /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests: master/predicatePushdown.out tests/lang/predicatePushdown.sql
Date Sat, 04 Mar 2006 06:46:08 GMT
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 <qozinx@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



Mime
View raw message