Update of /cvsroot/monetdb/sql/src/test/Tests
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv2518/test/Tests
Modified Files:
Tag: Nov2009
setoptimizer.stable.err setoptimizer.stable.out
Log Message:
More extensive optimizer test
Index: setoptimizer.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/setoptimizer.stable.out,v
retrieving revision 1.10
retrieving revision 1.10.4.1
diff -u -d -r1.10 -r1.10.4.1
--- setoptimizer.stable.out 2 Aug 2009 20:26:41 -0000 1.10
+++ setoptimizer.stable.out 24 Oct 2009 09:40:13 -0000 1.10.4.1
@@ -33,8 +33,8 @@
% . # table_name
% single_value # name
% varchar # type
-% 177 # length
-[
"inline,remap,evaluate,costModel,coercions,emptySet,cluster,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,garbageCollector,dataflow,history,multiplex"
]
+% 182 # length
+[
"inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,accumulators,garbageCollector,dataflow,history,multiplex"
]
% . # table_name
% single_value # name
% varchar # type
@@ -43,13 +43,33 @@
% . # table_name
% single_value # name
% varchar # type
-% 177 # length
-[
"inline,remap,evaluate,costModel,coercions,emptySet,cluster,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,garbageCollector,dataflow,history,multiplex"
]
+% 31 # length
+[ "inline,remap,deadcode,multiplex" ]
% . # table_name
% single_value # name
% varchar # type
-% 177 # length
-[
"inline,remap,evaluate,costModel,coercions,emptySet,cluster,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,garbageCollector,dataflow,history,multiplex"
]
+% 182 # length
+[
"inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,accumulators,garbageCollector,dataflow,history,multiplex"
]
+% . # table_name
+% single_value # name
+% varchar # type
+% 182 # length
+[
"inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,accumulators,garbageCollector,dataflow,history,multiplex"
]
+% . # table_name
+% single_value # name
+% varchar # type
+% 185 # length
+[
"inline,remap,evaluate,costModel,coercions,emptySet,mitosis,aliases,mergetable,deadcode,constants,commonTerms,joinPath,reorder,deadcode,reduce,garbageCollector,dataflow,history,multiplex"
]
+% . # table_name
+% single_value # name
+% varchar # type
+% 169 # length
+[
"inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,garbageCollector,dataflow,history,multiplex"
]
+% . # table_name
+% single_value # name
+% varchar # type
+% 169 # length
+[
"inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,garbageCollector,dataflow,history,multiplex"
]
# 20:30:45 >
# 20:30:45 > Done.
Index: setoptimizer.stable.err
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/setoptimizer.stable.err,v
retrieving revision 1.3
retrieving revision 1.3.4.1
diff -u -d -r1.3 -r1.3.4.1
--- setoptimizer.stable.err 7 Jun 2009 19:45:55 -0000 1.3
+++ setoptimizer.stable.err 24 Oct 2009 09:40:13 -0000 1.3.4.1
@@ -10,6 +10,16 @@
# 00:41:14 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=koala --port=33505
# 00:41:14 >
+MAPI = mone...@eir:32743
+QUERY = select optimizer;
+ERROR = !SQLException:optimizer: 'inline' should be the first
+ !SQLException:optimizer: 'multiplex' should be the last
+ !SQLException:optimizer: 'deadcode' should be used at least once
+ !SQLException:optimizer: Invalid pipeline, use default_pipe instead
+MAPI = mone...@eir:32743
+QUERY = select optimizer;
+ERROR = !SQLException:optimizer:Optimizer 'myfamous_pipe' does not exist, use
default pipe instead
+
# 00:41:15 >
# 00:41:15 > Done.
------------------------------------------------------------------------------
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
