Bug 189054 - SELECT DISTINCT returns no rows in some cases
Summary: SELECT DISTINCT returns no rows in some cases
Status: CLOSED RAWHIDE
Alias: None
Product: Fedora
Classification: Fedora
Component: mysql
Version: 5
Hardware: All
OS: Linux
medium
high
Target Milestone: ---
Assignee: Tom Lane
QA Contact: David Lawrence
URL:
Whiteboard:
Keywords:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2006-04-15 05:20 UTC by Martin Kessler
Modified: 2013-07-03 03:09 UTC (History)
2 users (show)

(edit)
Clone Of:
(edit)
Last Closed: 2006-05-18 01:56:59 UTC

Attachments (Terms of Use)
Add an attachment (proposed patch, testcase, etc.)

Description Martin Kessler 2006-04-15 05:20:27 UTC 
Description of problem:
SELECT DISTINCT fails in some case as well as SELECT ..... GROUP BY field even
if there are valid fields in the database. A SELECT w/o DISTINCT or GROUP BY
retrieves the rows.


Version-Release number of selected component (if applicable):
5.0.18 myslqd

How reproducible:


Steps to Reproduce:
1.
2.
3.
  
Actual results:


Expected results:


Additional info:
According to the mysql website, this problem is fixed in 5.0.20 but there is no
update, bugfix for FC5 available as of this moment.
Comment 1 Tom Lane 2006-05-18 01:56:59 UTC 
5.0.21 is now pushed for FC5.
Note You need to log in before you can comment on or make changes to this bug.