#3495 (ok 3.4.10) SELECT DISTINCT displays wrong total

3.4.8
fixed
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

  • aaronott

    aaronott - 2011-12-22
     
  • aaronott

    aaronott - 2011-12-22
     
  • 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
     
  • 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
     
  • 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 - 2012-02-14
    • status: open-fixed --> closed-fixed
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-fixed --> fixed
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks