Bug #4619 Select distinct does eliminate the duplicate.
Submitted: 19 Jul 2004 6:12 Modified: 19 Jul 2004 23:55
Reporter: Jeff Lu Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.0.3 Alpha OS:Windows (XP)
Assigned to: Alfredo Kojima CPU Architecture:Any

[19 Jul 2004 6:12] Jeff Lu
Description:
Select distinct does eliminate the duplicate.

How to repeat:
Find a table with a lot of rows with the same data in one column.
Do "select distinct column_name from table_name"
All rows will be returned. Duplicates exists.

The same query works as expected in MySQL ControlCenter 0.9.4beta.
Using other query tool returns expected result.

Suggested fix:
Remove duplicate (only distinct) rows.
[19 Jul 2004 23:55] Alfredo Kojima
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html