Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv1170/src/test/BugTracker/Tests
Modified Files:
ambiguous_join.SF-1580565.stable.out
bug_in_selection.SF-1892413.stable.out
full_join_crash.SF-1841754.stable.out
like_exp.SF-1613949.stable.out like_perl.SF-1907051.stable.out
range_select.SF-1907006.stable.out
rank_over.SF-1691098.stable.out
set_default_value.SF-1715553.stable.out
set_sql_debug_64__breaking_the_DB.SF-1906287.stable.out
temporary_tables.SF-1715669.stable.out union_order.stable.out
with_only_once.SF-1720293.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 ambiguous_join.SF-1580565.stable.out
Index: ambiguous_join.SF-1580565.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/ambiguous_join.SF-1580565.stable.out,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- ambiguous_join.SF-1580565.stable.out 24 Oct 2006 16:02:54 -0000
1.2
+++ ambiguous_join.SF-1580565.stable.out 30 Dec 2008 19:19:06 -0000
1.3
@@ -1,19 +1,23 @@
stdout of test 'ambiguous_join.SF-1580565` in directory 'src/test/BugTracker`
itself:
-# 12:47:59 >
-# 12:47:59 > 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/lib64/MonetDB:/ufs/niels/scratch/Linux-x86_64/lib64/MonetDB/lib:/ufs/niels/scratch/Linux-x86_64/lib64/MonetDB/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=34274 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit="module(sql_server);
sql_server_start();" ; echo ; echo Over..
-# 12:47:59 >
-
-# 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:38:50 >
+# 19:38:50 > 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_BugTracker" --set mal_listing=0 "--dbinit= include
sql;" ; echo ; echo Over..
+# 19:38:50 >
-printf("\nReady.\n");
+# MonetDB server v5.9.0, based on kernel v1.27.0
+# Serving database 'mTests_src_test_BugTracker', 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..
@@ -23,7 +27,7 @@
[ 1 ]
[ 1 ]
-% sys.b, sys.b2 # table_name
+% .b, .b2 # table_name
% id, id # name
% int, int # type
% 1, 1 # length
U temporary_tables.SF-1715669.stable.out
Index: temporary_tables.SF-1715669.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/temporary_tables.SF-1715669.stable.out,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- temporary_tables.SF-1715669.stable.out 10 May 2007 12:21:01 -0000
1.3
+++ temporary_tables.SF-1715669.stable.out 30 Dec 2008 19:19:06 -0000
1.4
@@ -1,14 +1,23 @@
stdout of test 'temporary_tables.SF-1715669` in directory
'src/test/BugTracker` itself:
-# 11:44:58 >
-# 11:44:58 > Mtimeout -timeout 180 mserver5
"--config=/ufs/goncalve/scratch/MonetDB/MonetDB5/etc/monetdb5.conf" --debug=10
--set
"monet_mod_path=/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5:/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5/lib:/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/dbfarm"
--set "sql_logdir=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/sql_logs"
--set
"xquery_logdir=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/xquery_logs"
--set mapi_port=36802 --set xrpc_port=42131 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=' include sql;' ; echo ; echo
Over..
-# 11:44:58 >
+# 19:38:56 >
+# 19:38:56 > 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_BugTracker" --set mal_listing=0 "--dbinit= include
sql;" ; echo ; echo Over..
+# 19:38:56 >
-printf("\nReady.\n");
+# MonetDB server v5.9.0, based on kernel v1.27.0
+# Serving database 'mTests_src_test_BugTracker', 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:44:58 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=36802
# 11:44:58 >
-% sys.tables # table_name
+% .tables # table_name
% name # name
% varchar # type
% 0 # length
U bug_in_selection.SF-1892413.stable.out
Index: bug_in_selection.SF-1892413.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/bug_in_selection.SF-1892413.stable.out,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- bug_in_selection.SF-1892413.stable.out 21 Feb 2008 13:42:22 -0000
1.2
+++ bug_in_selection.SF-1892413.stable.out 30 Dec 2008 19:19:06 -0000
1.3
@@ -34,7 +34,7 @@
[ 19251231 ]
[ 19260102 ]
[ 19260104 ]
-% sys.t1, sys.test_subquery # table_name
+% .t1, .test_subquery # table_name
% date, dtnext # name
% int, int # type
% 8, 8 # length
U like_exp.SF-1613949.stable.out
Index: like_exp.SF-1613949.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/like_exp.SF-1613949.stable.out,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- like_exp.SF-1613949.stable.out 7 Dec 2008 18:38:16 -0000 1.3
+++ like_exp.SF-1613949.stable.out 30 Dec 2008 19:19:06 -0000 1.4
@@ -25,7 +25,7 @@
# 21:38:42 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=33867 < like_exp.SF-1613949.sql
# 21:38:42 >
-% sys.tables, sys.tables, sys.tables, sys.tables, sys.tables,
sys.tables, sys.tables, .tables # table_name
+% .tables, .tables, .tables, .tables, .tables,
.tables, .tables, .tables # table_name
% id, name, schema_id, query, type, system, commit_action,
temporary # name
% int, varchar, int, varchar, smallint, boolean,
smallint, tinyint # type
% 1, 0, 1, 0, 1, 5, 1, 1 # length
U union_order.stable.out
Index: union_order.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/union_order.stable.out,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- union_order.stable.out 3 Jul 2008 04:41:28 -0000 1.3
+++ union_order.stable.out 30 Dec 2008 19:19:06 -0000 1.4
@@ -24,15 +24,15 @@
# 15:51:29 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=36178
# 15:51:29 >
-% sys.tmp_one # table_name
+% .tmp_one # table_name
% data # name
% decimal # type
% 6 # length
-% sys.tmp_one # table_name
+% .tmp_one # table_name
% data # name
% decimal # type
% 6 # length
-% sys.foo # table_name
+% .foo # table_name
% data # name
% decimal # type
% 6 # length
U with_only_once.SF-1720293.stable.out
Index: with_only_once.SF-1720293.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/with_only_once.SF-1720293.stable.out,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- with_only_once.SF-1720293.stable.out 7 Dec 2008 18:47:21 -0000
1.4
+++ with_only_once.SF-1720293.stable.out 30 Dec 2008 19:19:06 -0000
1.5
@@ -24,12 +24,12 @@
# 22:41:45 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=32869
# 22:41:45 >
-% sys.t # table_name
+% .t # table_name
% L1 # name
% wrd # type
% 2 # length
[ 26 ]
-% sys.t # table_name
+% .t # table_name
% L2 # name
% wrd # type
% 2 # length
U set_default_value.SF-1715553.stable.out
Index: set_default_value.SF-1715553.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/set_default_value.SF-1715553.stable.out,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- set_default_value.SF-1715553.stable.out 9 May 2007 22:16:54 -0000
1.1
+++ set_default_value.SF-1715553.stable.out 30 Dec 2008 19:19:06 -0000
1.2
@@ -21,37 +21,37 @@
# 00:12:35 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=35378
# 00:12:35 >
-% sys.columns, sys.columns, sys.columns # table_name
+% .columns, .columns, .columns # table_name
% name, default, null # name
% varchar, varchar, boolean # type
% 2, 2, 5 # length
[ "id", "50", true ]
-% sys.columns, sys.columns, sys.columns # table_name
+% .columns, .columns, .columns # table_name
% name, default, null # name
% varchar, varchar, boolean # type
% 2, 2, 5 # length
[ "id", "30", true ]
-% sys.columns, sys.columns, sys.columns # table_name
+% .columns, .columns, .columns # table_name
% name, default, null # name
% varchar, varchar, boolean # type
% 2, 1, 5 # length
[ "id", NULL, true ]
-% sys.columns, sys.columns, sys.columns # table_name
+% .columns, .columns, .columns # table_name
% name, default, null # name
% varchar, varchar, boolean # type
% 2, 1, 5 # length
[ "id", NULL, true ]
-% sys.columns, sys.columns, sys.columns # table_name
+% .columns, .columns, .columns # table_name
% name, default, null # name
% varchar, varchar, boolean # type
% 2, 1, 5 # length
[ "id", NULL, true ]
-% sys.columns, sys.columns, sys.columns # table_name
+% .columns, .columns, .columns # table_name
% name, default, null # name
% varchar, varchar, boolean # type
% 2, 1, 5 # length
[ "id", NULL, true ]
-% sys.columns, sys.columns, sys.columns # table_name
+% .columns, .columns, .columns # table_name
% name, default, null # name
% varchar, varchar, boolean # type
% 2, 1, 5 # length
U full_join_crash.SF-1841754.stable.out
Index: full_join_crash.SF-1841754.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/full_join_crash.SF-1841754.stable.out,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -d -r1.5 -r1.6
--- full_join_crash.SF-1841754.stable.out 21 Dec 2008 19:38:22 -0000
1.5
+++ full_join_crash.SF-1841754.stable.out 30 Dec 2008 19:19:06 -0000
1.6
@@ -31,14 +31,14 @@
[ 1 ]
[ 1 ]
[ 1 ]
-% sys.L7, sys.t1, sys.t2 # table_name
+% .L7, .t1, .t2 # table_name
% name, n, n # name
% clob, int, int # type
% 2, 2, 2 # length
[ "aa", 11, 12 ]
[ "bb", NULL, 22 ]
[ "dd", NULL, 42 ]
-% sys.L11, sys.t1, sys.t2, sys.t3 # table_name
+% .L11, .t1, .t2, .t3 # table_name
% name, n, n, n # name
% clob, int, int, int # type
% 2, 2, 2, 2 # length
@@ -46,7 +46,7 @@
[ "bb", NULL, 22, 23 ]
[ "dd", NULL, 42, NULL ]
[ "cc", NULL, NULL, 33 ]
-% sys.L12, sys.L12 # table_name
+% .L12, .L12 # table_name
% name, n # name
% clob, int # type
% 2, 2 # length
@@ -54,7 +54,7 @@
[ "aa", 12 ]
[ "bb", 22 ]
[ "dd", 42 ]
-% sys.L14, sys.L14 # table_name
+% .L14, .L14 # table_name
% name, n # name
% clob, int # type
% 2, 2 # length
U rank_over.SF-1691098.stable.out
Index: rank_over.SF-1691098.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/rank_over.SF-1691098.stable.out,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -d -r1.6 -r1.7
--- rank_over.SF-1691098.stable.out 3 Nov 2008 15:32:05 -0000 1.6
+++ rank_over.SF-1691098.stable.out 30 Dec 2008 19:19:06 -0000 1.7
@@ -25,7 +25,7 @@
# 16:03:46 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=38533
# 16:03:46 >
-% sys. # table_name
+% . # table_name
% foo # name
% int # type
% 2 # length
U like_perl.SF-1907051.stable.out
Index: like_perl.SF-1907051.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/like_perl.SF-1907051.stable.out,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- like_perl.SF-1907051.stable.out 10 Mar 2008 10:16:59 -0000 1.2
+++ like_perl.SF-1907051.stable.out 30 Dec 2008 19:19:06 -0000 1.3
@@ -24,7 +24,7 @@
# 00:07:59 > mclient -lsql -umonetdb -Pmonetdb --host=amelia --port=36386
# 00:07:59 >
-% sys.tables # table_name
+% .tables # table_name
% name # name
% varchar # type
% 0 # length
U range_select.SF-1907006.stable.out
Index: range_select.SF-1907006.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/range_select.SF-1907006.stable.out,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- range_select.SF-1907006.stable.out 14 Mar 2008 12:10:09 -0000 1.1
+++ range_select.SF-1907006.stable.out 30 Dec 2008 19:19:06 -0000 1.2
@@ -24,7 +24,7 @@
# 12:43:18 > mclient -lsql -umonetdb -Pmonetdb --host=koala --port=30892
# 12:43:18 >
-% sys.tables # table_name
+% .tables # table_name
% name # name
% varchar # type
% 0 # length
U set_sql_debug_64__breaking_the_DB.SF-1906287.stable.out
Index: set_sql_debug_64__breaking_the_DB.SF-1906287.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/set_sql_debug_64__breaking_the_DB.SF-1906287.stable.out,v
retrieving revision 1.9
retrieving revision 1.10
diff -u -d -r1.9 -r1.10
--- set_sql_debug_64__breaking_the_DB.SF-1906287.stable.out 12 Dec 2008
22:28:26 -0000 1.9
+++ set_sql_debug_64__breaking_the_DB.SF-1906287.stable.out 30 Dec 2008
19:19:06 -0000 1.10
@@ -31,7 +31,7 @@
# Visit http://monetdb.cwi.nl/ for further information
# Listening for connection requests on mapi:monetdb://alf.ins.cwi.nl:37754/
# MonetDB/SQL module v2.27.0 loaded
-% .users, sys.users, sys.users # table_name
+% .users, .users, .users # table_name
% name, fullname, default_schema # name
% varchar, varchar, int # type
% 9, 10, 4 # length
------------------------------------------------------------------------------
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
