Update of /cvsroot/monetdb/sql/src/backends/monet5/Tests
In directory
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv26084/src/backends/monet5/Tests
Modified Files:
optimizers.sql
Log Message:
propagated changes of Sunday Nov 15 2009
from the Nov2009 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2009/11/15 - mlkersten: src/backends/monet5/Tests/optimizers.sql,1.2.18.1
Move the validation of the optimizer pipeline to the assignment itself,
rather then checking them on the first call.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Index: optimizers.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/backends/monet5/Tests/optimizers.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- optimizers.sql 1 Jul 2007 14:34:36 -0000 1.2
+++ optimizers.sql 15 Nov 2009 22:54:44 -0000 1.3
@@ -7,46 +7,36 @@
set optimizer='off';
select 'optimizer test:',optimizer;
+set optimizer='on';
+select 'optimizer test:',optimizer;
+
set optimizer='';
select 'optimizer test:',optimizer;
set
optimizer='costModel,coercions,emptySet,accessmode,aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,';
-select 'optimizer test:',optimizer;
set
optimizer='coercions,emptySet,accessmode,aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,';
-select 'optimizer test:',optimizer;
set
optimizer='emptySet,accessmode,aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,';
-select 'optimizer test:',optimizer;
set
optimizer='accessmode,aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,';
-select 'optimizer test:',optimizer;
set
optimizer='aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,';
-select 'optimizer test:',optimizer;
set
optimizer='commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,';
-select 'optimizer test:',optimizer;
set optimizer='accumulators,joinPath,deadcode,reduce,garbageCollector,';
-select 'optimizer test:',optimizer;
set optimizer='joinPath,deadcode,reduce,garbageCollector,';
-select 'optimizer test:',optimizer;
set optimizer='deadcode,reduce,garbageCollector,';
-select 'optimizer test:',optimizer;
set optimizer='reduce,garbageCollector,';
-select 'optimizer test:',optimizer;
set optimizer='garbageCollector,';
-select 'optimizer test:',optimizer;
set
optimizer='costModel,coercions,emptySet,accessmode,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,';
-select 'optimizer test:',optimizer;
set
optimizer='costModel,coercions,emptySet,accessmode,commonTerms,accumulators,joinPath,deadcode,garbageCollector,';
-select 'optimizer test:',optimizer;
select 'done';
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
