Update of /cvsroot/monetdb/sql/src/test
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv26508/src/test
Modified Files:
setoptimizer.sql
Log Message:
propagated changes of Saturday Oct 24 2009 - Monday Oct 26 2009
from the Nov2009 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2009/10/24 - mlkersten: src/test/setoptimizer.sql,1.1.18.1
More extensive optimizer test
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Index: setoptimizer.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/setoptimizer.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- setoptimizer.sql 21 Jun 2007 08:26:00 -0000 1.1
+++ setoptimizer.sql 26 Oct 2009 10:13:01 -0000 1.2
@@ -3,9 +3,20 @@
select optimizer;
set optimizer='off';
select optimizer;
+set optimizer='off';
+select optimizer;
+
set optimizer='on';
select optimizer;
-set optimizer='off';
-set optimizer='default';
+set optimizer='on';
select optimizer;
+
+set optimizer='mitosis_pipe';
+select optimizer;
+
+-- and some errors
set optimizer='default,costModel';
+select optimizer;
+
+set optimizer='myfamous_pipe';
+select optimizer;
------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
