Update of /cvsroot/monetdb/sql/src/backends/monet5/Tests
In directory
sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv9464/src/backends/monet5/Tests
Modified Files:
optimizers.sql
Added Files:
All optimizers.stable.err optimizers.stable.out
optimizers.stable.out.Five
Log Message:
propagated changes of Thursday Jun 28 2007 - Sunday Jul 01 2007
from the SQL_2-18 branch to the development trunk
NOTE:
I hope, I resolved the conflicts in
src/backends/monet4/sql_server.mx
src/backends/monet5/sql.mx
src/backends/monet5/sql_optimizer.mx
src/test/Dependencies/Tests/Dependencies.stable.out
correctly --- please double-check!
--- NEW FILE: optimizers.stable.out ---
stdout of test 'optimizers` in directory 'src/backends/monet5` itself:
# 15:38:00 >
# 15:38:00 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/dbfarm"
--set "sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_open=true --set mapi_port=36880 --set xrpc_port=42877 --set
monet_prompt= --trace "--dbname=mTests_src_backends_monet5" --dbinit="
module(sql_server);" ; echo ; echo Over..
# 15:38:00 >
# Monet Database Server V4.18.0
# Copyright (c) 1993-2007, CWI. All rights reserved.
# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs; dynamically
linked.
# Visit http://monetdb.cwi.nl/ for further information.
printf("\nReady.\n");
Ready.
quit();
Over..
# 15:38:00 >
# 15:38:00 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=koala --port=36880
# 15:38:00 >
% ., . # table_name
% single_value, single_value # name
% char, varchar # type
% 15, 3 # length
[ "optimizer test:", "yes" ]
% ., . # table_name
% single_value, single_value # name
% char, varchar # type
% 15, 3 # length
[ "optimizer test:", "off" ]
% ., . # table_name
% single_value, single_value # name
% char, varchar # type
% 15, 0 # length
[ "optimizer test:", "" ]
% ., . # table_name
% single_value, single_value # name
% char, varchar # type
% 15, 115 # length
[ "optimizer test:",
"costModel,coercions,emptySet,accessmode,aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,"
]
% ., . # table_name
% single_value, single_value # name
% char, varchar # type
% 15, 105 # length
[ "optimizer test:",
"coercions,emptySet,accessmode,aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,"
]
% ., . # table_name
% single_value, single_value # name
% char, varchar # type
% 15, 95 # length
[ "optimizer test:",
"emptySet,accessmode,aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,"
]
% ., . # table_name
% single_value, single_value # name
% char, varchar # type
% 15, 86 # length
[ "optimizer test:",
"accessmode,aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,"
]
% ., . # table_name
% single_value, single_value # name
% char, varchar # type
% 15, 75 # length
[ "optimizer test:",
"aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,"
]
% ., . # table_name
% single_value, single_value # name
% char, varchar # type
% 15, 67 # length
[ "optimizer test:",
"commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector," ]
% ., . # table_name
% single_value, single_value # name
% char, varchar # type
% 15, 55 # length
[ "optimizer test:",
"accumulators,joinPath,deadcode,reduce,garbageCollector," ]
% ., . # table_name
% single_value, single_value # name
% char, varchar # type
% 15, 42 # length
[ "optimizer test:", "joinPath,deadcode,reduce,garbageCollector," ]
% ., . # table_name
% single_value, single_value # name
% char, varchar # type
% 15, 33 # length
[ "optimizer test:", "deadcode,reduce,garbageCollector," ]
% ., . # table_name
% single_value, single_value # name
% char, varchar # type
% 15, 24 # length
[ "optimizer test:", "reduce,garbageCollector," ]
% ., . # table_name
% single_value, single_value # name
% char, varchar # type
% 15, 17 # length
[ "optimizer test:", "garbageCollector," ]
% ., . # table_name
% single_value, single_value # name
% char, varchar # type
% 15, 107 # length
[ "optimizer test:",
"costModel,coercions,emptySet,accessmode,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,"
]
% ., . # table_name
% single_value, single_value # name
% char, varchar # type
% 15, 100 # length
[ "optimizer test:",
"costModel,coercions,emptySet,accessmode,commonTerms,accumulators,joinPath,deadcode,garbageCollector,"
]
% . # table_name
% single_value # name
% char # type
% 4 # length
[ "done" ]
# 15:38:00 >
# 15:38:00 > Done.
# 15:38:00 >
--- NEW FILE: optimizers.stable.err ---
stderr of test 'optimizers` in directory 'src/backends/monet5` itself:
# 08:05:50 >
# 08:05:50 > Mtimeout -timeout 180 mserver5
"--config=/ufs/mk/monet5stable/Linux/etc/monetdb5.conf" --debug=10 --set
"monet_mod_path=/ufs/mk/monet5stable//Linux/lib/MonetDB5:/ufs/mk/monet5stable//Linux/lib/MonetDB5/lib:/ufs/mk/monet5stable//Linux/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/mk/monet5stable//dbfarm" --set
"sql_logdir=/ufs/mk/monet5stable//dblogs/logs/sql" --set
"xquery_logdir=/ufs/mk/monet5stable//Linux/var/MonetDB5/xquery_logs" --set
mapi_open=true --set mapi_port=35043 --set xrpc_port=43626 --set monet_prompt=
--trace "--dbname=mTests_src_backends_monet5" --dbinit=' include sql;' ; echo ;
echo Over..
# 08:05:50 >
#warning: please don't forget to set your vault key!
#(see /ufs/mk/monet5stable/Linux/etc/monetdb5.conf)
# 08:05:50 >
# 08:05:50 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=gio --port=35043
# 08:05:50 >
# 08:05:51 >
# 08:05:51 > Done.
# 08:05:51 >
--- NEW FILE: All ---
optimizers
--- NEW FILE: optimizers.stable.out.Five ---
stdout of test 'optimizers` in directory 'src/backends/monet5` itself:
# 08:05:50 >
# 08:05:50 > Mtimeout -timeout 180 mserver5
"--config=/ufs/mk/monet5stable/Linux/etc/monetdb5.conf" --debug=10 --set
"monet_mod_path=/ufs/mk/monet5stable//Linux/lib/MonetDB5:/ufs/mk/monet5stable//Linux/lib/MonetDB5/lib:/ufs/mk/monet5stable//Linux/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/mk/monet5stable//dbfarm" --set
"sql_logdir=/ufs/mk/monet5stable//dblogs/logs/sql" --set
"xquery_logdir=/ufs/mk/monet5stable//Linux/var/MonetDB5/xquery_logs" --set
mapi_open=true --set mapi_port=35043 --set xrpc_port=43626 --set monet_prompt=
--trace "--dbname=mTests_src_backends_monet5" --dbinit=' include sql;' ; echo ;
echo Over..
# 08:05:50 >
!WARNING: GDKlockHome: ignoring empty or invalid .gdk_lock.
!WARNING: BBPdir: initializing BBP.
# MonetDB Server v5.0.1
# Copyright (c) 1993-2007 CWI, all rights reserved
# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically linked
# dbname:mTests_src_backends_monet5
# Visit http://monetdb.cwi.nl/ for further information
Ready.
Over..
# 08:05:50 >
# 08:05:50 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=gio --port=35043
# 08:05:50 >
% ., . # table_name
% single_value, single_value # name
% char, varchar # type
% 15, 146 # length
[ "optimizer test:",
"inline,remap,evaluate,costModel,coercions,emptySet,accessmode,aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,multiplex"
]
% ., . # table_name
% single_value, single_value # name
% char, varchar # type
% 15, 3 # length
[ "optimizer test:", "off" ]
% ., . # table_name
% single_value, single_value # name
% char, varchar # type
% 15, 0 # length
[ "optimizer test:", "" ]
% ., . # table_name
% single_value, single_value # name
% char, varchar # type
% 15, 115 # length
[ "optimizer test:",
"costModel,coercions,emptySet,accessmode,aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,"
]
% ., . # table_name
% single_value, single_value # name
% char, varchar # type
% 15, 105 # length
[ "optimizer test:",
"coercions,emptySet,accessmode,aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,"
]
% ., . # table_name
% single_value, single_value # name
% char, varchar # type
% 15, 95 # length
[ "optimizer test:",
"emptySet,accessmode,aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,"
]
% ., . # table_name
% single_value, single_value # name
% char, varchar # type
% 15, 86 # length
[ "optimizer test:",
"accessmode,aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,"
]
% ., . # table_name
% single_value, single_value # name
% char, varchar # type
% 15, 75 # length
[ "optimizer test:",
"aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,"
]
% ., . # table_name
% single_value, single_value # name
% char, varchar # type
% 15, 67 # length
[ "optimizer test:",
"commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector," ]
% ., . # table_name
% single_value, single_value # name
% char, varchar # type
% 15, 55 # length
[ "optimizer test:",
"accumulators,joinPath,deadcode,reduce,garbageCollector," ]
% ., . # table_name
% single_value, single_value # name
% char, varchar # type
% 15, 42 # length
[ "optimizer test:", "joinPath,deadcode,reduce,garbageCollector," ]
% ., . # table_name
% single_value, single_value # name
% char, varchar # type
% 15, 33 # length
[ "optimizer test:", "deadcode,reduce,garbageCollector," ]
% ., . # table_name
% single_value, single_value # name
% char, varchar # type
% 15, 24 # length
[ "optimizer test:", "reduce,garbageCollector," ]
% ., . # table_name
% single_value, single_value # name
% char, varchar # type
% 15, 17 # length
[ "optimizer test:", "garbageCollector," ]
% ., . # table_name
% single_value, single_value # name
% char, varchar # type
% 15, 107 # length
[ "optimizer test:",
"costModel,coercions,emptySet,accessmode,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,"
]
% ., . # table_name
% single_value, single_value # name
% char, varchar # type
% 15, 100 # length
[ "optimizer test:",
"costModel,coercions,emptySet,accessmode,commonTerms,accumulators,joinPath,deadcode,garbageCollector,"
]
% . # table_name
% single_value # name
% char # type
% 4 # length
[ "done" ]
# 08:05:51 >
# 08:05:51 > Done.
# 08:05:51 >
Index: optimizers.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/backends/monet5/Tests/optimizers.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- optimizers.sql 9 Dec 2006 17:32:00 -0000 1.1
+++ optimizers.sql 1 Jul 2007 14:34:36 -0000 1.2
@@ -3,66 +3,50 @@
-- errors due to dependencies.
select 'optimizer test:',optimizer;
-select count(*) from tables;
set optimizer='off';
select 'optimizer test:',optimizer;
-select count(*) from tables;
set optimizer='';
select 'optimizer test:',optimizer;
-select count(*) from tables;
-set
optimizer='costModel,coercions,emptySet,modes,aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,';
+set
optimizer='costModel,coercions,emptySet,accessmode,aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,';
select 'optimizer test:',optimizer;
-select count(*) from tables;
-set
optimizer='coercions,emptySet,modes,aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,';
+set
optimizer='coercions,emptySet,accessmode,aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,';
select 'optimizer test:',optimizer;
-select count(*) from tables;
-set
optimizer='emptySet,modes,aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,';
+set
optimizer='emptySet,accessmode,aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,';
select 'optimizer test:',optimizer;
-select count(*) from tables;
-set
optimizer='modes,aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,';
+set
optimizer='accessmode,aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,';
select 'optimizer test:',optimizer;
-select count(*) from tables;
set
optimizer='aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,';
select 'optimizer test:',optimizer;
-select count(*) from tables;
set
optimizer='commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,';
select 'optimizer test:',optimizer;
-select count(*) from tables;
set optimizer='accumulators,joinPath,deadcode,reduce,garbageCollector,';
select 'optimizer test:',optimizer;
-select count(*) from tables;
set optimizer='joinPath,deadcode,reduce,garbageCollector,';
select 'optimizer test:',optimizer;
-select count(*) from tables;
set optimizer='deadcode,reduce,garbageCollector,';
select 'optimizer test:',optimizer;
-select count(*) from tables;
set optimizer='reduce,garbageCollector,';
select 'optimizer test:',optimizer;
-select count(*) from tables;
set optimizer='garbageCollector,';
select 'optimizer test:',optimizer;
-select count(*) from tables;
-set
optimizer='costModel,coercions,emptySet,modes,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,';
+set
optimizer='costModel,coercions,emptySet,accessmode,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,';
select 'optimizer test:',optimizer;
-select count(*) from tables;
-set
optimizer='costModel,coercions,emptySet,modes,commonTerms,accumulators,joinPath,deadcode,garbageCollector,';
+set
optimizer='costModel,coercions,emptySet,accessmode,commonTerms,accumulators,joinPath,deadcode,garbageCollector,';
select 'optimizer test:',optimizer;
-select count(*) from tables;
select 'done';
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
