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
     
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.