Update of /cvsroot/monetdb/sql/src/test/VOC
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv19709/src/test/VOC
Modified Files:
VOCquery.sql run.all
Log Message:
propagated changes of Saturday Nov 17 2007 - Tuesday Nov 20 2007
from the SQL_2-20 branch to the development trunk
Index: VOCquery.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/VOC/VOCquery.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- VOCquery.sql 15 Sep 2006 09:01:21 -0000 1.2
+++ VOCquery.sql 20 Nov 2007 13:27:01 -0000 1.3
@@ -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.12
diff -u -d -r1.11 -r1.12
--- run.all 22 Aug 2007 06:22:23 -0000 1.11
+++ run.all 20 Nov 2007 13:27:02 -0000 1.12
@@ -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
