Update of /cvsroot/monetdb/sql/src/backends/monet5/Tests
In directory sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv1316/Tests
Modified Files:
optimizers.sql optimizers.stable.err optimizers.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: optimizers.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/backends/monet5/Tests/optimizers.stable.out,v
retrieving revision 1.14
retrieving revision 1.15
diff -u -d -r1.14 -r1.15
--- optimizers.stable.out 3 Feb 2010 10:37:19 -0000 1.14
+++ optimizers.stable.out 14 Mar 2010 08:25:50 -0000 1.15
@@ -44,12 +44,14 @@
% single_value, single_value # name
% char, varchar # type
% 15, 175 # length
-[ "optimizer test:",
"inline,remap,evaluate,costModel,coercions,emptySet,aliases,mitosis,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,garbageCollector,dataflow,history,multiplex"
]
+[ "optimizer test:",
"inline,remap,evaluate,costModel,coercions,emptySet,aliases,mitosis,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,dataflow,history,multiplex,garbageCollector"
]
+#select 'optimizer test:',optimizer;
% ., . # table_name
% single_value, single_value # name
% char, varchar # type
-% 15, 3 # length
-[ "optimizer test:", "off" ]
+% 15, 175 # length
+[ "optimizer test:",
"inline,remap,evaluate,costModel,coercions,emptySet,aliases,mitosis,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,dataflow,history,multiplex,garbageCollector"
]
+#select 'optimizer test:',optimizer;
% ., . # table_name
% single_value, single_value # name
% char, varchar # type
@@ -58,8 +60,9 @@
% ., . # table_name
% single_value, single_value # name
% char, varchar # type
-% 15, 0 # length
-[ "optimizer test:", "" ]
+% 15, 175 # length
+[ "optimizer test:",
"inline,remap,evaluate,costModel,coercions,emptySet,aliases,mitosis,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,dataflow,history,multiplex,garbageCollector"
]
+#select 'done';
% . # table_name
% single_value # name
% char # type
Index: optimizers.stable.err
===================================================================
RCS file: /cvsroot/monetdb/sql/src/backends/monet5/Tests/optimizers.stable.err,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -d -r1.7 -r1.8
--- optimizers.stable.err 15 Nov 2009 22:54:48 -0000 1.7
+++ optimizers.stable.err 14 Mar 2010 08:25:50 -0000 1.8
@@ -12,44 +12,50 @@
# 08:05:50 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=gio --port=35043
# 08:05:50 >
-MAPI = mone...@eir:37844
-QUERY = set
optimizer='costModel,coercions,emptySet,accessmode,aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,';
+MAPI = mone...@eir:39446
+QUERY = set optimizer='off';
+ERROR = !SQLException:optimizer: 'garbageCollector' should be used as the last
one
+MAPI = mone...@eir:39446
+QUERY = set optimizer='';
+ERROR = !SQLException:optimizer: 'garbageCollector' should be used as the last
one
+MAPI = mone...@eir:39446
+QUERY = set
optimizer='costModel,coercions,emptySet,accessmode,aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector';
ERROR = !SQLException:optimizer: 'inline' should be the first
-MAPI = mone...@eir:37844
-QUERY = set
optimizer='coercions,emptySet,accessmode,aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,';
+MAPI = mone...@eir:39446
+QUERY = set
optimizer='coercions,emptySet,accessmode,aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector';
ERROR = !SQLException:optimizer: 'inline' should be the first
-MAPI = mone...@eir:37844
-QUERY = set
optimizer='emptySet,accessmode,aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,';
+MAPI = mone...@eir:39446
+QUERY = set
optimizer='emptySet,accessmode,aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector';
ERROR = !SQLException:optimizer: 'inline' should be the first
-MAPI = mone...@eir:37844
-QUERY = set
optimizer='accessmode,aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,';
+MAPI = mone...@eir:39446
+QUERY = set
optimizer='accessmode,aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector';
ERROR = !SQLException:optimizer: 'inline' should be the first
-MAPI = mone...@eir:37844
-QUERY = set
optimizer='aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,';
+MAPI = mone...@eir:39446
+QUERY = set
optimizer='aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector';
ERROR = !SQLException:optimizer: 'inline' should be the first
-MAPI = mone...@eir:37844
-QUERY = set
optimizer='commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,';
+MAPI = mone...@eir:39446
+QUERY = set
optimizer='commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector';
ERROR = !SQLException:optimizer: 'inline' should be the first
-MAPI = mone...@eir:37844
-QUERY = set
optimizer='accumulators,joinPath,deadcode,reduce,garbageCollector,';
+MAPI = mone...@eir:39446
+QUERY = set optimizer='accumulators,joinPath,deadcode,reduce,garbageCollector';
ERROR = !SQLException:optimizer: 'inline' should be the first
-MAPI = mone...@eir:37844
-QUERY = set optimizer='joinPath,deadcode,reduce,garbageCollector,';
+MAPI = mone...@eir:39446
+QUERY = set optimizer='joinPath,deadcode,reduce,garbageCollector';
ERROR = !SQLException:optimizer: 'inline' should be the first
-MAPI = mone...@eir:37844
-QUERY = set optimizer='deadcode,reduce,garbageCollector,';
+MAPI = mone...@eir:39446
+QUERY = set optimizer='deadcode,reduce,garbageCollector';
ERROR = !SQLException:optimizer: 'inline' should be the first
-MAPI = mone...@eir:37844
-QUERY = set optimizer='reduce,garbageCollector,';
+MAPI = mone...@eir:39446
+QUERY = set optimizer='reduce,garbageCollector';
ERROR = !SQLException:optimizer: 'inline' should be the first
-MAPI = mone...@eir:37844
-QUERY = set optimizer='garbageCollector,';
-ERROR = !SQLException:optimizer:Optimizer 'garbageCollector,' pipeline does
not exist, use default pipe instead
-MAPI = mone...@eir:37844
-QUERY = set
optimizer='costModel,coercions,emptySet,accessmode,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,';
+MAPI = mone...@eir:39446
+QUERY = set optimizer='garbageCollector';
+ERROR = !SQLException:optimizer:Optimizer 'garbageCollector' pipeline does not
exist, use default pipe instead
+MAPI = mone...@eir:39446
+QUERY = set
optimizer='costModel,coercions,emptySet,accessmode,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector';
ERROR = !SQLException:optimizer: 'inline' should be the first
-MAPI = mone...@eir:37844
-QUERY = set
optimizer='costModel,coercions,emptySet,accessmode,commonTerms,accumulators,joinPath,deadcode,garbageCollector,';
+MAPI = mone...@eir:39446
+QUERY = set
optimizer='costModel,coercions,emptySet,accessmode,commonTerms,accumulators,joinPath,deadcode,garbageCollector';
ERROR = !SQLException:optimizer: 'inline' should be the first
# 08:05:51 >
Index: optimizers.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/backends/monet5/Tests/optimizers.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- optimizers.sql 15 Nov 2009 22:54:44 -0000 1.3
+++ optimizers.sql 14 Mar 2010 08:25:50 -0000 1.4
@@ -13,30 +13,30 @@
set optimizer='';
select 'optimizer test:',optimizer;
-set
optimizer='costModel,coercions,emptySet,accessmode,aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,';
+set
optimizer='costModel,coercions,emptySet,accessmode,aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector';
-set
optimizer='coercions,emptySet,accessmode,aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,';
+set
optimizer='coercions,emptySet,accessmode,aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector';
-set
optimizer='emptySet,accessmode,aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,';
+set
optimizer='emptySet,accessmode,aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector';
-set
optimizer='accessmode,aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,';
+set
optimizer='accessmode,aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector';
-set
optimizer='aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,';
+set
optimizer='aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector';
-set
optimizer='commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,';
+set
optimizer='commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector';
-set optimizer='accumulators,joinPath,deadcode,reduce,garbageCollector,';
+set optimizer='accumulators,joinPath,deadcode,reduce,garbageCollector';
-set optimizer='joinPath,deadcode,reduce,garbageCollector,';
+set optimizer='joinPath,deadcode,reduce,garbageCollector';
-set optimizer='deadcode,reduce,garbageCollector,';
+set optimizer='deadcode,reduce,garbageCollector';
-set optimizer='reduce,garbageCollector,';
+set optimizer='reduce,garbageCollector';
-set optimizer='garbageCollector,';
+set optimizer='garbageCollector';
-set
optimizer='costModel,coercions,emptySet,accessmode,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,';
+set
optimizer='costModel,coercions,emptySet,accessmode,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector';
-set
optimizer='costModel,coercions,emptySet,accessmode,commonTerms,accumulators,joinPath,deadcode,garbageCollector,';
+set
optimizer='costModel,coercions,emptySet,accessmode,commonTerms,accumulators,joinPath,deadcode,garbageCollector';
select 'done';
------------------------------------------------------------------------------
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
