Update of /cvsroot/monetdb/sql/src/test/Tests
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv4764/src/test/Tests
Modified Files:
setoptimizer.stable.err setoptimizer.stable.out
Log Message:
For avg we now always first change to doubles.
With this we can now rewrite all 'avg's into sum/cnt.
approved slight rounding changes
approved output after changes on the optimizers
approved tests which changed because of number of default functions changed
U setoptimizer.stable.out
Index: setoptimizer.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/setoptimizer.stable.out,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -d -r1.7 -r1.8
--- setoptimizer.stable.out 19 May 2009 12:04:35 -0000 1.7
+++ setoptimizer.stable.out 4 Jun 2009 20:27:55 -0000 1.8
@@ -33,23 +33,23 @@
% . # 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"
]
+% 158 # length
+[
"inline,remap,evaluate,costModel,coercions,emptySet,aliases,deadcode,constants,commonTerms,joinPath,deadcode,reduce,garbageCollector,dataflow,history,multiplex"
]
% . # table_name
% single_value # name
% varchar # type
-% 17 # length
-[ "history,multiplex" ]
+% 22 # length
+[ "inline,remap,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"
]
+% 177 # length
+[
"inline,remap,evaluate,costModel,coercions,emptySet,mitosis,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"
]
+% 177 # length
+[
"inline,remap,evaluate,costModel,coercions,emptySet,mitosis,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,garbageCollector,dataflow,history,multiplex"
]
# 20:30:45 >
# 20:30:45 > Done.
U setoptimizer.stable.err
Index: setoptimizer.stable.err
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/setoptimizer.stable.err,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- setoptimizer.stable.err 29 Jun 2007 11:29:31 -0000 1.1
+++ setoptimizer.stable.err 4 Jun 2009 20:27:55 -0000 1.2
@@ -10,6 +10,10 @@
# 00:41:14 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=koala --port=33505
# 00:41:14 >
+MAPI = mone...@alf:33209
+QUERY = select optimizer;
+ERROR = !SQLException:optimizer: 'deadcode' should be used at least once
+ !SQLException:optimizer: pipeline set to
'inline,remap,evaluate,costModel,coercions,emptySet,mitosis,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,garbageCollector,dataflow,history,multiplex'
# 00:41:15 >
# 00:41:15 > Done.
------------------------------------------------------------------------------
OpenSolaris 2009.06 is a cutting edge operating system for enterprises
looking to deploy the next generation of Solaris that includes the latest
innovations from Sun and the OpenSource community. Download a copy and
enjoy capabilities such as Networking, Storage and Virtualization.
Go to: http://p.sf.net/sfu/opensolaris-get
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
