db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From d..@apache.org
Subject svn commit: r125212 - /incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/inbetween.out /incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/inbetween.sql
Date Fri, 14 Jan 2005 21:42:12 GMT
Author: djd
Date: Fri Jan 14 13:42:11 2005
New Revision: 125212

URL: http://svn.apache.org/viewcvs?view=rev&rev=125212
Log:
Fix inbetween text for linux.

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

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/inbetween.out
Url: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/inbetween.out?view=diff&rev=125212&p1=incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/inbetween.out&r1=125211&p2=incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/inbetween.out&r2=125212
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/inbetween.out
(original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/inbetween.out
Fri Jan 14 13:42:11 2005
@@ -613,7 +613,8 @@
 T       
 --------
 07:30:30
-ij> select p from t;
+ij> -- verify that added predicates getting pushed down
+select p from t;
 P                         
 --------------------------
 NULL                      
@@ -625,8 +626,7 @@
 P                         
 --------------------------
 xxxxxxFILTERED-TIMESTAMPxxxxx
-ij> -- verify that added predicates getting pushed down
-call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1);
+ij> call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1);
 0 rows inserted/updated/deleted
 ij> maximumdisplaywidth 2000;
 ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS();
@@ -635,8 +635,7 @@
 Statement Name: 
 	null
 Statement Text: 
-	-- verify that added predicates getting pushed down
-call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1)
+	call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1)
 Parse Time: 0
 Bind Time: 0
 Optimize Time: 0
@@ -648,7 +647,7 @@
 Begin Execution Timestamp : null
 End Execution Timestamp : null
 Statement Execution Plan Text: 
-null                                                                                    
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                         
+null                                                                                    
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                    
 ij> -- big in lists (test binary search)
 create table big(i int, c char(10));
 0 rows inserted/updated/deleted

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/inbetween.sql
Url: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/inbetween.sql?view=diff&rev=125212&p1=incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/inbetween.sql&r1=125211&p2=incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/inbetween.sql&r2=125212
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/inbetween.sql
(original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/inbetween.sql
Fri Jan 14 13:42:11 2005
@@ -262,10 +262,10 @@
 select t from t;
 select t from t where t in ('12:30:58', '07:20:20', '07:30:30');
 
+-- verify that added predicates getting pushed down
 select p from t;
 select p from t where p in ('1095-09-08 12:30:58.3', '1892-01-01 07:20:20.0', '1892-01-01
07:30:30.0');
 
--- verify that added predicates getting pushed down
 call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1);
 maximumdisplaywidth 2000;
 values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS();

Mime
View raw message