Update of /cvsroot/monetdb/sql/src/test/VOC/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv24629/Tests
Modified Files:
Tag: SQL_2-20
VOC.stable.out
Log Message:
added test for
[ 1796269 ] SQL: hangs/crashes on 'exists' subqueries after a join
Index: VOC.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/VOC/Tests/VOC.stable.out,v
retrieving revision 1.2
retrieving revision 1.2.8.1
diff -u -d -r1.2 -r1.2.8.1
--- VOC.stable.out 7 Dec 2006 10:36:50 -0000 1.2
+++ VOC.stable.out 19 Nov 2007 17:32:00 -0000 1.2.8.1
@@ -1,20 +1,16 @@
stdout of test 'VOC` in directory 'src/test/VOC` itself:
-# 10:37:20 >
-# 10:37:20 > Mtimeout -timeout 900 mserver5
"--config=/ufs/goncalve/scratch/MonetDB/monetdb5/etc/MonetDB5.conf" --debug=10
--set "monet_mod_path=/ufs/goncalve/scratch/MonetDB/monetdb5/lib/MonetDB5"
--set "gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/monetdb5/var/MonetDB5/dbfarm"
--set "sql_logdir=/ufs/goncalve/scratch/MonetDB/monetdb5/var/MonetDB5/dblogs"
--set mapi_port=33532 --set monet_prompt= --trace
"--dbname=mTests_src_test_VOC" --dbinit='include sql;' ; echo ; echo Over..
-# 10:37:20 >
-
-
+# 16:58:01 >
+# 16:58:01 > mserver5
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/dbfarm"
--set "sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/sql_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=30785 --set
xrpc_port=45513 --set monet_prompt= --trace "--dbname=mTests_src_test_VOC"
--set mal_listing=0 "--dbinit= include sql;" ; echo ; echo Over..
+# 16:58:01 >
-# MonetDB Server v4.99.19
-# Copyright (c) 1993-2006 CWI, all rights reserved
-# Compiled for i686-redhat-linux-gnu/32bit with 32bit OIDs dynamically linked
-# config:/ufs/goncalve/scratch/MonetDB/monetdb5/etc/MonetDB5.conf
-# dbfarm:/ufs/goncalve/scratch/MonetDB/monetdb5/var/MonetDB5/dbfarm
-# dbname:mTests_src_test_VOC
+# MonetDB server v5.2.1, based on kernel v1.20.1
+# Serving database 'mTests_src_test_VOC'
+# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically linked
+# Copyright (c) 1993-2007 CWI, all rights reserved
# Visit http://monetdb.cwi.nl/ for further information
Ready.
@@ -97271,6 +97267,47 @@
1521 rows
+
+select count(*) from craftsmen c, passengers p
+where c.trip = p.trip and exists
+(select 1 from voyages v
+where c.trip = v.trip and v.boatname = 'AMSTERDAM'
+and v.departure_harbour ='Texel');
++---------+
+| count_ |
++=========+
+| 1305366 |
++---------+
+1 row
+
+
+select count(*) from craftsmen c, passengers p
+where c.trip = p.trip and exists (select 1) ;
++---------+
+| count_ |
++=========+
+| 1308285 |
++---------+
+1 row
+
+
+select count(*) from craftsmen c ;
++--------+
+| count_ |
++========+
+| 2349 |
++--------+
+1 row
+
+select count(*) from craftsmen c where exists (select 1) ;
++--------+
+| count_ |
++========+
+| 2349 |
++--------+
+1 row
+
+
commit;
Operation successful
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
