Update of /cvsroot/monetdb/sql/src/test/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv23009/src/test/Tests
Modified Files:
identifiers.stable.out marcin3.stable.out
outerref_in_selection.stable.out rank.stable.out
Added Files:
setoptimizer.sql.src setoptimizer.stable.err
setoptimizer.stable.out setoptimizer.stable.out.Five
Log Message:
Many fixes
changed how we handle selections over multiple columns of a single table
(should solve the preformance problem reported by Venks)
added a way to bulk request sequence numbers. When loading (copying) data
into tables which have a auto_increment (or alike) column lots of time
was spend in the many calls to get all the sequence numbers (observed a
performance in crease of about 10x when loading pieces of 100K rows)
added support for TINYINT (we map this too 'bte')
improved mapping functions onto the same signature too improve cached
function reuse
Index: marcin3.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/marcin3.stable.out,v
retrieving revision 1.21
retrieving revision 1.22
diff -u -d -r1.21 -r1.22
--- marcin3.stable.out 24 Oct 2006 16:02:57 -0000 1.21
+++ marcin3.stable.out 29 Jun 2007 11:29:29 -0000 1.22
@@ -27,7 +27,7 @@
[ 1 ]
% sys.nutki, sys.nutki # table_name
% id, valsum # name
-% int, int # type
+% int, bigint # type
% 1, 1 # length
[ 1, 3 ]
[ 3, 7 ]
--- NEW FILE: setoptimizer.stable.out ---
stdout of test 'setoptimizer` in directory 'src/test` itself:
# 00:41:14 >
# 00:41:14 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/MonetDB.conf" --debug=10
--set
"monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/dbfarm"
--set
"sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_open=true --set mapi_port=33505 --set xrpc_port=46168 --set
monet_prompt= --trace "--dbname=mTests_src_test" --dbinit="
module(sql_server);" ; echo ; echo Over..
# 00:41:14 >
# Monet Database Server V4.17.1
# 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..
# 00:41:14 >
# 00:41:14 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=koala --port=33505
# 00:41:14 >
% . # table_name
% single_value # name
% varchar # type
% 3 # length
[ "yes" ]
% . # table_name
% single_value # name
% varchar # type
% 3 # length
[ "off" ]
% . # table_name
% single_value # name
% varchar # type
% 2 # length
[ "on" ]
% . # table_name
% single_value # name
% varchar # type
% 7 # length
[ "default" ]
# 00:41:15 >
# 00:41:15 > Done.
# 00:41:15 >
--- NEW FILE: setoptimizer.stable.out.Five ---
stdout of test 'setoptimizer` in directory 'src/test` itself:
# 09:44:48 >
# 09:44:48 > Mtimeout -timeout 180 mserver5
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set
"monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/dbfarm"
--set
"sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/xquery_logs"
--set mapi_open=true --set mapi_port=30443 --set xrpc_port=49646 --set
monet_prompt= --trace "--dbname=mTests_src_test" --dbinit=' include sql;' ;
echo ; echo Over..
# 09:44:48 >
# MonetDB Server v5.1.0
# Copyright (c) 1993-2007 CWI, all rights reserved
# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically linked
# dbname:mTests_src_test
# Visit http://monetdb.cwi.nl/ for further information
Ready.
Over..
# 00:41:14 >
# 00:41:14 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=koala --port=33505
# 00:41:14 >
% . # table_name
% single_value # name
% varchar # type
% 146 # length
[
"inline,remap,evaluate,costModel,coercions,emptySet,accessmode,aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,multiplex"
]
% . # table_name
% single_value # name
% varchar # type
% 9 # length
[ "multiplex" ]
% . # table_name
% single_value # name
% varchar # type
% 146 # length
[
"inline,remap,evaluate,costModel,coercions,emptySet,accessmode,aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,multiplex"
]
% . # table_name
% single_value # name
% varchar # type
% 146 # length
[
"inline,remap,evaluate,costModel,coercions,emptySet,accessmode,aliases,commonTerms,accumulators,joinPath,deadcode,reduce,garbageCollector,multiplex"
]
# 00:41:15 >
# 00:41:15 > Done.
# 00:41:15 >
Index: outerref_in_selection.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/outerref_in_selection.stable.out,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- outerref_in_selection.stable.out 24 Oct 2006 16:02:57 -0000 1.2
+++ outerref_in_selection.stable.out 29 Jun 2007 11:29:29 -0000 1.3
@@ -23,7 +23,7 @@
% sys.b, sys.a # table_name
% cape_date, numppl # name
-% date, int # type
+% date, bigint # type
% 10, 1 # length
# 11:50:11 >
--- NEW FILE: setoptimizer.stable.err ---
stderr of test 'setoptimizer` in directory 'src/test` itself:
# 00:41:14 >
# 00:41:14 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/MonetDB.conf" --debug=10
--set
"monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/dbfarm"
--set
"sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_open=true --set mapi_port=33505 --set xrpc_port=46168 --set
monet_prompt= --trace "--dbname=mTests_src_test" --dbinit="
module(sql_server);" ; echo ; echo Over..
# 00:41:14 >
# 00:41:14 >
# 00:41:14 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=koala --port=33505
# 00:41:14 >
# 00:41:15 >
# 00:41:15 > Done.
# 00:41:15 >
Index: identifiers.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/identifiers.stable.out,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -d -r1.6 -r1.7
--- identifiers.stable.out 24 Oct 2006 16:02:57 -0000 1.6
+++ identifiers.stable.out 29 Jun 2007 11:29:29 -0000 1.7
@@ -23,32 +23,32 @@
% . # table_name
% bla # name
-% smallint # type
+% tinyint # type
% 1 # length
[ 1 ]
% . # table_name
% bla # name
-% smallint # type
+% tinyint # type
% 1 # length
[ 1 ]
% . # table_name
% bla # name
-% smallint # type
+% tinyint # type
% 1 # length
[ 1 ]
% . # table_name
% Bla # name
-% smallint # type
+% tinyint # type
% 1 # length
[ 1 ]
% . # table_name
% BLA # name
-% smallint # type
+% tinyint # type
% 1 # length
[ 1 ]
% . # table_name
% B"la" # name
-% smallint # type
+% tinyint # type
% 1 # length
[ 1 ]
--- NEW FILE: setoptimizer.sql.src ---
$RELSRCDIR/../setoptimizer.sql
Index: rank.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/rank.stable.out,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -d -r1.5 -r1.6
--- rank.stable.out 23 May 2007 22:06:02 -0000 1.5
+++ rank.stable.out 29 Jun 2007 11:29:29 -0000 1.6
@@ -60,111 +60,111 @@
% sys.tables, sys.tables # table_name
% foo, schema_id # name
% int, int # type
-% 2, 3 # length
-[ 0, 846 ]
-[ 1, 846 ]
-[ 2, 846 ]
-[ 3, 846 ]
-[ 4, 846 ]
-[ 5, 846 ]
-[ 6, 846 ]
-[ 7, 846 ]
-[ 8, 846 ]
-[ 9, 846 ]
-[ 10, 846 ]
-[ 11, 846 ]
-[ 12, 846 ]
-[ 0, 947 ]
-[ 1, 947 ]
-[ 2, 947 ]
-[ 3, 947 ]
-[ 4, 947 ]
-[ 5, 947 ]
-[ 13, 846 ]
-[ 14, 846 ]
-[ 15, 846 ]
-[ 16, 846 ]
-[ 17, 846 ]
-[ 18, 846 ]
-[ 19, 846 ]
-[ 6, 947 ]
-[ 20, 846 ]
-[ 21, 846 ]
-[ 22, 846 ]
-[ 23, 846 ]
-[ 24, 846 ]
+% 2, 4 # length
+[ 0, 982 ]
+[ 1, 982 ]
+[ 2, 982 ]
+[ 3, 982 ]
+[ 4, 982 ]
+[ 5, 982 ]
+[ 6, 982 ]
+[ 7, 982 ]
+[ 8, 982 ]
+[ 9, 982 ]
+[ 10, 982 ]
+[ 11, 982 ]
+[ 12, 982 ]
+[ 0, 1083 ]
+[ 1, 1083 ]
+[ 2, 1083 ]
+[ 3, 1083 ]
+[ 4, 1083 ]
+[ 5, 1083 ]
+[ 13, 982 ]
+[ 14, 982 ]
+[ 15, 982 ]
+[ 16, 982 ]
+[ 17, 982 ]
+[ 18, 982 ]
+[ 19, 982 ]
+[ 6, 1083 ]
+[ 20, 982 ]
+[ 21, 982 ]
+[ 22, 982 ]
+[ 23, 982 ]
+[ 24, 982 ]
% sys.tables, sys.tables # table_name
% foo, schema_id # name
% int, int # type
-% 2, 3 # length
-[ 0, 846 ]
-[ 1, 846 ]
-[ 2, 846 ]
-[ 3, 846 ]
-[ 4, 846 ]
-[ 5, 846 ]
-[ 6, 846 ]
-[ 7, 846 ]
-[ 8, 846 ]
-[ 9, 846 ]
-[ 10, 846 ]
-[ 11, 846 ]
-[ 12, 846 ]
-[ 0, 947 ]
-[ 1, 947 ]
-[ 2, 947 ]
-[ 3, 947 ]
-[ 4, 947 ]
-[ 5, 947 ]
-[ 13, 846 ]
-[ 14, 846 ]
-[ 15, 846 ]
-[ 16, 846 ]
-[ 17, 846 ]
-[ 18, 846 ]
-[ 19, 846 ]
-[ 6, 947 ]
-[ 20, 846 ]
-[ 21, 846 ]
-[ 22, 846 ]
-[ 23, 846 ]
-[ 24, 846 ]
+% 2, 4 # length
+[ 0, 982 ]
+[ 1, 982 ]
+[ 2, 982 ]
+[ 3, 982 ]
+[ 4, 982 ]
+[ 5, 982 ]
+[ 6, 982 ]
+[ 7, 982 ]
+[ 8, 982 ]
+[ 9, 982 ]
+[ 10, 982 ]
+[ 11, 982 ]
+[ 12, 982 ]
+[ 0, 1083 ]
+[ 1, 1083 ]
+[ 2, 1083 ]
+[ 3, 1083 ]
+[ 4, 1083 ]
+[ 5, 1083 ]
+[ 13, 982 ]
+[ 14, 982 ]
+[ 15, 982 ]
+[ 16, 982 ]
+[ 17, 982 ]
+[ 18, 982 ]
+[ 19, 982 ]
+[ 6, 1083 ]
+[ 20, 982 ]
+[ 21, 982 ]
+[ 22, 982 ]
+[ 23, 982 ]
+[ 24, 982 ]
% ., sys.tables # table_name
% foo, schema_id # name
% int, int # type
-% 2, 3 # length
-[ 0, 846 ]
-[ 1, 846 ]
-[ 2, 846 ]
-[ 3, 846 ]
-[ 4, 846 ]
-[ 5, 846 ]
-[ 6, 846 ]
-[ 7, 846 ]
-[ 8, 846 ]
-[ 9, 846 ]
-[ 10, 846 ]
-[ 11, 846 ]
-[ 12, 846 ]
-[ 13, 846 ]
-[ 14, 846 ]
-[ 15, 846 ]
-[ 16, 846 ]
-[ 17, 846 ]
-[ 18, 846 ]
-[ 19, 846 ]
-[ 20, 846 ]
-[ 21, 846 ]
-[ 22, 846 ]
-[ 23, 846 ]
-[ 24, 846 ]
-[ 25, 947 ]
-[ 26, 947 ]
-[ 27, 947 ]
-[ 28, 947 ]
-[ 29, 947 ]
-[ 30, 947 ]
-[ 31, 947 ]
+% 2, 4 # length
+[ 0, 982 ]
+[ 1, 982 ]
+[ 2, 982 ]
+[ 3, 982 ]
+[ 4, 982 ]
+[ 5, 982 ]
+[ 6, 982 ]
+[ 7, 982 ]
+[ 8, 982 ]
+[ 9, 982 ]
+[ 10, 982 ]
+[ 11, 982 ]
+[ 12, 982 ]
+[ 13, 982 ]
+[ 14, 982 ]
+[ 15, 982 ]
+[ 16, 982 ]
+[ 17, 982 ]
+[ 18, 982 ]
+[ 19, 982 ]
+[ 20, 982 ]
+[ 21, 982 ]
+[ 22, 982 ]
+[ 23, 982 ]
+[ 24, 982 ]
+[ 25, 1083 ]
+[ 26, 1083 ]
+[ 27, 1083 ]
+[ 28, 1083 ]
+[ 29, 1083 ]
+[ 30, 1083 ]
+[ 31, 1083 ]
% sys. # table_name
% foo # name
% int # type
@@ -204,111 +204,111 @@
% sys.tables, sys.tables # table_name
% foo, schema_id # name
% int, int # type
-% 2, 3 # length
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 13, 947 ]
-[ 13, 947 ]
-[ 13, 947 ]
-[ 13, 947 ]
-[ 13, 947 ]
-[ 13, 947 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 13, 947 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
+% 2, 4 # length
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 13, 1083 ]
+[ 13, 1083 ]
+[ 13, 1083 ]
+[ 13, 1083 ]
+[ 13, 1083 ]
+[ 13, 1083 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 13, 1083 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
% sys.tables, sys.tables # table_name
% foo, schema_id # name
% int, int # type
-% 2, 3 # length
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 13, 947 ]
-[ 13, 947 ]
-[ 13, 947 ]
-[ 13, 947 ]
-[ 13, 947 ]
-[ 13, 947 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 13, 947 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
+% 2, 4 # length
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 13, 1083 ]
+[ 13, 1083 ]
+[ 13, 1083 ]
+[ 13, 1083 ]
+[ 13, 1083 ]
+[ 13, 1083 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 13, 1083 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
% ., sys.tables # table_name
% foo, schema_id # name
% int, int # type
-% 2, 3 # length
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 0, 846 ]
-[ 16, 947 ]
-[ 16, 947 ]
-[ 16, 947 ]
-[ 16, 947 ]
-[ 16, 947 ]
-[ 16, 947 ]
-[ 16, 947 ]
+% 2, 4 # length
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 0, 982 ]
+[ 16, 1083 ]
+[ 16, 1083 ]
+[ 16, 1083 ]
+[ 16, 1083 ]
+[ 16, 1083 ]
+[ 16, 1083 ]
+[ 16, 1083 ]
# 22:17:03 >
# 22:17:03 > 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
