Update of /cvsroot/monetdb/sql/src/test/bugs/Tests
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv11623/src/test/bugs/Tests
Modified Files:
rangejoin_optimize_bug.sql
Log Message:
removed explain statement modifiers
U rangejoin_optimize_bug.sql
Index: rangejoin_optimize_bug.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/bugs/Tests/rangejoin_optimize_bug.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- rangejoin_optimize_bug.sql 13 Mar 2009 10:24:55 -0000 1.3
+++ rangejoin_optimize_bug.sql 13 Mar 2009 13:24:48 -0000 1.4
@@ -108,17 +108,14 @@
GROUP BY dir,seg,carid,tme ) AS temp_B
GROUP BY dir,seg,tme) AS temp_C;
-explain
UPDATE statistics SET lav = (SELECT floor(avg(prelav.lav)) FROM prelav WHERE
statistics.dir = prelav.dir AND statistics.seg = prelav.seg AND
prelav.time_minute3 <= statistics.time_minute - 1);
select count(*) from statistics where lav is null;
-explain
UPDATE statistics SET lav = (SELECT floor(avg(prelav.lav)) FROM prelav WHERE
statistics.dir = prelav.dir AND statistics.seg = prelav.seg AND
prelav.time_minute3 >= statistics.time_minute - 5);
select count(*) from statistics where lav is null;
-explain
UPDATE statistics SET lav = (SELECT floor(avg(prelav.lav)) FROM prelav WHERE
statistics.dir = prelav.dir AND statistics.seg = prelav.seg AND
prelav.time_minute3 <= statistics.time_minute - 1 AND prelav.time_minute3 >=
statistics.time_minute - 5);
select count(*) from statistics;
------------------------------------------------------------------------------
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
