Bug #53186 for SQL-Statement: SQL : DISTINCT clause dosen't work

Mon Dec 28 10:19:34 2009 kssgill [...] hotmail.com - Ticket created

Hi This is an easily reproducable bug.

SQL - DISTINCT clause dosen't work.

SELECT data_display_mask FROM test.csv returns 200 plus rows. SELECT DISTINCT data_display_mask FROM test.csv returns the warning message and same 200 rows.

If i do an awk, sort -u for unique ( values of the row ) I get 36 values, which is what I would expect.

Certainly a bug in the code.

-Kanwar

perl -V
Summary of my perl5 (revision 5 version 10 subversion 0) configuration:
Platform:
osname=linux, osvers=2.2.24-6.2.3, archname=i686-linux-thread-multi

DBD::CSV 0.26
SQL::Parser 1.23
DBI 1.609

example:

Specifying DISTINCT when using aggregate functions isn't reasonable - ignored. at /opt/perl2exe/perl5/lib/site_perl/5.10.0/SQL/Parser.pm line 496.
87060
87060
87060
87060
<snipped>

SQL used is SELECT DISTINCT entry_id FROM test.csv

Mon Dec 28 10:22:33 2009 kssgill [...] hotmail.com - Subject changed from (no value) to 'SQL : DISTINCT clause dosen't work'

Mon Dec 28 15:14:40 2009 REHSACK [...] cpan.org - Correspondence added

The issue has been reported by HMBRAND, too - the fix will be included in 1.24.

Thanks for reporting.

Mon Dec 28 15:14:42 2009 The RT System itself - Status changed from 'new' to 'open'

Mon Dec 28 15:14:42 2009 REHSACK [...] cpan.org - Status changed from 'open' to 'patched'

Mon Mar 15 17:42:42 2010 REHSACK [...] cpan.org - Correspondence added

Fixed in 1.24

Mon Mar 15 17:42:44 2010 The RT System itself - Status changed from 'patched' to 'open'

Mon Mar 15 17:48:22 2010 REHSACK [...] cpan.org - Fixed in 1.24 added

Mon Mar 15 18:09:13 2010 REHSACK [...] cpan.org - Status changed from 'open' to 'resolved'