Bug #7086 MySQL Query Browser does not do select distinct properly

• Submitted: 7 Dec 2004 23:28
• Modified: 8 Dec 2004 0:03
• Reporter: [ name withheld ]
• Status: Not a Bug
• Category: MySQL Query Browser
• Severity: S3 (Non-critical)
• Version: 1.1.2
• OS: Windows (winXP)
• CPU Architecture: Any

[7 Dec 2004 23:28] [ name withheld ]

Description:
When executing 'select distinct' in the query browser, it adds a hidden field of the primary key to the query, breaking the distinctness.

How to repeat:
do a select distinct from the query browser on a field which is not primary key

[8 Dec 2004 0:03] Michael G. Zinner

Thanks for reporting. You can turn the addition of the PK column of by going to Tools > Options ... and make sure the option 

[ ] Enforce queries to be editable by adding primary key columns to the select

is not checked. This option is meant to help novice users to edit their data even if they don't select the PK column.