Menu

#4473 (ok 4.2.5) incorrect result count when having clause is used

4.2.4
fixed
None
1
2014-06-26
2014-06-24
No

When select query having 'having' clause is used in place of 'where' clause i.e. without using a 'group by' statement like this:

    select * from sakila.actor having actor_id = 1

It shows wrong number of rows in "Showing rows.." message. It shows total number of rows present in table in the message instead of actual number of rows present in result set.

With reference to this stackoverflow post: http://stackoverflow.com/questions/24384953/phpmyadmin-incorrect-results-count

Discussion

  • Chirayu Chiripal

    I am working on it.

    Thanks.

     
  • Marc Delisle

    Marc Delisle - 2014-06-25
    • summary: incorrect result count when having clause is used --> (ok 4.2.5) incorrect result count when having clause is used
    • status: open --> resolved
    • assigned_to: Marc Delisle
    • Priority: 5 --> 1
     
  • Marc Delisle

    Marc Delisle - 2014-06-26
    • Status: resolved --> fixed