Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#3495 (ok 3.4.10) SELECT DISTINCT displays wrong total

3.4.8
fixed
Marc Delisle
1
2013-06-11
2011-12-22
aaronott
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

1 2 > >> (Page 1 of 2)
  • aaronott
    aaronott
    2011-12-22

     
    Attachments
  • aaronott
    aaronott
    2011-12-22

     
    Attachments
  • aaronott
    aaronott
    2011-12-22

    • priority: 5 --> 2
     
  • Marc Delisle
    Marc Delisle
    2011-12-28

    • assigned_to: nobody --> lem9
     
  • aaronott
    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
     
  • Marc Delisle
    Marc Delisle
    2011-12-28

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

     
  • Marc Delisle
    Marc Delisle
    2011-12-28

    • summary: SELECT DISTINCT displays wrong total records found --> SELECT DISTINCT displays wrong total records found
    • status: open-fixed --> open
     
  • aaronott
    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

     
  • Marc Delisle
    Marc Delisle
    2011-12-28

    • priority: 2 --> 1
    • status: open-fixed --> open
     
  • Marc Delisle
    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
     
1 2 > >> (Page 1 of 2)