Update of /cvsroot/monetdb/sql/src/test/VOC/Tests
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv6467/Tests
Modified Files:
Tag: May2009
VOC.stable.out
Log Message:
changed after user dependency checking got stricter
U VOC.stable.out
Index: VOC.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/VOC/Tests/VOC.stable.out,v
retrieving revision 1.4
retrieving revision 1.4.10.1
diff -u -d -r1.4 -r1.4.10.1
--- VOC.stable.out 2 Feb 2008 10:10:33 -0000 1.4
+++ VOC.stable.out 8 Jun 2009 05:55:56 -0000 1.4.10.1
@@ -97274,7 +97274,7 @@
where c.trip = v.trip and v.boatname = 'AMSTERDAM'
and v.departure_harbour ='Texel');
+---------+
-| count_ |
+| L3 |
+=========+
| 1305366 |
+---------+
@@ -97284,7 +97284,7 @@
select count(*) from craftsmen c, passengers p
where c.trip = p.trip and exists (select 1) ;
+---------+
-| count_ |
+| L4 |
+=========+
| 1308285 |
+---------+
@@ -97293,7 +97293,7 @@
select count(*) from craftsmen c ;
+--------+
-| count_ |
+| L5 |
+========+
| 2349 |
+--------+
@@ -97301,7 +97301,7 @@
select count(*) from craftsmen c where exists (select 1) ;
+--------+
-| count_ |
+| L6 |
+========+
| 2349 |
+--------+
@@ -97330,7 +97330,6 @@
UNION ALL
SELECT 'total' AS type, total.* FROM total
) AS onboard_people_table;
-Operation successful
SELECT type, COUNT(*) AS total FROM onboard_people GROUP BY type ORDER BY type;
@@ -97349,7 +97348,7 @@
select count(*) from impotenten;
+--------+
-| count_ |
+| L2 |
+========+
| 938 |
+--------+
@@ -97358,7 +97357,7 @@
SELECT COUNT(*) FROM voyages WHERE particulars LIKE '%_recked%';
+--------+
-| count_ |
+| L3 |
+========+
| 358 |
+--------+
@@ -97389,7 +97388,6 @@
left_at_cape, onboard_at_cape, death_during_voyage, onboard_at_arrival,
death_during_voyage - left_at_cape AS death_at_arrival
FROM onboard_people;
-Operation successful
@@ -97438,12 +97436,15 @@
Operation successful
-DROP USER "voc";
+ALTER USER "voc" SET SCHEMA "sys";
Operation successful
DROP SCHEMA "voc";
Operation successful
+DROP USER "voc";
+Operation successful
+
commit;
Operation successful
------------------------------------------------------------------------------
OpenSolaris 2009.06 is a cutting edge operating system for enterprises
looking to deploy the next generation of Solaris that includes the latest
innovations from Sun and the OpenSource community. Download a copy and
enjoy capabilities such as Networking, Storage and Virtualization.
Go to: http://p.sf.net/sfu/opensolaris-get
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
