Update of /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests
In directory
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv26968/src/test/BugTracker-2009/Tests
Added Files:
count_distinct_bug.SF-2826015.sql
Log Message:
propagated changes of Friday Aug 07 2009
from the Aug2009 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2009/08/07 - nielsnes:
src/test/BugTracker-2009/Tests/count_distinct_bug.SF-2826015.sql,1.1.2.1
added test for bug in parser (handle distinct correctly now)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--- NEW FILE: count_distinct_bug.SF-2826015.sql ---
create table testdistinct (testcol varchar(10));
insert into testdistinct values ('test'),('test'), ('test'), ('other'),
('other'), ('other');
select * from testdistinct ;
select distinct(testcol) from testdistinct ;
select count(distinct(testcol)) from testdistinct ;
select count(distinct testcol ) from testdistinct ;
drop table testdistinct;
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
