[wp-trac] [WordPress Trac] #40376: WordPress Duplication Post when come to Pagination if using MySQL 5.6, 5.7 and above

[WordPress Trac]

#40376: WordPress Duplication Post when come to Pagination if using MySQL 5.6, 5.7
and above
--------------------------+------------------------------
 Reporter:  shiroamada    |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  General       |     Version:  4.7.3
 Severity:  normal        |  Resolution:
 Keywords:                |     Focuses:
--------------------------+------------------------------

Comment (by shiroamada):

 I reported to MySQL for this issue -
 https://bugs.mysql.com/bug.php?id=85801

 Replied by Developer:

 This is not a bug, see discussion for
 https://bugs.mysql.com/bug.php?id=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.

 So I think WordPress need to be added in this requirement.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/40376#comment:1>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform