[wp-trac] [WordPress Trac] #46294: wp rest api fails to paginate page requests correctly when ordering on menu_order

[WordPress Trac]

#46294: wp rest api fails to paginate page requests correctly when ordering on
menu_order
--------------------------+------------------------------
 Reporter:  hobzhobz      |       Owner:  (none)
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  General       |     Version:
 Severity:  normal        |  Resolution:
 Keywords:                |     Focuses:
--------------------------+------------------------------

Comment (by hobzhobz):

 Note, this is hard to reproduce unless you set menu_order != 0 on many
 pages.

 If menu_order == 0 on all pages this issue doesnt seem to happen, but i
 bet it has to do with mysql internals as its "undefined behavior" how
 mysql sorts when sorting only on a non unique field.

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