Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory
sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv4388/test/BugTracker/Tests
Modified Files:
Tag: SQL_2-24
auto_increment.SF-1834820.stable.out
crash_on_delete.SF-1639108.stable.out
insert_not_exists.SF-1380287.stable.out
intersect_in_subquery.SF-1339411.stable.out
large_prepare_2.SF-1363729.stable.out
proc_insert_into.SF-1958572.stable.out
rand_not_executed_for_every_row.SF-1723791.stable.out
union_order.stable.out with_row_number.SF-1898089.stable.out
Log Message:
Approve the new output due the following fix:
Log Message:
The table name was missing on the query output:
% sky. # table_name
Now it is like this:
% sky.rc3 # table_name
Solution is to look into the base column...
/* there are no table aliases, ie look into the base column */
U auto_increment.SF-1834820.stable.out
Index: auto_increment.SF-1834820.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/auto_increment.SF-1834820.stable.out,v
retrieving revision 1.1.2.3
retrieving revision 1.1.2.4
diff -u -d -r1.1.2.3 -r1.1.2.4
--- auto_increment.SF-1834820.stable.out 29 May 2008 15:59:57 -0000
1.1.2.3
+++ auto_increment.SF-1834820.stable.out 1 Jul 2008 10:55:47 -0000
1.1.2.4
@@ -50,12 +50,12 @@
% 1, 5, 15 # length
[ 1, "wendy", "Wendy\nWones" ]
[ 2, "fred", "Fred Flintstone" ]
-% sys. # table_name
+% sys.sequences # table_name
% count_ # name
% int # type
% 1 # length
[ 1 ]
-% sys. # table_name
+% sys.sequences # table_name
% count_ # name
% int # type
% 1 # length
U with_row_number.SF-1898089.stable.out
Index: with_row_number.SF-1898089.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/with_row_number.SF-1898089.stable.out,v
retrieving revision 1.3
retrieving revision 1.3.2.1
diff -u -d -r1.3 -r1.3.2.1
--- with_row_number.SF-1898089.stable.out 25 Feb 2008 22:28:00 -0000
1.3
+++ with_row_number.SF-1898089.stable.out 1 Jul 2008 10:55:51 -0000
1.3.2.1
@@ -25,7 +25,7 @@
# 20:57:23 >
[ 32605 ]
-% sys. # table_name
+% sys.tradedate # table_name
% cnt # name
% int # type
% 5 # 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.2
retrieving revision 1.2.10.1
diff -u -d -r1.2 -r1.2.10.1
--- union_order.stable.out 30 Mar 2007 17:49:12 -0000 1.2
+++ union_order.stable.out 1 Jul 2008 10:55:50 -0000 1.2.10.1
@@ -1,19 +1,22 @@
stdout of test 'union_order` in directory 'src/test/BugTracker` itself:
-# 15:51:29 >
-# 15:51:29 > Mtimeout -timeout 180 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_port=36178 --set xrpc_port=46380 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
-# 15:51:29 >
-
-# Monet Database Server V4.16.3
-# 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.
+# 11:56:46 >
+# 11:56:46 > mserver5
"--config=/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5/etc/monetdb5.conf"
--debug=10 --set
"monet_mod_path=/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5//lib/MonetDB5:/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5//lib/MonetDB5/lib:/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5//lib/MonetDB5/bin"
--set
"gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5//var/MonetDB5/dbfarm"
--set
"sql_logdir=/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5//var/MonetDB5/sql_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=30364 --set
xrpc_port=49769 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --set mal_listing=0 "--dbinit= include
sql;" ; echo ; echo Over..
+# 11:56:46 >
-printf("\nReady.\n");
+# MonetDB server v5.6.1, based on kernel v1.24.1
+# Serving database 'mTests_src_test_BugTracker'
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically
linked
+# Copyright (c) 1993-2008 CWI, all rights reserved
+# Visit http://monetdb.cwi.nl/ for further information
+# Listening for connection requests on mapi:monetdb://alviss.ins.cwi.nl:30364/
+# MonetDB/SQL module v2.24.1 loaded
Ready.
-quit();
+#function user.main():void;
+# clients.quit();
+#end main;
Over..
@@ -21,11 +24,11 @@
# 15:51:29 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=36178
# 15:51:29 >
-% sys. # table_name
+% sys.tmp_one # table_name
% data # name
% decimal # type
% 6 # length
-% sys. # table_name
+% sys.tmp_one # table_name
% data # name
% decimal # type
% 6 # length
U crash_on_delete.SF-1639108.stable.out
Index: crash_on_delete.SF-1639108.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/crash_on_delete.SF-1639108.stable.out,v
retrieving revision 1.2
retrieving revision 1.2.10.1
diff -u -d -r1.2 -r1.2.10.1
--- crash_on_delete.SF-1639108.stable.out 20 Feb 2007 11:50:48 -0000
1.2
+++ crash_on_delete.SF-1639108.stable.out 1 Jul 2008 10:55:47 -0000
1.2.10.1
@@ -1,19 +1,22 @@
stdout of test 'crash_on_delete.SF-1639108` in directory 'src/test/BugTracker`
itself:
-# 07:57:59 >
-# 07:57:59 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/export/scratch0/niels/rc/Linux-x86_64/lib/MonetDB4:/export/scratch0/niels/rc/Linux-x86_64/lib/MonetDB4/lib:/export/scratch0/niels/rc/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/export/scratch0/niels/rc/Linux-x86_64/var/MonetDB4/dbfarm"
--set "sql_logdir=/export/scratch0/niels/rc/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/export/scratch0/niels/rc/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_port=38438 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
-# 07:57:59 >
-
-# Monet Database Server V4.16.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.
+# 11:56:44 >
+# 11:56:44 > mserver5
"--config=/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5/etc/monetdb5.conf"
--debug=10 --set
"monet_mod_path=/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5//lib/MonetDB5:/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5//lib/MonetDB5/lib:/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5//lib/MonetDB5/bin"
--set
"gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5//var/MonetDB5/dbfarm"
--set
"sql_logdir=/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5//var/MonetDB5/sql_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=30364 --set
xrpc_port=49769 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --set mal_listing=0 "--dbinit= include
sql;" ; echo ; echo Over..
+# 11:56:44 >
-printf("\nReady.\n");
+# MonetDB server v5.6.1, based on kernel v1.24.1
+# Serving database 'mTests_src_test_BugTracker'
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically
linked
+# Copyright (c) 1993-2008 CWI, all rights reserved
+# Visit http://monetdb.cwi.nl/ for further information
+# Listening for connection requests on mapi:monetdb://alviss.ins.cwi.nl:30364/
+# MonetDB/SQL module v2.24.1 loaded
Ready.
-quit();
+#function user.main():void;
+# clients.quit();
+#end main;
Over..
@@ -41,7 +44,7 @@
% 112 # length
[ "the following query causes the server to crash printing
\"sql_optimize.mx:1011: set2pivot: Assertion `n' failed.\"" ]
[ 96 ]
-% sys. # table_name
+% sys.number # table_name
% count_ # name
% int # type
% 2 # length
U intersect_in_subquery.SF-1339411.stable.out
Index: intersect_in_subquery.SF-1339411.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/intersect_in_subquery.SF-1339411.stable.out,v
retrieving revision 1.3
retrieving revision 1.3.14.1
diff -u -d -r1.3 -r1.3.14.1
--- intersect_in_subquery.SF-1339411.stable.out 24 Oct 2006 16:02:55 -0000
1.3
+++ intersect_in_subquery.SF-1339411.stable.out 1 Jul 2008 10:55:48 -0000
1.3.14.1
@@ -1,19 +1,22 @@
stdout of test 'intersect_in_subquery.SF-1339411` in directory
'src/test/BugTracker` itself:
-# 12:47:40 >
-# 12:47:40 > 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_BugTracker"
--dbinit="module(sql_server); sql_server_start();" ; echo ; echo Over..
-# 12:47:40 >
-
-# 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.
+# 11:56:39 >
+# 11:56:39 > mserver5
"--config=/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5/etc/monetdb5.conf"
--debug=10 --set
"monet_mod_path=/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5//lib/MonetDB5:/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5//lib/MonetDB5/lib:/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5//lib/MonetDB5/bin"
--set
"gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5//var/MonetDB5/dbfarm"
--set
"sql_logdir=/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5//var/MonetDB5/sql_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=30364 --set
xrpc_port=49769 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --set mal_listing=0 "--dbinit= include
sql;" ; echo ; echo Over..
+# 11:56:39 >
-printf("\nReady.\n");
+# MonetDB server v5.6.1, based on kernel v1.24.1
+# Serving database 'mTests_src_test_BugTracker'
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically
linked
+# Copyright (c) 1993-2008 CWI, all rights reserved
+# Visit http://monetdb.cwi.nl/ for further information
+# Listening for connection requests on mapi:monetdb://alviss.ins.cwi.nl:30364/
+# MonetDB/SQL module v2.24.1 loaded
Ready.
-quit();
+#function user.main():void;
+# clients.quit();
+#end main;
Over..
@@ -28,7 +31,7 @@
% int # type
% 1 # length
[ 1 ]
-% sys. # table_name
+% sys.urls # table_name
% urlid # name
% int # type
% 1 # length
U large_prepare_2.SF-1363729.stable.out
Index: large_prepare_2.SF-1363729.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/large_prepare_2.SF-1363729.stable.out,v
retrieving revision 1.3
retrieving revision 1.3.4.1
diff -u -d -r1.3 -r1.3.4.1
--- large_prepare_2.SF-1363729.stable.out 8 Oct 2007 09:38:02 -0000
1.3
+++ large_prepare_2.SF-1363729.stable.out 1 Jul 2008 10:55:49 -0000
1.3.4.1
@@ -62,7 +62,7 @@
[ "int", 32, 0 ]
[ "int", 32, 0 ]
[ 1 ]
-% sys. # table_name
+% sys.mytable # table_name
% count_ # name
% int # type
% 1 # length
U proc_insert_into.SF-1958572.stable.out
Index: proc_insert_into.SF-1958572.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/proc_insert_into.SF-1958572.stable.out,v
retrieving revision 1.1.2.2
retrieving revision 1.1.2.3
diff -u -d -r1.1.2.2 -r1.1.2.3
--- proc_insert_into.SF-1958572.stable.out 6 Jun 2008 07:46:48 -0000
1.1.2.2
+++ proc_insert_into.SF-1958572.stable.out 1 Jul 2008 10:55:49 -0000
1.1.2.3
@@ -51,7 +51,7 @@
[ 4, 1, 1, 1, 1, 1, "first row", "first row",
1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
[ 5, 1, 1, 1, 1, 1, "first row", "first row",
1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
[ 6, 1, 1, 1, 1, 1, "first row", "first row",
1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
-% sys. # table_name
+% sys.proc_insert_into_t1 # table_name
% count_ # name
% int # type
% 1 # length
U rand_not_executed_for_every_row.SF-1723791.stable.out
Index: rand_not_executed_for_every_row.SF-1723791.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/rand_not_executed_for_every_row.SF-1723791.stable.out,v
retrieving revision 1.1
retrieving revision 1.1.10.1
diff -u -d -r1.1 -r1.1.10.1
--- rand_not_executed_for_every_row.SF-1723791.stable.out 23 May 2007
22:08:13 -0000 1.1
+++ rand_not_executed_for_every_row.SF-1723791.stable.out 1 Jul 2008
10:55:50 -0000 1.1.10.1
@@ -29,7 +29,7 @@
[ 1 ]
[ 1 ]
[ 1 ]
-% . # table_name
+% .b # table_name
% count_ # name
% int # type
% 1 # length
U insert_not_exists.SF-1380287.stable.out
Index: insert_not_exists.SF-1380287.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/insert_not_exists.SF-1380287.stable.out,v
retrieving revision 1.4
retrieving revision 1.4.12.1
diff -u -d -r1.4 -r1.4.12.1
--- insert_not_exists.SF-1380287.stable.out 10 Dec 2006 01:13:01 -0000
1.4
+++ insert_not_exists.SF-1380287.stable.out 1 Jul 2008 10:55:48 -0000
1.4.12.1
@@ -1,19 +1,22 @@
stdout of test 'insert_not_exists.SF-1380287` in directory
'src/test/BugTracker` itself:
-# 12:47:51 >
-# 12:47:51 > 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_BugTracker"
--dbinit="module(sql_server); sql_server_start();" ; echo ; echo Over..
-# 12:47:51 >
-
-# 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.
+# 11:56:40 >
+# 11:56:40 > mserver5
"--config=/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5/etc/monetdb5.conf"
--debug=10 --set
"monet_mod_path=/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5//lib/MonetDB5:/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5//lib/MonetDB5/lib:/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5//lib/MonetDB5/bin"
--set
"gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5//var/MonetDB5/dbfarm"
--set
"sql_logdir=/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5//var/MonetDB5/sql_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=30364 --set
xrpc_port=49769 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --set mal_listing=0 "--dbinit= include
sql;" ; echo ; echo Over..
+# 11:56:40 >
-printf("\nReady.\n");
+# MonetDB server v5.6.1, based on kernel v1.24.1
+# Serving database 'mTests_src_test_BugTracker'
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically
linked
+# Copyright (c) 1993-2008 CWI, all rights reserved
+# Visit http://monetdb.cwi.nl/ for further information
+# Listening for connection requests on mapi:monetdb://alviss.ins.cwi.nl:30364/
+# MonetDB/SQL module v2.24.1 loaded
Ready.
-quit();
+#function user.main():void;
+# clients.quit();
+#end main;
Over..
@@ -76,7 +79,7 @@
[ 1 ]
[ 1 ]
[ 1 ]
-% sys. # table_name
+% sys.kwtemp # table_name
% count_ # name
% int # type
% 2 # length
@@ -92,7 +95,7 @@
% char # type
% 31 # length
[ "dropping kwTemp" ]
-% sys. # table_name
+% sys.kwmtemp # table_name
% count_ # name
% int # type
% 2 # length
@@ -108,12 +111,12 @@
% char # type
% 27 # length
[ "dropping kwmTemp" ]
-% ., sys. # table_name
+% ., sys.s4_keywords # table_name
% single_value, count_ # name
% char, int # type
% 9, 2 # length
[ "expect 20", 20 ]
-% ., sys. # table_name
+% ., sys.s4_kwm # table_name
% single_value, count_ # name
% char, int # type
% 9, 2 # length
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
