phpMyAdmin / Bugs / #3495 (ok 3.4.10) SELECT DISTINCT displays wrong total

#3495 (ok 3.4.10) SELECT DISTINCT displays wrong total

Milestone: 3.4.8

Status: fixed

Owner: Marc Delisle

Labels: Displaying results (268)

Priority: 1

Updated: 2013-06-11

Created: 2011-12-22

Creator: aaronott

Private: No

I've tested this on two versions of phpMyAdmin including 3.3.7 and 3.4.8 and using both MyISAM and INNODB engines.

SELECT DISTINCT(column) FROM table; returns the wrong count.

If I add the LIMIT exactly like it shows in the result the correct count is returned.
SELECT DISTINCT(column) FROM table LIMIT 0,30;

Discussion

aaronott - 2011-12-22

wrong_count.png

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

aaronott - 2011-12-22

correct_count.png

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

aaronott - 2011-12-22

priority: 5 --> 2
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2011-12-28

assigned_to: nobody --> lem9
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

aaronott - 2011-12-28

priority: 1 --> 2

summary: (ok 3.4.10) SELECT DISTINCT displays wrong record count --> SELECT DISTINCT displays wrong total records found

status: open-fixed --> open
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2011-12-28

This bug was fixed in repository and will be part of a future release; thanks for reporting.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2011-12-28

summary: SELECT DISTINCT displays wrong total records found --> SELECT DISTINCT displays wrong total records found

status: open-fixed --> open
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

aaronott - 2011-12-28

@lem9 - I apologize for not posting back to this bug report, but i've posted a patch to this issue at https://sourceforge.net/tracker/?group_id=23067&atid=377410

Thanks for looking at this.
- aaronott

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2011-12-28

priority: 2 --> 1

status: open-fixed --> open
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2011-12-28

priority: 2 --> 1

summary: SELECT DISTINCT displays wrong total records found --> (ok 3.4.10) SELECT DISTINCT displays wrong total

status: open --> open-fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2011-12-28

This bug was fixed in repository and will be part of a future release; thanks for reporting.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2012-02-14

status: open-fixed --> closed-fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Michal Čihař - 2013-06-11

Status: closed-fixed --> fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link: