#3683 (ok 4.0.0-rc2) Incorrect listing of records from to count

[Jørgen Thomsen]

Viser poster 500 - 499 ( 11 total, forepørgsel tog 0.0017 sek)

SELECT *
FROM `kundeprodaktive`
WHERE `nr` =1394
ORDER BY `kundeprodaktive`.`produkt` ASC
LIMIT 500

Clearly it should have been 0-10 and not 500 - 499

[Marc Delisle]

Please attach an export with your table's structure and data. Also, which steps did you do to produce this query?

[Jørgen Thomsen]

May I suggest just executing a similar SQL statement in any table.
It shows the same behaviour everywhere I have tried it.
Also in 3.5.5

[Marc Delisle]

Confirmed and can be reproduced with sample database sakila and this query:

SELECT *
FROM film
WHERE replacement_cost = 14.99
ORDER BY film.description ASC
LIMIT 500

[Marc Delisle]

Fixed with https://github.com/phpmyadmin/phpmyadmin/commit/1a459f357544e225830a8878fafe775ba297284c