phpMyAdmin / Bugs / #4664 (ok 4.3.4) select min() displays 1 row, but reports the table amount of rows returned

#4664 (ok 4.3.4) select min() displays 1 row, but reports the table amount of rows returned

Milestone: 4.3.3

Status: fixed

Owner: Madhura Jayaratne

Labels: None

Priority: 1

Updated: 2014-12-29

Created: 2014-12-23

Private: No

I just did "SELECT min(field) FROM table WHERE 1".
What I ended up with was "Showing rows 0-249 (171263438 total, Query took ...)"

And the result showed 1 row.

So this count is clearly wrong. No problem for the usage. Just thought to report it.

1 Attachments

Clipboard01.jpg

Discussion

Madhura Jayaratne - 2014-12-23

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

Madhura Jayaratne - 2014-12-23

Interestingly "SELECT min(field) FROM table WHERE true" returns correct results.

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

Madhura Jayaratne - 2014-12-23

Fixed with https://github.com/phpmyadmin/phpmyadmin/commit/7cf678f79df2fb017bcb74750cf1108ff4ee55f4

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

Marc Delisle - 2014-12-29

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