Update of /cvsroot/monetdb/sql/src/test/bugs/Tests
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv1170/src/test/bugs/Tests
Modified Files:
case_cast-bug-sf-1019506.stable.out
create_insert_select_aggr-bug-00001.stable.out
dbl_sht_cast_bug.stable.out
foreignkey_leftjoin-bug-sf-854312.stable.out
groupby_having-bug-sf-947600.stable.out
innerjoin_multiple-bug-sf-943661.stable.out
leftjoinbug.stable.out not_in_null_bug.stable.out
order_disjunctive_bug.SF-1338309.stable.out
predicate_or-sf-1409824.stable.out select_not_equal.stable.out
select_orderby_alias-bug-sf-1024615.stable.out
simple_view.stable.out
subselect_ambigious_columns-bug-sf-949071.stable.out
subselect_multiple_unionall_where_1=1-bug-sf-1005596.stable.out
union-bug-sf-978045.stable.out
union_all-bug-sf-941788.stable.out zero_or_one_bug.stable.out
Log Message:
be more safe with unions and outer joins (ie copy also the first part
of the unions and joins, before any append)
U zero_or_one_bug.stable.out
Index: zero_or_one_bug.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/bugs/Tests/zero_or_one_bug.stable.out,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- zero_or_one_bug.stable.out 21 Dec 2008 19:38:23 -0000 1.4
+++ zero_or_one_bug.stable.out 30 Dec 2008 19:19:06 -0000 1.5
@@ -33,7 +33,7 @@
[ 1 ]
[ 1 ]
[ 1 ]
-% sys., sys.L5 # table_name
+% ., .L5 # table_name
% ifthenelse_not_isnull_id1, L5 # name
% int, varchar # type
% 1, 1 # length
@@ -46,7 +46,7 @@
[ 7, NULL ]
[ 8, NULL ]
[ 9, NULL ]
-% sys., sys.L7 # table_name
+% ., .L7 # table_name
% ifthenelse_not_isnull_id1, my_col1 # name
% int, varchar # type
% 1, 1 # length
U not_in_null_bug.stable.out
Index: not_in_null_bug.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/bugs/Tests/not_in_null_bug.stable.out,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- not_in_null_bug.stable.out 30 Nov 2007 12:54:37 -0000 1.2
+++ not_in_null_bug.stable.out 30 Dec 2008 19:19:06 -0000 1.3
@@ -1,21 +1,23 @@
stdout of test 'not_in_null_bug` in directory 'src/test/bugs` itself:
-# 22:28:07 >
-# 22:28:07 > 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 xrpc_open=true --set mapi_port=39820 --set
xrpc_port=49849 --set monet_prompt= --trace "--dbname=mTests_src_test_bugs"
"--dbinit= module(sql_server);" ; echo ; echo Over..
-# 22:28:07 >
-
-# MonetDB Server v4.20.1
-# based on GDK v1.20.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.
-# MonetDB/SQL module v2.20.3 loaded
+# 19:40:44 >
+# 19:40:44 > mserver5
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set gdk_nr_threads=4 --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 mapi_open=true --set xrpc_open=true --set mapi_port=31946 --set
xrpc_port=44499 --set monet_prompt= --trace "--dbname=mTests_src_test_bugs"
--set mal_listing=0 "--dbinit= include sql;" ; echo ; echo Over..
+# 19:40:44 >
-printf("\nReady.\n");
+# MonetDB server v5.9.0, based on kernel v1.27.0
+# Serving database 'mTests_src_test_bugs', using 4 threads
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically
linked
+# Copyright (c) 1993-July 2008 CWI.
+# Copyright (c) August 2008- MonetDB B.V., all rights reserved
+# Visit http://monetdb.cwi.nl/ for further information
+# Listening for connection requests on mapi:monetdb://alf.ins.cwi.nl:31946/
+# MonetDB/SQL module v2.27.0 loaded
Ready.
-quit();
+#function user.main():void;
+# clients.quit();
+#end main;
Over..
@@ -32,7 +34,7 @@
% 4 # length
[ "matt" ]
[ "fred" ]
-% sys.query_users # table_name
+% .query_users # table_name
% user_name # name
% varchar # type
% 0 # length
U case_cast-bug-sf-1019506.stable.out
Index: case_cast-bug-sf-1019506.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/bugs/Tests/case_cast-bug-sf-1019506.stable.out,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- case_cast-bug-sf-1019506.stable.out 6 Nov 2007 15:45:26 -0000 1.4
+++ case_cast-bug-sf-1019506.stable.out 30 Dec 2008 19:19:06 -0000 1.5
@@ -1,19 +1,23 @@
stdout of test 'case_cast-bug-sf-1019506` in directory 'src/test/bugs` itself:
-# 12:52:59 >
-# 12:52:59 > Mtimeout -timeout 180 Mserver
"--config=/ufs/fabian/scratch/monetdb/current/program-x86_64/etc/MonetDB.conf"
--debug=10 --set
"monet_mod_path=/ufs/fabian/scratch/monetdb/current/program-x86_64/lib/MonetDB:/ufs/fabian/scratch/monetdb/current/program-x86_64/lib/bin"
--set
"gdk_dbfarm=/ufs/fabian/scratch/monetdb/current/program-x86_64/var/MonetDB/dbfarm"
--set
"sql_logdir=/ufs/fabian/scratch/monetdb/current/program-x86_64/var/MonetDB/log"
--set mapi_port=38933 --set sql_port=45579 --set xquery_port=52530 --set
monet_prompt= --trace "--dbname=mTests_src_test_bugs"
--dbinit="module(sql_server); sql_server_start();" ; echo ; echo Over..
-# 12:52:59 >
-
-# Monet Database Server V4.9.3
-# Copyright (c) 1993-2005, 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.
+# 19:40:38 >
+# 19:40:38 > mserver5
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set gdk_nr_threads=4 --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 mapi_open=true --set xrpc_open=true --set mapi_port=31946 --set
xrpc_port=44499 --set monet_prompt= --trace "--dbname=mTests_src_test_bugs"
--set mal_listing=0 "--dbinit= include sql;" ; echo ; echo Over..
+# 19:40:38 >
-printf("\nReady.\n");
+# MonetDB server v5.9.0, based on kernel v1.27.0
+# Serving database 'mTests_src_test_bugs', using 4 threads
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically
linked
+# Copyright (c) 1993-July 2008 CWI.
+# Copyright (c) August 2008- MonetDB B.V., all rights reserved
+# Visit http://monetdb.cwi.nl/ for further information
+# Listening for connection requests on mapi:monetdb://alf.ins.cwi.nl:31946/
+# MonetDB/SQL module v2.27.0 loaded
Ready.
-quit();
+#function user.main():void;
+# clients.quit();
+#end main;
Over..
@@ -21,7 +25,7 @@
# 11:55:41 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=35185 < case_cast-bug-sf-1019506.sql
# 11:55:41 >
-% ., sys., sys., sys., ., sys., sys., sys., sys., .,
., ., . # table_name
+% ., ., ., ., ., ., ., ., ., .,
., ., . # table_name
% table_cat, table_schem, table_name, non_unique,
index_qualifier, index_name, type, ordinal_position,
column_name, asc_or_desc, cardinality, pages, filter_condition # name
% clob, clob, clob, smallint, clob, clob, smallint,
smallint, clob, char, int, int, clob # type
% 0, 0, 0, 1, 0, 0, 1, 1, 0, 1,
1, 1, 0 # length
U simple_view.stable.out
Index: simple_view.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/bugs/Tests/simple_view.stable.out,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -d -r1.7 -r1.8
--- simple_view.stable.out 7 Dec 2008 19:32:14 -0000 1.7
+++ simple_view.stable.out 30 Dec 2008 19:19:06 -0000 1.8
@@ -25,7 +25,7 @@
# 20:29:05 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=33640
# 20:29:05 >
-% sys.tt, .tv, .tv # table_name
+% .tt, .tv, .tv # table_name
% name, s, i # name
% varchar, char, tinyint # type
% 12, 3, 1 # length
U union_all-bug-sf-941788.stable.out
Index: union_all-bug-sf-941788.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/bugs/Tests/union_all-bug-sf-941788.stable.out,v
retrieving revision 1.11
retrieving revision 1.12
diff -u -d -r1.11 -r1.12
--- union_all-bug-sf-941788.stable.out 24 Oct 2006 16:03:16 -0000 1.11
+++ union_all-bug-sf-941788.stable.out 30 Dec 2008 19:19:06 -0000 1.12
@@ -1,14 +1,23 @@
stdout of test 'union_all-bug-sf-941788` in directory 'src/test/bugs` itself:
-# 21:19:25 >
-# 21:19:25 > Mtimeout -timeout 180 mserver5
"--config=/ufs/fabian/scratch/monetdb/five/program-x86_64/etc/MonetDB5.conf"
--debug=10 --set
"monet_mod_path=/ufs/fabian/scratch/monetdb/five/program-x86_64/lib/MonetDB5"
--set
"gdk_dbfarm=/net/pegasus.ins.cwi.nl/export/scratch0/fabian/vtmp/mtest-five-monetdb-pegasus.ins.cwi.nl/sql/dbfarm"
--set
"sql_logdir=/net/pegasus.ins.cwi.nl/export/scratch0/fabian/vtmp/mtest-five-monetdb-pegasus.ins.cwi.nl/sql/log"
--set mapi_port=32424 --set monet_prompt= --trace
"--dbname=mTests_src_test_bugs" --dbinit="include sql;" ; echo ; echo Over..
-# 21:19:25 >
+# 19:40:32 >
+# 19:40:32 > mserver5
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set gdk_nr_threads=4 --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 mapi_open=true --set xrpc_open=true --set mapi_port=31946 --set
xrpc_port=44499 --set monet_prompt= --trace "--dbname=mTests_src_test_bugs"
--set mal_listing=0 "--dbinit= include sql;" ; echo ; echo Over..
+# 19:40:32 >
-printf("\nReady.\n");
+# MonetDB server v5.9.0, based on kernel v1.27.0
+# Serving database 'mTests_src_test_bugs', using 4 threads
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically
linked
+# Copyright (c) 1993-July 2008 CWI.
+# Copyright (c) August 2008- MonetDB B.V., all rights reserved
+# Visit http://monetdb.cwi.nl/ for further information
+# Listening for connection requests on mapi:monetdb://alf.ins.cwi.nl:31946/
+# MonetDB/SQL module v2.27.0 loaded
Ready.
-quit();
+#function user.main():void;
+# clients.quit();
+#end main;
Over..
@@ -16,7 +25,7 @@
# 11:55:29 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=35185 < union_all-bug-sf-941788.sql
# 11:55:29 >
-% .ttables, sys.ttables, sys.ttables, .ttables, .ttables,
.ttables, .ttables, .ttables, .ttables, .ttables #
table_name
+% .ttables, .ttables, .ttables, .ttables, .ttables,
.ttables, .ttables, .ttables, .ttables, .ttables #
table_name
% TABLE_CAT, TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS,
TYPE_CAT, TYPE_SCHEM, TYPE_NAME, SELF_REFERENCING_COL_NAME,
REF_GENERATION # name
% char, varchar, varchar, char, char, char, char,
char, char, char # type
% 0, 3, 10, 12, 0, 0, 0, 0, 2, 6 #
length
@@ -29,7 +38,7 @@
[ NULL, "tmp", "idxs", "SYSTEM TABLE", "", NULL, NULL, NULL,
"id", "SYSTEM" ]
[ NULL, "tmp", "keycolumns", "SYSTEM TABLE", "", NULL, NULL,
NULL, "id", "SYSTEM" ]
[ NULL, "tmp", "keys", "SYSTEM TABLE", "", NULL, NULL, NULL,
"id", "SYSTEM" ]
-% .ttables, sys.ttables, sys.ttables, .ttables, .ttables,
.ttables, .ttables, .ttables, .ttables, .ttables #
table_name
+% .ttables, .ttables, .ttables, .ttables, .ttables,
.ttables, .ttables, .ttables, .ttables, .ttables #
table_name
% TABLE_CAT, TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS,
TYPE_CAT, TYPE_SCHEM, TYPE_NAME, SELF_REFERENCING_COL_NAME,
REF_GENERATION # name
% char, varchar, varchar, char, char, char, char,
char, char, char # type
% 0, 3, 10, 23, 0, 0, 0, 0, 2, 6 #
length
U predicate_or-sf-1409824.stable.out
Index: predicate_or-sf-1409824.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/bugs/Tests/predicate_or-sf-1409824.stable.out,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- predicate_or-sf-1409824.stable.out 24 Oct 2006 16:03:06 -0000 1.3
+++ predicate_or-sf-1409824.stable.out 30 Dec 2008 19:19:06 -0000 1.4
@@ -1,19 +1,23 @@
stdout of test 'predicate_or-sf-1409824` in directory 'src/test/bugs` itself:
-# 22:21:34 >
-# 22:21:34 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/rc/Linux-i686/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-i686/lib/MonetDB:/ufs/niels/scratch/rc/Linux-i686/lib/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-i686/var/MonetDB/dbfarm" --set
"sql_logdir=/ufs/niels/scratch/rc/Linux-i686/var/MonetDB/log" --set
mapi_port=34690 --set sql_port=45174 --set xquery_port=58844 --set
monet_prompt= --trace "--dbname=mTests_src_test_bugs"
--dbinit="module(sql_server); sql_server_start();" ; echo ; echo Over..
-# 22:21:34 >
-
-# Monet Database Server V4.10.0
-# Copyright (c) 1993-2006, CWI. All rights reserved.
-# Compiled for i686-redhat-linux-gnu/32bit with 32bit OIDs; dynamically linked.
-# Visit http://monetdb.cwi.nl/ for further information.
+# 19:40:42 >
+# 19:40:42 > mserver5
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set gdk_nr_threads=4 --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 mapi_open=true --set xrpc_open=true --set mapi_port=31946 --set
xrpc_port=44499 --set monet_prompt= --trace "--dbname=mTests_src_test_bugs"
--set mal_listing=0 "--dbinit= include sql;" ; echo ; echo Over..
+# 19:40:42 >
-printf("\nReady.\n");
+# MonetDB server v5.9.0, based on kernel v1.27.0
+# Serving database 'mTests_src_test_bugs', using 4 threads
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically
linked
+# Copyright (c) 1993-July 2008 CWI.
+# Copyright (c) August 2008- MonetDB B.V., all rights reserved
+# Visit http://monetdb.cwi.nl/ for further information
+# Listening for connection requests on mapi:monetdb://alf.ins.cwi.nl:31946/
+# MonetDB/SQL module v2.27.0 loaded
Ready.
-quit();
+#function user.main():void;
+# clients.quit();
+#end main;
Over..
@@ -24,12 +28,12 @@
[ 1 ]
[ 1 ]
[ 1 ]
-% sys.p1409824, sys.p1409824, sys.p1409824 # table_name
+% .p1409824, .p1409824, .p1409824 # table_name
% id, name, val # name
% int, clob, int # type
% 1, 5, 1 # length
[ 1, "name4", 4 ]
-% sys.p1409824, sys.p1409824, sys.p1409824 # table_name
+% .p1409824, .p1409824, .p1409824 # table_name
% id, name, val # name
% int, clob, int # type
% 1, 5, 1 # length
U dbl_sht_cast_bug.stable.out
Index: dbl_sht_cast_bug.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/bugs/Tests/dbl_sht_cast_bug.stable.out,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -d -r1.7 -r1.8
--- dbl_sht_cast_bug.stable.out 29 Dec 2008 21:30:08 -0000 1.7
+++ dbl_sht_cast_bug.stable.out 30 Dec 2008 19:19:06 -0000 1.8
@@ -25,7 +25,7 @@
# 19:47:27 >
[ 1 ]
-% sys.dbl_sht_cast_bug # table_name
+% .dbl_sht_cast_bug # table_name
% L4 # name
% wrd # type
% 1 # length
U subselect_ambigious_columns-bug-sf-949071.stable.out
Index: subselect_ambigious_columns-bug-sf-949071.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/bugs/Tests/subselect_ambigious_columns-bug-sf-949071.stable.out,v
retrieving revision 1.12
retrieving revision 1.13
diff -u -d -r1.12 -r1.13
--- subselect_ambigious_columns-bug-sf-949071.stable.out 24 Oct 2006
16:03:08 -0000 1.12
+++ subselect_ambigious_columns-bug-sf-949071.stable.out 30 Dec 2008
19:19:06 -0000 1.13
@@ -1,19 +1,23 @@
stdout of test 'subselect_ambigious_columns-bug-sf-949071` in directory
'src/test/bugs` itself:
-# 18:18:03 >
-# 18:18:03 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/Linux-x86_64/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/niels/scratch/Linux-x86_64/lib/MonetDB:/ufs/niels/scratch/Linux-x86_64/lib/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/Linux-x86_64/var/MonetDB/dbfarm" --set
"sql_logdir=/ufs/niels/scratch/Linux-x86_64/var/MonetDB/log" --set
mapi_port=32098 --set monet_prompt= --trace "--dbname=mTests_src_test_bugs"
--dbinit="module(sql_server); sql_server_start();" ; echo ; echo Over..
-# 18:18:03 >
-
-# Monet Database Server V4.13.1
-# Copyright (c) 1993-2006, 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.
+# 19:40:33 >
+# 19:40:33 > mserver5
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set gdk_nr_threads=4 --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 mapi_open=true --set xrpc_open=true --set mapi_port=31946 --set
xrpc_port=44499 --set monet_prompt= --trace "--dbname=mTests_src_test_bugs"
--set mal_listing=0 "--dbinit= include sql;" ; echo ; echo Over..
+# 19:40:33 >
-printf("\nReady.\n");
+# MonetDB server v5.9.0, based on kernel v1.27.0
+# Serving database 'mTests_src_test_bugs', using 4 threads
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically
linked
+# Copyright (c) 1993-July 2008 CWI.
+# Copyright (c) August 2008- MonetDB B.V., all rights reserved
+# Visit http://monetdb.cwi.nl/ for further information
+# Listening for connection requests on mapi:monetdb://alf.ins.cwi.nl:31946/
+# MonetDB/SQL module v2.27.0 loaded
Ready.
-quit();
+#function user.main():void;
+# clients.quit();
+#end main;
Over..
@@ -21,7 +25,7 @@
# 11:55:31 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=35185 < subselect_ambigious_columns-bug-sf-949071.sql
# 11:55:31 >
-% sys.tables # table_name
+% .tables # table_name
% name # name
% varchar # type
% 10 # length
@@ -34,7 +38,7 @@
[ "keys" ]
[ "idxs" ]
[ "keycolumns" ]
-% sys.tables # table_name
+% .tables # table_name
% name # name
% varchar # type
% 10 # length
U select_orderby_alias-bug-sf-1024615.stable.out
Index: select_orderby_alias-bug-sf-1024615.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/bugs/Tests/select_orderby_alias-bug-sf-1024615.stable.out,v
retrieving revision 1.8
retrieving revision 1.9
diff -u -d -r1.8 -r1.9
--- select_orderby_alias-bug-sf-1024615.stable.out 7 Dec 2008 19:27:22
-0000 1.8
+++ select_orderby_alias-bug-sf-1024615.stable.out 30 Dec 2008 19:19:06
-0000 1.9
@@ -25,15 +25,15 @@
# 12:31:04 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=30086
# 12:31:04 >
-% sys.keys, sys.keys, sys.keys, sys.keys, sys.keys,
sys.keys, sys.keycolumns, sys.keycolumns, sys.keycolumns, sys.keycolumns,
sys.tables, sys.tables, sys.tables, sys.tables, sys.tables,
sys.tables, sys.tables, .tables, sys.schemas, sys.schemas,
sys.schemas, sys.schemas # table_name
+% sys.keys, sys.keys, sys.keys, sys.keys, sys.keys,
sys.keys, sys.keycolumns, sys.keycolumns, sys.keycolumns, sys.keycolumns,
.tables, .tables, .tables, .tables, .tables,
.tables, .tables, .tables, sys.schemas, sys.schemas,
sys.schemas, sys.schemas # table_name
% id, table_id, type, name, rkey, action, id, column, trunc,
nr, id, name, schema_id, query, type, system, commit_action,
temporary, id, name, authorization, owner # name
% int, int, int, varchar, int, int, int, varchar,
int, int, int, varchar, int, varchar, smallint,
boolean, smallint, tinyint, int, varchar, int,
int # type
% 1, 1, 1, 0, 1, 1, 1, 0, 1, 1,
1, 0, 1, 0, 1, 5, 1, 1, 1, 0,
1, 1 # length
-% sys.keys, sys.keys, sys.keys, sys.keys, sys.keys,
sys.keys, sys.keycolumns, sys.keycolumns, sys.keycolumns, sys.keycolumns,
sys.tables, sys.tables, sys.tables, sys.tables, sys.tables,
sys.tables, sys.tables, .tables, sys.schemas, sys.schemas,
sys.schemas, sys.schemas # table_name
+% sys.keys, sys.keys, sys.keys, sys.keys, sys.keys,
sys.keys, sys.keycolumns, sys.keycolumns, sys.keycolumns, sys.keycolumns,
.tables, .tables, .tables, .tables, .tables,
.tables, .tables, .tables, sys.schemas, sys.schemas,
sys.schemas, sys.schemas # table_name
% id, table_id, type, name, rkey, action, id, column, trunc,
nr, id, name, schema_id, query, type, system, commit_action,
temporary, id, name, authorization, owner # name
% int, int, int, varchar, int, int, int, varchar,
int, int, int, varchar, int, varchar, smallint,
boolean, smallint, tinyint, int, varchar, int,
int # type
% 1, 1, 1, 0, 1, 1, 1, 0, 1, 1,
1, 0, 1, 0, 1, 5, 1, 1, 1, 0,
1, 1 # length
-% ., sys.schemas, sys.tables, sys.keycolumns, sys.keys,
sys.keys # table_name
+% ., sys.schemas, .tables, sys.keycolumns, sys.keys,
sys.keys # table_name
% TABLE_CAT, TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, KEY_SEQ,
PK_NAME # name
% varchar, varchar, varchar, varchar, int, varchar
# type
% 0, 0, 0, 0, 1, 0 # length
U create_insert_select_aggr-bug-00001.stable.out
Index: create_insert_select_aggr-bug-00001.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/bugs/Tests/create_insert_select_aggr-bug-00001.stable.out,v
retrieving revision 1.18
retrieving revision 1.19
diff -u -d -r1.18 -r1.19
--- create_insert_select_aggr-bug-00001.stable.out 21 Dec 2008 19:38:23
-0000 1.18
+++ create_insert_select_aggr-bug-00001.stable.out 30 Dec 2008 19:19:06
-0000 1.19
@@ -72,7 +72,7 @@
% smallint # type
% 2 # length
[ 15 ]
-% sys._tables, sys._tables, sys._tables, sys._tables, sys._tables #
table_name
+% ._tables, ._tables, ._tables, ._tables, ._tables #
table_name
% name, query, type, system, commit_action # name
% varchar, varchar, smallint, boolean, smallint # type
% 0, 0, 1, 5, 1 # length
U leftjoinbug.stable.out
Index: leftjoinbug.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/bugs/Tests/leftjoinbug.stable.out,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- leftjoinbug.stable.out 8 Nov 2007 19:35:16 -0000 1.2
+++ leftjoinbug.stable.out 30 Dec 2008 19:19:06 -0000 1.3
@@ -1,21 +1,23 @@
stdout of test 'leftjoinbug` in directory 'src/test/bugs` itself:
-# 15:58:49 >
-# 15:58:49 > 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 xrpc_open=true --set mapi_port=35345 --set
xrpc_port=49148 --set monet_prompt= --trace "--dbname=mTests_src_test_bugs"
"--dbinit= module(sql_server);" ; echo ; echo Over..
-# 15:58:49 >
-
-# MonetDB Server v4.20.0
-# based on GDK v1.20.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.
-# MonetDB/SQL module v2.20.1 loaded
+# 19:40:43 >
+# 19:40:43 > mserver5
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set gdk_nr_threads=4 --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 mapi_open=true --set xrpc_open=true --set mapi_port=31946 --set
xrpc_port=44499 --set monet_prompt= --trace "--dbname=mTests_src_test_bugs"
--set mal_listing=0 "--dbinit= include sql;" ; echo ; echo Over..
+# 19:40:43 >
-printf("\nReady.\n");
+# MonetDB server v5.9.0, based on kernel v1.27.0
+# Serving database 'mTests_src_test_bugs', using 4 threads
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically
linked
+# Copyright (c) 1993-July 2008 CWI.
+# Copyright (c) August 2008- MonetDB B.V., all rights reserved
+# Visit http://monetdb.cwi.nl/ for further information
+# Listening for connection requests on mapi:monetdb://alf.ins.cwi.nl:31946/
+# MonetDB/SQL module v2.27.0 loaded
Ready.
-quit();
+#function user.main():void;
+# clients.quit();
+#end main;
Over..
@@ -70,7 +72,7 @@
[ 1 ]
[ 1 ]
[ 1 ]
-% sys.ljb2, sys.ljb2, sys.ljb2, sys.ljb3, sys.ljb1 #
table_name
+% .ljb2, .ljb2, .ljb2, .ljb3, .ljb1 # table_name
% ljb3, id, name, ljb1_id, name # name
% int, int, varchar, int, varchar # type
% 2, 2, 42, 2, 34 # length
@@ -91,7 +93,7 @@
[ 14, 15, "Alice MacKenzie", NULL, NULL ]
[ 15, 16, "Pinchin Street Murder, possibly Lydia Hart", NULL, NULL
]
[ 16, 17, "Frances Coles", NULL, NULL ]
-% sys.ljb2, sys.ljb2, sys.ljb2, sys.ljb1, sys.ljb1 #
table_name
+% .ljb2, .ljb2, .ljb2, .ljb1, .ljb1 # table_name
% ljb3, id, name, id, name # name
% int, int, varchar, int, varchar # type
% 2, 2, 42, 2, 34 # length
U select_not_equal.stable.out
Index: select_not_equal.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/bugs/Tests/select_not_equal.stable.out,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- select_not_equal.stable.out 15 Feb 2008 18:17:58 -0000 1.2
+++ select_not_equal.stable.out 30 Dec 2008 19:19:06 -0000 1.3
@@ -1,21 +1,23 @@
stdout of test 'select_not_equal` in directory 'src/test/bugs` itself:
-# 14:09:52 >
-# 14:09:52 > 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 xrpc_open=true --set mapi_port=32711 --set
xrpc_port=42408 --set monet_prompt= --trace "--dbname=mTests_src_test_bugs"
"--dbinit= module(sql_server);" ; echo ; echo Over..
-# 14:09:52 >
-
-# MonetDB Server v4.22.0
-# based on GDK v1.22.0
-# Copyright (c) 1993-2008, CWI. All rights reserved.
-# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs; dynamically
linked.
-# Visit http://monetdb.cwi.nl/ for further information.
-# MonetDB/SQL module v2.22.0 loaded
+# 19:40:46 >
+# 19:40:46 > mserver5
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set gdk_nr_threads=4 --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 mapi_open=true --set xrpc_open=true --set mapi_port=31946 --set
xrpc_port=44499 --set monet_prompt= --trace "--dbname=mTests_src_test_bugs"
--set mal_listing=0 "--dbinit= include sql;" ; echo ; echo Over..
+# 19:40:46 >
-printf("\nReady.\n");
+# MonetDB server v5.9.0, based on kernel v1.27.0
+# Serving database 'mTests_src_test_bugs', using 4 threads
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically
linked
+# Copyright (c) 1993-July 2008 CWI.
+# Copyright (c) August 2008- MonetDB B.V., all rights reserved
+# Visit http://monetdb.cwi.nl/ for further information
+# Listening for connection requests on mapi:monetdb://alf.ins.cwi.nl:31946/
+# MonetDB/SQL module v2.27.0 loaded
Ready.
-quit();
+#function user.main():void;
+# clients.quit();
+#end main;
Over..
@@ -34,7 +36,7 @@
% 2 # length
[ 20 ]
[ 30 ]
-% sys.tst123 # table_name
+% .tst123 # table_name
% col1 # name
% int # type
% 2 # length
U innerjoin_multiple-bug-sf-943661.stable.out
Index: innerjoin_multiple-bug-sf-943661.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/bugs/Tests/innerjoin_multiple-bug-sf-943661.stable.out,v
retrieving revision 1.15
retrieving revision 1.16
diff -u -d -r1.15 -r1.16
--- innerjoin_multiple-bug-sf-943661.stable.out 12 Dec 2008 22:28:26 -0000
1.15
+++ innerjoin_multiple-bug-sf-943661.stable.out 30 Dec 2008 19:19:06 -0000
1.16
@@ -25,7 +25,7 @@
# 11:55:31 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=35185 < innerjoin_multiple-bug-sf-943661.sql
# 11:55:31 >
-% sys.schemas, sys.tables, sys.columns # table_name
+% sys.schemas, .tables, .columns # table_name
% name, name, name # name
% varchar, varchar, varchar # type
% 3, 10, 11 # length
@@ -90,7 +90,7 @@
[ "tmp", "keys", "rkey" ]
[ "tmp", "keys", "table_id" ]
[ "tmp", "keys", "type" ]
-% sys.s, sys.t, sys.c # table_name
+% sys.s, .t, .c # table_name
% name, name, name # name
% varchar, varchar, varchar # type
% 3, 10, 11 # length
U groupby_having-bug-sf-947600.stable.out
Index: groupby_having-bug-sf-947600.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/bugs/Tests/groupby_having-bug-sf-947600.stable.out,v
retrieving revision 1.18
retrieving revision 1.19
diff -u -d -r1.18 -r1.19
--- groupby_having-bug-sf-947600.stable.out 7 Dec 2008 19:27:22 -0000
1.18
+++ groupby_having-bug-sf-947600.stable.out 30 Dec 2008 19:19:06 -0000
1.19
@@ -19,7 +19,7 @@
# 11:55:31 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=35185 < groupby_having-bug-sf-947600.sql
# 11:55:31 >
-% sys.a, sys.b, sys.b # table_name
+% .a, .b, .b # table_name
% name, name, L24 # name
% varchar, varchar, wrd # type
% 10, 10, 2 # length
@@ -50,7 +50,7 @@
[ "sequences", "idxs", 4 ]
[ "sequences", "keycolumns", 2 ]
[ "sequences", "keys", 4 ]
-% sys.tables # table_name
+% .tables # table_name
% name # name
% varchar # type
% 10 # length
@@ -60,7 +60,7 @@
[ "keys" ]
[ "idxs" ]
[ "keycolumns" ]
-% sys.tables # table_name
+% .tables # table_name
% name # name
% varchar # type
% 0 # length
U foreignkey_leftjoin-bug-sf-854312.stable.out
Index: foreignkey_leftjoin-bug-sf-854312.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/bugs/Tests/foreignkey_leftjoin-bug-sf-854312.stable.out,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- foreignkey_leftjoin-bug-sf-854312.stable.out 24 Oct 2006 16:03:04
-0000 1.3
+++ foreignkey_leftjoin-bug-sf-854312.stable.out 30 Dec 2008 19:19:06
-0000 1.4
@@ -1,19 +1,23 @@
stdout of test 'foreignkey_leftjoin-bug-sf-854312` in directory
'src/test/bugs` itself:
-# 12:47:56 >
-# 12:47:56 > Mtimeout -timeout 180 Mserver
"--config=/ufs/fabian/scratch/monetdb/current/program-x86_64/etc/MonetDB.conf"
--debug=10 --set
"monet_mod_path=/ufs/fabian/scratch/monetdb/current/program-x86_64/lib/MonetDB:/ufs/fabian/scratch/monetdb/current/program-x86_64/lib/bin"
--set
"gdk_dbfarm=/ufs/fabian/scratch/monetdb/current/program-x86_64/var/MonetDB/dbfarm"
--set
"sql_logdir=/ufs/fabian/scratch/monetdb/current/program-x86_64/var/MonetDB/log"
--set mapi_port=38933 --set sql_port=45579 --set xquery_port=52530 --set
monet_prompt= --trace "--dbname=mTests_src_test_bugs"
--dbinit="module(sql_server); sql_server_start();" ; echo ; echo Over..
-# 12:47:56 >
-
-# Monet Database Server V4.9.3
-# Copyright (c) 1993-2005, 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.
+# 19:40:31 >
+# 19:40:31 > mserver5
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set gdk_nr_threads=4 --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 mapi_open=true --set xrpc_open=true --set mapi_port=31946 --set
xrpc_port=44499 --set monet_prompt= --trace "--dbname=mTests_src_test_bugs"
--set mal_listing=0 "--dbinit= include sql;" ; echo ; echo Over..
+# 19:40:31 >
-printf("\nReady.\n");
+# MonetDB server v5.9.0, based on kernel v1.27.0
+# Serving database 'mTests_src_test_bugs', using 4 threads
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically
linked
+# Copyright (c) 1993-July 2008 CWI.
+# Copyright (c) August 2008- MonetDB B.V., all rights reserved
+# Visit http://monetdb.cwi.nl/ for further information
+# Listening for connection requests on mapi:monetdb://alf.ins.cwi.nl:31946/
+# MonetDB/SQL module v2.27.0 loaded
Ready.
-quit();
+#function user.main():void;
+# clients.quit();
+#end main;
Over..
@@ -21,11 +25,11 @@
# 11:55:26 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=35185 < foreignkey_leftjoin-bug-sf-854312.sql
# 11:55:26 >
-% sys.a, sys.a, sys.a, sys.a, sys.b, sys.b, sys.b, sys.b, sys.b,
sys.b # table_name
+% .a, .a, .a, .a, .b, .b, .b, .b, .b, .b #
table_name
% var1, var2, var3, var4, r_id, id, var1, var2, var3,
var4 # name
% char, varchar, bigint, varchar, int, char, bigint,
bigint, varchar, char # type
% 4, 0, 1, 0, 1, 4, 1, 1, 0, 20 #
length
-% sys.a, sys.a, sys.a, sys.a, sys.b, sys.b, sys.b, sys.b, sys.b,
sys.b # table_name
+% .a, .a, .a, .a, .b, .b, .b, .b, .b, .b #
table_name
% var1, var2, var3, var4, r_id, id, var1, var2, var3,
var4 # name
% char, varchar, bigint, varchar, int, char, bigint,
bigint, varchar, char # type
% 4, 0, 1, 0, 1, 4, 1, 1, 0, 20 #
length
U order_disjunctive_bug.SF-1338309.stable.out
Index: order_disjunctive_bug.SF-1338309.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/bugs/Tests/order_disjunctive_bug.SF-1338309.stable.out,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- order_disjunctive_bug.SF-1338309.stable.out 24 Oct 2006 16:03:06 -0000
1.3
+++ order_disjunctive_bug.SF-1338309.stable.out 30 Dec 2008 19:19:06 -0000
1.4
@@ -1,19 +1,23 @@
stdout of test 'order_disjunctive_bug.SF-1338309` in directory 'src/test/bugs`
itself:
-# 12:59:00 >
-# 12:59:00 > Mtimeout -timeout 180 Mserver
"--config=/ufs/fabian/scratch/monetdb/current/program-x86_64/etc/MonetDB.conf"
--debug=10 --set
"monet_mod_path=/ufs/fabian/scratch/monetdb/current/program-x86_64/lib/MonetDB:/ufs/fabian/scratch/monetdb/current/program-x86_64/lib/bin"
--set
"gdk_dbfarm=/ufs/fabian/scratch/monetdb/current/program-x86_64/var/MonetDB/dbfarm"
--set
"sql_logdir=/ufs/fabian/scratch/monetdb/current/program-x86_64/var/MonetDB/log"
--set mapi_port=38933 --set sql_port=45579 --set xquery_port=52530 --set
monet_prompt= --trace "--dbname=mTests_src_test_bugs"
--dbinit="module(sql_server); sql_server_start();" ; echo ; echo Over..
-# 12:59:00 >
-
-# Monet Database Server V4.9.3
-# Copyright (c) 1993-2005, 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.
+# 19:40:41 >
+# 19:40:41 > mserver5
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set gdk_nr_threads=4 --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 mapi_open=true --set xrpc_open=true --set mapi_port=31946 --set
xrpc_port=44499 --set monet_prompt= --trace "--dbname=mTests_src_test_bugs"
--set mal_listing=0 "--dbinit= include sql;" ; echo ; echo Over..
+# 19:40:41 >
-printf("\nReady.\n");
+# MonetDB server v5.9.0, based on kernel v1.27.0
+# Serving database 'mTests_src_test_bugs', using 4 threads
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically
linked
+# Copyright (c) 1993-July 2008 CWI.
+# Copyright (c) August 2008- MonetDB B.V., all rights reserved
+# Visit http://monetdb.cwi.nl/ for further information
+# Listening for connection requests on mapi:monetdb://alf.ins.cwi.nl:31946/
+# MonetDB/SQL module v2.27.0 loaded
Ready.
-quit();
+#function user.main():void;
+# clients.quit();
+#end main;
Over..
@@ -27,7 +31,7 @@
[ 1 ]
[ 1 ]
[ 1 ]
-% sys.urlparts # table_name
+% .urlparts # table_name
% urlid # name
% int # type
% 4 # length
@@ -36,7 +40,7 @@
[ 329 ]
[ 3857 ]
[ 3868 ]
-% sys.urlparts # table_name
+% .urlparts # table_name
% urlid # name
% int # type
% 4 # length
U union-bug-sf-978045.stable.out
Index: union-bug-sf-978045.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/bugs/Tests/union-bug-sf-978045.stable.out,v
retrieving revision 1.12
retrieving revision 1.13
diff -u -d -r1.12 -r1.13
--- union-bug-sf-978045.stable.out 3 Jul 2008 04:41:35 -0000 1.12
+++ union-bug-sf-978045.stable.out 30 Dec 2008 19:19:06 -0000 1.13
@@ -25,14 +25,14 @@
# 12:51:49 >
[ 3 ]
-% sys.t978045 # table_name
+% .t978045 # table_name
% name # name
% varchar # type
% 6 # length
[ "niels" ]
[ "fabian" ]
[ "martin" ]
-% sys.t978045 # table_name
+% .t978045 # table_name
% name # name
% varchar # type
% 6 # length
U subselect_multiple_unionall_where_1=1-bug-sf-1005596.stable.out
Index: subselect_multiple_unionall_where_1=1-bug-sf-1005596.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/bugs/Tests/subselect_multiple_unionall_where_1=1-bug-sf-1005596.stable.out,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -d -r1.6 -r1.7
--- subselect_multiple_unionall_where_1=1-bug-sf-1005596.stable.out 29 Jun
2007 11:29:36 -0000 1.6
+++ subselect_multiple_unionall_where_1=1-bug-sf-1005596.stable.out 30 Dec
2008 19:19:06 -0000 1.7
@@ -1,19 +1,23 @@
stdout of test 'subselect_multiple_unionall_where_1=1-bug-sf-1005596` in
directory 'src/test/bugs` itself:
-# 12:52:32 >
-# 12:52:32 > Mtimeout -timeout 180 Mserver
"--config=/ufs/fabian/scratch/monetdb/current/program-x86_64/etc/MonetDB.conf"
--debug=10 --set
"monet_mod_path=/ufs/fabian/scratch/monetdb/current/program-x86_64/lib/MonetDB:/ufs/fabian/scratch/monetdb/current/program-x86_64/lib/bin"
--set
"gdk_dbfarm=/ufs/fabian/scratch/monetdb/current/program-x86_64/var/MonetDB/dbfarm"
--set
"sql_logdir=/ufs/fabian/scratch/monetdb/current/program-x86_64/var/MonetDB/log"
--set mapi_port=38933 --set sql_port=45579 --set xquery_port=52530 --set
monet_prompt= --trace "--dbname=mTests_src_test_bugs"
--dbinit="module(sql_server); sql_server_start();" ; echo ; echo Over..
-# 12:52:32 >
-
-# Monet Database Server V4.9.3
-# Copyright (c) 1993-2005, 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.
+# 19:40:37 >
+# 19:40:37 > mserver5
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set gdk_nr_threads=4 --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 mapi_open=true --set xrpc_open=true --set mapi_port=31946 --set
xrpc_port=44499 --set monet_prompt= --trace "--dbname=mTests_src_test_bugs"
--set mal_listing=0 "--dbinit= include sql;" ; echo ; echo Over..
+# 19:40:37 >
-printf("\nReady.\n");
+# MonetDB server v5.9.0, based on kernel v1.27.0
+# Serving database 'mTests_src_test_bugs', using 4 threads
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically
linked
+# Copyright (c) 1993-July 2008 CWI.
+# Copyright (c) August 2008- MonetDB B.V., all rights reserved
+# Visit http://monetdb.cwi.nl/ for further information
+# Listening for connection requests on mapi:monetdb://alf.ins.cwi.nl:31946/
+# MonetDB/SQL module v2.27.0 loaded
Ready.
-quit();
+#function user.main():void;
+# clients.quit();
+#end main;
Over..
@@ -26,7 +30,7 @@
% tinyint # type
% 1 # length
[ 1 ]
-% .tables, sys.tables, sys.tables, .tables, .tables,
.tables, .tables, .tables, .tables, .tables #
table_name
+% .tables, .tables, .tables, .tables, .tables,
.tables, .tables, .tables, .tables, .tables #
table_name
% TABLE_CAT, TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS,
TYPE_CAT, TYPE_SCHEM, TYPE_NAME, SELF_REFERENCING_COL_NAME,
REF_GENERATION # name
% char, varchar, varchar, char, char, char, char,
char, char, char # type
% 4, 0, 0, 12, 0, 0, 0, 0, 5, 6 #
length
@@ -35,7 +39,7 @@
% tinyint # type
% 1 # length
[ 2 ]
-% .tables, sys.tables, sys.tables, .tables, .tables,
.tables, .tables, .tables, .tables, .tables #
table_name
+% .tables, .tables, .tables, .tables, .tables,
.tables, .tables, .tables, .tables, .tables #
table_name
% TABLE_CAT, TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS,
TYPE_CAT, TYPE_SCHEM, TYPE_NAME, SELF_REFERENCING_COL_NAME,
REF_GENERATION # name
% char, varchar, varchar, char, char, char, char,
char, char, char # type
% 4, 0, 0, 20, 0, 0, 0, 0, 5, 6 #
length
@@ -44,7 +48,7 @@
% tinyint # type
% 1 # length
[ 3 ]
-% .tables, sys.tables, sys.tables, .tables, .tables,
.tables, .tables, .tables, .tables, .tables #
table_name
+% .tables, .tables, .tables, .tables, .tables,
.tables, .tables, .tables, .tables, .tables #
table_name
% TABLE_CAT, TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS,
TYPE_CAT, TYPE_SCHEM, TYPE_NAME, SELF_REFERENCING_COL_NAME,
REF_GENERATION # name
% char, varchar, varchar, char, char, char, char,
char, char, char # type
% 4, 3, 11, 20, 0, 0, 0, 0, 5, 6 #
length
------------------------------------------------------------------------------
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
