Update of /cvsroot/monetdb/sql/src/test/BugDay_2005-10-06_2.9.3/Tests
In directory
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv1170/src/test/BugDay_2005-10-06_2.9.3/Tests
Modified Files:
BATpropcheck_error.SF-1012739.stable.out
CrashMe_SQL_server_crash-2.SF-921673.stable.out
UNION_JOIN_vs_plain_set_UNION-2.SF-920585.stable.out
jdbc_crashes_on_getTables.SF_944316.stable.out
reserved_words.SF-939112.stable.out
simple_union.SF-1005596.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 jdbc_crashes_on_getTables.SF_944316.stable.out
Index: jdbc_crashes_on_getTables.SF_944316.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugDay_2005-10-06_2.9.3/Tests/jdbc_crashes_on_getTables.SF_944316.stable.out,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- jdbc_crashes_on_getTables.SF_944316.stable.out 24 Oct 2006 16:02:44
-0000 1.3
+++ jdbc_crashes_on_getTables.SF_944316.stable.out 30 Dec 2008 19:19:06
-0000 1.4
@@ -1,19 +1,23 @@
stdout of test 'jdbc_crashes_on_getTables.SF_944316` in directory
'src/test/BugDay_2005-10-06_2.9.3` itself:
-# 12:37:33 >
-# 12:37:33 > 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_BugDay_2005-10-06_2.9.3"
--dbinit="module(sql_server); sql_server_start();" ; echo ; echo Over..
-# 12:37:33 >
-
-# 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:38:15 >
+# 19:38:15 > 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_BugDay_2005-10-06_2.9.3" --set mal_listing=0
"--dbinit= include sql;" ; echo ; echo Over..
+# 19:38:15 >
-printf("\nReady.\n");
+# MonetDB server v5.9.0, based on kernel v1.27.0
+# Serving database 'mTests_src_test_BugDay_2005-10-06_2.9.3', 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:50:18 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=35781 < jdbc_crashes_on_getTables.SF_944316.sql
# 11:50:18 >
-% .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
% 0, 0, 0, 12, 0, 0, 0, 0, 2, 6 #
length
U BATpropcheck_error.SF-1012739.stable.out
Index: BATpropcheck_error.SF-1012739.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugDay_2005-10-06_2.9.3/Tests/BATpropcheck_error.SF-1012739.stable.out,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- BATpropcheck_error.SF-1012739.stable.out 24 Oct 2006 16:02:42 -0000
1.3
+++ BATpropcheck_error.SF-1012739.stable.out 30 Dec 2008 19:19:06 -0000
1.4
@@ -1,19 +1,23 @@
stdout of test 'BATpropcheck_error.SF-1012739` in directory
'src/test/BugDay_2005-10-06_2.9.3` itself:
-# 12:42:16 >
-# 12:42:16 > 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_BugDay_2005-10-06_2.9.3"
--dbinit="module(sql_server); sql_server_start();" ; echo ; echo Over..
-# 12:42:16 >
-
-# 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:38:23 >
+# 19:38:23 > 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_BugDay_2005-10-06_2.9.3" --set mal_listing=0
"--dbinit= include sql;" ; echo ; echo Over..
+# 19:38:23 >
-printf("\nReady.\n");
+# MonetDB server v5.9.0, based on kernel v1.27.0
+# Serving database 'mTests_src_test_BugDay_2005-10-06_2.9.3', 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:50:39 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=35781 < BATpropcheck_error.SF-1012739.sql
# 11:50:39 >
-% ., 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
% char, varchar, varchar, varchar, int, varchar
# type
% 0, 0, 0, 0, 1, 0 # length
U reserved_words.SF-939112.stable.out
Index: reserved_words.SF-939112.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugDay_2005-10-06_2.9.3/Tests/reserved_words.SF-939112.stable.out,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- reserved_words.SF-939112.stable.out 7 Dec 2008 17:45:47 -0000 1.4
+++ reserved_words.SF-939112.stable.out 30 Dec 2008 19:19:06 -0000 1.5
@@ -25,7 +25,7 @@
# 11:50:36 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=35781 < reserved_words.SF-939112.sql
# 11:50:36 >
-% sys. # table_name
+% . # table_name
% >_L1 # name
% boolean # type
% 5 # length
U CrashMe_SQL_server_crash-2.SF-921673.stable.out
Index: CrashMe_SQL_server_crash-2.SF-921673.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugDay_2005-10-06_2.9.3/Tests/CrashMe_SQL_server_crash-2.SF-921673.stable.out,v
retrieving revision 1.19
retrieving revision 1.20
diff -u -d -r1.19 -r1.20
--- CrashMe_SQL_server_crash-2.SF-921673.stable.out 29 Jun 2007 11:29:13
-0000 1.19
+++ CrashMe_SQL_server_crash-2.SF-921673.stable.out 30 Dec 2008 19:19:06
-0000 1.20
@@ -1,19 +1,23 @@
stdout of test 'CrashMe_SQL_server_crash-2.SF-921673` in directory
'src/test/BugDay_2005-10-06_2.9.3` itself:
-# 17:09:20 >
-# 17:09:20 > 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_port=32522 --set xrpc_port=48909 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugDay_2005-10-06_2.9.3" --dbinit="
module(sql_server);" ; echo ; echo Over..
-# 17:09:20 >
-
-# 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.
+# 19:38:16 >
+# 19:38:16 > 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_BugDay_2005-10-06_2.9.3" --set mal_listing=0
"--dbinit= include sql;" ; echo ; echo Over..
+# 19:38:16 >
-printf("\nReady.\n");
+# MonetDB server v5.9.0, based on kernel v1.27.0
+# Serving database 'mTests_src_test_BugDay_2005-10-06_2.9.3', 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:50:20 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=35781 < CrashMe_SQL_server_crash-2.SF-921673.sql
# 11:50:20 >
-% ., sys.schemas, sys.tables, sys.columns, sys.columns,
sys.columns, sys.columns, ., ., ., ., sys.columns,
., ., ., sys., ., ., . # table_name
+% ., sys.schemas, .tables, .columns, .columns,
.columns, .columns, ., ., ., ., .columns,
., ., ., ., ., ., . # table_name
% table_cat, table_schem, table_name, column_name, type_name,
column_size, decimal_digits, buffer_length, num_prec_radix, nullable,
remarks, column_def, sql_data_type, sql_datetime_sub,
char_octet_length, ordinal_position, scope_catalog, scope_schema,
scope_table # name
% char, varchar, varchar, varchar, varchar,
int, int, tinyint, tinyint, char, char, varchar,
tinyint, tinyint, tinyint, int, char, char, char #
type
% 0, 3, 10, 11, 7, 4, 1, 1, 2, 0,
0, 1, 1, 1, 1, 1, 0, 0, 0 # length
U simple_union.SF-1005596.stable.out
Index: simple_union.SF-1005596.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugDay_2005-10-06_2.9.3/Tests/simple_union.SF-1005596.stable.out,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- simple_union.SF-1005596.stable.out 24 Oct 2006 16:02:44 -0000 1.4
+++ simple_union.SF-1005596.stable.out 30 Dec 2008 19:19:06 -0000 1.5
@@ -1,19 +1,23 @@
stdout of test 'simple_union.SF-1005596` in directory
'src/test/BugDay_2005-10-06_2.9.3` itself:
-# 12:42:01 >
-# 12:42:01 > 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_BugDay_2005-10-06_2.9.3"
--dbinit="module(sql_server); sql_server_start();" ; echo ; echo Over..
-# 12:42:01 >
-
-# 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:38:23 >
+# 19:38:23 > 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_BugDay_2005-10-06_2.9.3" --set mal_listing=0
"--dbinit= include sql;" ; echo ; echo Over..
+# 19:38:23 >
-printf("\nReady.\n");
+# MonetDB server v5.9.0, based on kernel v1.27.0
+# Serving database 'mTests_src_test_BugDay_2005-10-06_2.9.3', 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:50:39 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=35781 < simple_union.SF-1005596.sql
# 11:50:39 >
-% .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, 4, 20, 0, 0, 0, 0, 5, 6 #
length
U UNION_JOIN_vs_plain_set_UNION-2.SF-920585.stable.out
Index: UNION_JOIN_vs_plain_set_UNION-2.SF-920585.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugDay_2005-10-06_2.9.3/Tests/UNION_JOIN_vs_plain_set_UNION-2.SF-920585.stable.out,v
retrieving revision 1.15
retrieving revision 1.16
diff -u -d -r1.15 -r1.16
--- UNION_JOIN_vs_plain_set_UNION-2.SF-920585.stable.out 7 Dec 2008
17:45:46 -0000 1.15
+++ UNION_JOIN_vs_plain_set_UNION-2.SF-920585.stable.out 30 Dec 2008
19:19:06 -0000 1.16
@@ -66,7 +66,7 @@
[ 1 ]
[ 1 ]
[ 1 ]
-% t920585.a, t920585.a, t920585.a, t920585.a, t920585.a,
.a # table_name
+% .a, .a, .a, .a, .a, .a # table_name
% name, query, istable, system, commit_action, temporary # name
% varchar, varchar, boolean, boolean, smallint,
tinyint # type
% 12, 222, 5, 5, 1, 1 # length
@@ -100,7 +100,7 @@
[ "types", NULL, true, true, 0, 0 ]
[ "user_role", NULL, true, true, 0, 0 ]
[ "users", "SELECT u.\"t\" AS \"name\", ui.\"fullname\",
ui.\"default_schema\" FROM \"sys\".\"db_users\" AS u, \"sys\".\"db_user_info\"
AS ui WHERE u.\"h\" = ui.\"id\" AND u.\"h\" NOT IN (SELECT s.\"h\" FROM
\"sys\".\"db_scens\" AS s WHERE s.\"t\" NOT LIKE 'sql');", false, true, 0,
0 ]
-% .tables, t920585.tables, t920585.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, varchar, char,
char, char, char, char # type
% 4, 3, 8, 12, 222, 4, 4, 4, 2, 6 #
length
------------------------------------------------------------------------------
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
