Update of /cvsroot/monetdb/sql/src/test/BugTracker-2009
In directory
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv21772/src/test/BugTracker-2009
Added Files:
count_distinct.SF-2826015.sql
Log Message:
propagated changes of Thursday Jul 23 2009 - Friday Jul 24 2009
from the May2009 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2009/07/23 - mr-meltdown:
src/test/BugTracker-2009/count_distinct.SF-2826015.sql,1.1.2.1
Add test script for bug #2826015, no test
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--- NEW FILE: count_distinct.SF-2826015.sql ---
create table testdistinct (testcol varchar(24));
insert into testdistinct values ('test');
insert into testdistinct values ('test');
insert into testdistinct values ('test');
insert into testdistinct values ('other');
insert into testdistinct values ('other');
insert into testdistinct values ('other');
select * from testdistinct;
select distinct * from testdistinct;
select count(*) from testdistinct;
select distinct count(*) from testdistinct;
drop table testdistinct;
------------------------------------------------------------------------------
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
