Update of /cvsroot/monetdb/sql/src/test/VOC
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv24629
Modified Files:
Tag: SQL_2-20
VOCquery.sql run.all
Log Message:
added test for
[ 1796269 ] SQL: hangs/crashes on 'exists' subqueries after a join
Index: VOCquery.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/VOC/VOCquery.sql,v
retrieving revision 1.2
retrieving revision 1.2.10.1
diff -u -d -r1.2 -r1.2.10.1
--- VOCquery.sql 15 Sep 2006 09:01:21 -0000 1.2
+++ VOCquery.sql 19 Nov 2007 17:31:59 -0000 1.2.10.1
@@ -3,4 +3,17 @@
select boatname from "voyages";
select distinct boatname from "voyages";
+
+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');
+
+select count(*) from craftsmen c, passengers p
+where c.trip = p.trip and exists (select 1) ;
+
+select count(*) from craftsmen c ;
+select count(*) from craftsmen c where exists (select 1) ;
+
commit;
Index: run.all
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/VOC/run.all,v
retrieving revision 1.11
retrieving revision 1.11.2.1
diff -u -d -r1.11 -r1.11.2.1
--- run.all 22 Aug 2007 06:22:23 -0000 1.11
+++ run.all 19 Nov 2007 17:31:59 -0000 1.11.2.1
@@ -37,4 +37,4 @@
$SQL < VOCmanual_examples.sql
#Cleanup
-$SQL < VOCdrop.sql
+#$SQL < VOCdrop.sql
-------------------------------------------------------------------------
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
