Bug #85801 Order By limit pagination have duplicated record
Submitted: 5 Apr 2017 8:54 Modified: 12 Apr 2017 12:07
Reporter: Shiro Amada Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S2 (Serious)
Version:5.6,5.7 OS:Any
Assigned to: CPU Architecture:Any

[5 Apr 2017 8:54] Shiro Amada
Description:
Here is the detail to explain the case study.

http://dba.stackexchange.com/questions/169163/mysql-5-5-vs-5-6-above-same-database-same-qu...

How to repeat:
http://dba.stackexchange.com/questions/169163/mysql-5-5-vs-5-6-above-same-database-same-qu...

Suggested fix:
It should be order by ID(primary key) by default
[5 Apr 2017 9:22] MySQL Verification Team
Hello Shiro Amada,

Thank you for the report.
Could you please provide exact test case i.e table DDL, and subset of data to reproduce this issue at our end? Please mark it as private after posting here.

Thanks,
Umesh
[6 Apr 2017 10:42] MySQL Verification Team
Hello Shiro Amada,

Thank you for the report.

Thanks,
Umesh
[6 Apr 2017 12:02] Tor Didriksen
Posted by developer:
 
This is not a bug, see discussion for Bug#72076 and documentation at https://dev.mysql.com/doc/refman/5.6/en/limit-optimization.html

If you want order by primary key, you have to say so explicitly.
[12 Apr 2017 12:07] Erlend Dahl
Posted by developer:

[6 Apr 2017 5:02] Tor Didriksen

This is not a bug, see discussion for Bug#72076 and documentation at

https://dev.mysql.com/doc/refman/5.6/en/limit-optimization.html

If you want order by primary key, you have to say so explicitly.