Update of /cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests
In directory
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv22296/src/test/BugTracker-2008/Tests
Modified Files:
is_distinct_broken.SF-2430201.sql
Log Message:
propagated changes of Tuesday Dec 23 2008 - Saturday Dec 27 2008
from the Nov2008 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2008/12/23 - romulog:
src/test/BugTracker-2008/Tests/is_distinct_broken.SF-2430201.sql,1.1.2.3
Change tables names....
In this case of a timeout in server_aborts... (table drop is not executed)
is_distinct is not affected...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Index: is_distinct_broken.SF-2430201.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests/is_distinct_broken.SF-2430201.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- is_distinct_broken.SF-2430201.sql 15 Dec 2008 10:02:19 -0000 1.1
+++ is_distinct_broken.SF-2430201.sql 27 Dec 2008 20:13:42 -0000 1.2
@@ -1,16 +1,16 @@
-create table way_tags (way int, k int);
-insert into way_tags values(23950375,1);
-insert into way_tags values(23950375,1);
-insert into way_tags values(23950375,1);
-insert into way_tags values(23950375,1);
-insert into way_tags values(23950375,1);
-insert into way_tags values(24644162,1);
-insert into way_tags values(24644162,1);
-insert into way_tags values(24644162,1);
+create table way_tags_2430201 (way int, k int);
+insert into way_tags_2430201 values(23950375,1);
+insert into way_tags_2430201 values(23950375,1);
+insert into way_tags_2430201 values(23950375,1);
+insert into way_tags_2430201 values(23950375,1);
+insert into way_tags_2430201 values(23950375,1);
+insert into way_tags_2430201 values(24644162,1);
+insert into way_tags_2430201 values(24644162,1);
+insert into way_tags_2430201 values(24644162,1);
-select distinct way from way_tags group by way, k having count(*) > 1;
+select distinct way from way_tags_2430201 group by way, k having count(*) > 1;
-drop table way_tags;
+drop table way_tags_2430201;
select distinct (select 10 union all select 10);
------------------------------------------------------------------------------
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
