Update of /cvsroot/monetdb/sql/src/test
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv2409
Modified Files:
union.sql
Log Message:
Make the test independent from tables
U union.sql
Index: union.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/union.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- union.sql 17 Apr 2004 08:07:35 -0000 1.1
+++ union.sql 6 Jun 2009 20:21:37 -0000 1.2
@@ -1,9 +1,12 @@
-
+create table uniontmp(i int, s string);
+insert into uniontmp values(1,'hello');
+insert into uniontmp values(2,'world');
select * from
- ( select * from tables union all select * from tables) as a;
+ ( select * from uniontmp union all select * from uniontmp) as a;
select * from
- ( select * from tables union select * from tables) as a;
+ ( select * from uniontmp union select * from uniontmp) as a;
select * from
- ( select * from tables union distinct select * from tables) as a;
+ ( select * from uniontmp union distinct select * from uniontmp) as a;
+drop table uniontmp;
------------------------------------------------------------------------------
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
