Update of /cvsroot/monetdb/sql/src/test/Tests
In directory sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv1562/test/Tests
Modified Files:
setoptimizer.stable.err setoptimizer.stable.out
Log Message:
The garbage collection administration has been changed. Every variable record
now comes with an end-of-life field (eolife), which denotes the instruction
whereafter
the BAT variable reference counter can be decremented. The garbage collector is
never called automagically on MAL functions, because there may be other
pressing needs to retain them. This means that MAL functions defined and
used in the context of SQL, and which are not inlined, may cause a leakage.
The garbage collection has become part of each interpreter step.
The new approach makes the SQL/MAL plans half te size as before.
Index: setoptimizer.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/setoptimizer.stable.out,v
retrieving revision 1.17
retrieving revision 1.18
diff -u -d -r1.17 -r1.18
--- setoptimizer.stable.out 21 Feb 2010 12:06:33 -0000 1.17
+++ setoptimizer.stable.out 14 Mar 2010 08:27:24 -0000 1.18
@@ -34,46 +34,49 @@
% single_value # name
% varchar # type
% 175 # length
-[
"inline,remap,evaluate,costModel,coercions,emptySet,aliases,mitosis,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,garbageCollector,dataflow,history,multiplex"
]
+[
"inline,remap,evaluate,costModel,coercions,emptySet,aliases,mitosis,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,dataflow,history,multiplex,garbageCollector"
]
#select optimizer;
% . # table_name
% single_value # name
% varchar # type
-% 31 # length
-[ "inline,remap,deadcode,multiplex" ]
+% 175 # length
+[
"inline,remap,evaluate,costModel,coercions,emptySet,aliases,mitosis,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,dataflow,history,multiplex,garbageCollector"
]
+#select optimizer;
% . # table_name
% single_value # name
% varchar # type
-% 31 # length
-[ "inline,remap,deadcode,multiplex" ]
+% 175 # length
+[
"inline,remap,evaluate,costModel,coercions,emptySet,aliases,mitosis,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,dataflow,history,multiplex,garbageCollector"
]
+#select optimizer;
% . # table_name
% single_value # name
% varchar # type
% 175 # length
-[
"inline,remap,evaluate,costModel,coercions,emptySet,aliases,mitosis,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,garbageCollector,dataflow,history,multiplex"
]
+[
"inline,remap,evaluate,costModel,coercions,emptySet,aliases,mitosis,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,dataflow,history,multiplex,garbageCollector"
]
#select optimizer;
% . # table_name
% single_value # name
% varchar # type
% 175 # length
-[
"inline,remap,evaluate,costModel,coercions,emptySet,aliases,mitosis,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,garbageCollector,dataflow,history,multiplex"
]
+[
"inline,remap,evaluate,costModel,coercions,emptySet,aliases,mitosis,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,dataflow,history,multiplex,garbageCollector"
]
+#select optimizer;
% . # 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"
]
+[
"inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,dataflow,history,multiplex,garbageCollector"
]
#select optimizer;
% . # 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"
]
+[
"inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,dataflow,history,multiplex,garbageCollector"
]
#select optimizer;
% . # 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"
]
+[
"inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,dataflow,history,multiplex,garbageCollector"
]
# 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.7
retrieving revision 1.8
diff -u -d -r1.7 -r1.8
--- setoptimizer.stable.err 1 Jan 2010 20:20:07 -0000 1.7
+++ setoptimizer.stable.err 14 Mar 2010 08:27:23 -0000 1.8
@@ -80,10 +80,13 @@
# 12:49:31 > mclient -lsql -i --host=eir --port=36907
# 12:49:31 >
-MAPI = mone...@eir:33325
+MAPI = mone...@eir:35648
+QUERY = set optimizer='off';
+ERROR = !SQLException:optimizer: 'garbageCollector' should be used as the last
one
+MAPI = mone...@eir:35648
QUERY = set optimizer='default,costModel';
ERROR = !SQLException:optimizer: 'inline' should be the first
-MAPI = mone...@eir:33325
+MAPI = mone...@eir:35648
QUERY = set optimizer='myfamous_pipe';
ERROR = !SQLException:optimizer:Optimizer 'myfamous_pipe' pipeline does not
exist, use default pipe instead
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
