Where is the stable output? There is no sense running a test if there is no stable output. Romulo Goncalves wrote:
Update of /cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv15432
Modified Files: Tag: Nov2008 All Added Files: Tag: Nov2008 is_distinct_broken.SF-2430201.sql Log Message: Add test to cover bug: is_distinct_broken.SF-2430201
Note: Please do not propagate this check in. It was already checked in current cvs branch ;)
U All Index: All =================================================================== RCS file: /cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests/All,v retrieving revision 1.6.2.8 retrieving revision 1.6.2.9 diff -u -d -r1.6.2.8 -r1.6.2.9 --- All 19 Nov 2008 10:39:51 -0000 1.6.2.8 +++ All 15 Dec 2008 10:04:26 -0000 1.6.2.9 @@ -30,3 +30,4 @@ count_with_order_by_and_limit_crashes.SF-2229936 sql_command_kills_db.SF-2233677 between_no_columns.SF2102101 +is_distinct_broken.SF-2430201
--- NEW FILE: is_distinct_broken.SF-2430201.sql --- 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);
select distinct way from way_tags group by way, k having count(*) > 1;
drop table way_tags;
select distinct (select 10 union all select 10);
select distinct a from (select 10 as a union all select 10 as a) as b;
------------------------------------------------------------------------------ SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada. The future of the web can't happen without you. Join us at MIX09 to help pave the way to the Next Web now. Learn more and register at http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ _______________________________________________ Monetdb-sql-checkins mailing list Monetdb-sql-checkins@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
-- Sjoerd Mullender