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: | |
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
[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.