Changeset: 5af5f1b63e0a for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=5af5f1b63e0a Modified Files: MonetDB5/ChangeLog MonetDB5/conf/monetdb5.conf.in sql/src/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.sql sql/src/test/BugTracker-2009/Tests/explain_gives_crash.SF-2741829.sql sql/src/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.sql sql/src/test/BugTracker/Tests/explain.SF-1739353-data.sql sql/src/test/Tests/trace.sql Branch: default Log Message:
Added "sequential_pipe" SQL optimizer pipeline that is (and should be kept!) identical to the default pipeline, except that optimizers mitosis & dataflow are omitted. It is used mainly to make some tests work deterministically, i.e., avoid ambigious EXPLAIN output, by avoiding parallelism. diffs (79 lines): diff -r 37ce5d055a57 -r 5af5f1b63e0a MonetDB5/ChangeLog --- a/MonetDB5/ChangeLog Tue Jul 13 11:47:39 2010 +0200 +++ b/MonetDB5/ChangeLog Tue Jul 13 11:51:14 2010 +0200 @@ -1,6 +1,11 @@ # ChangeLog file for MonetDB5 # This file is updated with Maddlog +* Tue Jul 13 2010 Stefan Manegold <[email protected]> +- Added "sequential_pipe" SQL optimizer pipeline that is (and should be kept!) + identical to the default pipeline, except that optimizers mitosis & dataflow + are omitted. + * Mon Jul 12 2010 Stefan Manegold <[email protected]> - Added "no_mitosis_pipe" SQL optimizer pipeline that is (and should be kept!) identical to the default pipeline, except that optimizer mitosis is omitted. diff -r 37ce5d055a57 -r 5af5f1b63e0a MonetDB5/conf/monetdb5.conf.in --- a/MonetDB5/conf/monetdb5.conf.in Tue Jul 13 11:47:39 2010 +0200 +++ b/MonetDB5/conf/monetdb5.conf.in Tue Jul 13 11:51:14 2010 +0200 @@ -203,6 +203,12 @@ # "unexpected" problems are related to mitosis (and/or mergetable). no_mitosis_pipe=inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,dataflow,history,multiplex,garbageCollector +# The sequential pipe line is (and should be kept!) identical to the default +# pipeline, except that optimizers mitosis & dataflow are omitted. It is +# use mainly to make some tests work deterministically, i.e., avoid +# ambigious output, by avoiding parallelism. +sequential_pipe=inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,history,multiplex,garbageCollector + # The default pipeline used in the November 2009 release nov2009_pipe=inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,dataflow,history,multiplex,garbageCollector diff -r 37ce5d055a57 -r 5af5f1b63e0a sql/src/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.sql --- a/sql/src/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.sql Tue Jul 13 11:47:39 2010 +0200 +++ b/sql/src/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.sql Tue Jul 13 11:51:14 2010 +0200 @@ -1,5 +1,5 @@ -- disable parallelism (mitosis & dataflow) to avoid ambiguous results -set optimizer='inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,history,multiplex,garbageCollector'; +set optimizer='sequential_pipe'; create table SF_2596114 (x double); explain select power(x,2) from SF_2596114; explain select x*x from SF_2596114; diff -r 37ce5d055a57 -r 5af5f1b63e0a sql/src/test/BugTracker-2009/Tests/explain_gives_crash.SF-2741829.sql --- a/sql/src/test/BugTracker-2009/Tests/explain_gives_crash.SF-2741829.sql Tue Jul 13 11:47:39 2010 +0200 +++ b/sql/src/test/BugTracker-2009/Tests/explain_gives_crash.SF-2741829.sql Tue Jul 13 11:51:14 2010 +0200 @@ -1,5 +1,5 @@ -- disable parallelism (mitosis & dataflow) to avoid ambiguous results -set optimizer='inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,history,multiplex,garbageCollector'; +set optimizer='sequential_pipe'; \f csv create table blabla(id integer); select '#~BeginVariableOutput~#'; diff -r 37ce5d055a57 -r 5af5f1b63e0a sql/src/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.sql --- a/sql/src/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.sql Tue Jul 13 11:47:39 2010 +0200 +++ b/sql/src/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.sql Tue Jul 13 11:51:14 2010 +0200 @@ -1,5 +1,5 @@ -- disable parallelism (mitosis & dataflow) to avoid ambiguous results -set optimizer='inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,history,multiplex,garbageCollector'; +set optimizer='sequential_pipe'; create table t2564 (c1 int, c2 int, c3 int); insert into t2564 values (3,1,2); insert into t2564 values (1,2,1); diff -r 37ce5d055a57 -r 5af5f1b63e0a sql/src/test/BugTracker/Tests/explain.SF-1739353-data.sql --- a/sql/src/test/BugTracker/Tests/explain.SF-1739353-data.sql Tue Jul 13 11:47:39 2010 +0200 +++ b/sql/src/test/BugTracker/Tests/explain.SF-1739353-data.sql Tue Jul 13 11:51:14 2010 +0200 @@ -1,3 +1,3 @@ -- disable parallelism (mitosis & dataflow) to avoid ambiguous results -set optimizer='inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,history,multiplex,garbageCollector'; +set optimizer='sequential_pipe'; EXPLAIN SELECT "name" FROM "tables"; diff -r 37ce5d055a57 -r 5af5f1b63e0a sql/src/test/Tests/trace.sql --- a/sql/src/test/Tests/trace.sql Tue Jul 13 11:47:39 2010 +0200 +++ b/sql/src/test/Tests/trace.sql Tue Jul 13 11:51:14 2010 +0200 @@ -1,5 +1,5 @@ -- disable parallelism (mitosis & dataflow) to avoid ambiguous results -set optimizer='inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,history,multiplex,garbageCollector'; +set optimizer='sequential_pipe'; set trace = 'none'; -- non-documented feature to not get any trace output create function tracelog() _______________________________________________ Checkin-list mailing list [email protected] http://mail.monetdb.org/mailman/listinfo/checkin-list
