Update of /cvsroot/monetdb/sql/src/test/DropCascade/Tests
In directory
sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv2129/src/test/DropCascade/Tests
Modified Files:
drop_columns_cascade.sql
Log Message:
use zero_or_one for subqureis which should return zero or one result
Index: drop_columns_cascade.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/DropCascade/Tests/drop_columns_cascade.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- drop_columns_cascade.sql 12 Jun 2007 17:26:03 -0000 1.3
+++ drop_columns_cascade.sql 27 Jan 2008 19:18:58 -0000 1.4
@@ -48,7 +48,7 @@
select name from functions where name = 'f2';
select name from triggers where name = 'test1';
select name from idxs where name = 'id_index';
-select name from columns where name = 'id' and table_id in (select * from
tables where name = 't1' or name = 't2');
+select name from columns where name = 'id' and table_id in (select id from
tables where name = 't1' or name = 't2');
select name from keys;
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
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
