Update of /cvsroot/monetdb/sql/src/backends/monet5/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv31827
Modified Files:
Tag: SQL_2-18
optimizers.sql
Added Files:
Tag: SQL_2-18
All optimizers.stable.err optimizers.stable.out
Log Message:
Test the behavior of the SQL optimizer variable
--- NEW FILE: optimizers.stable.out ---
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 >
--- 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
Index: optimizers.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/backends/monet5/Tests/optimizers.sql,v
retrieving revision 1.1
retrieving revision 1.1.4.1
diff -u -d -r1.1 -r1.1.4.1
--- optimizers.sql 9 Dec 2006 17:32:00 -0000 1.1
+++ optimizers.sql 29 Jun 2007 06:21:14 -0000 1.1.4.1
@@ -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
