[wp-trac] [WordPress Trac] #48020: Queries display in inconsistent order when ordering by meta_value_num

[WordPress Trac]

#48020: Queries display in inconsistent order when ordering by meta_value_num
--------------------------+-----------------------------
 Reporter:  truheart      |      Owner:  (none)
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  General       |    Version:
 Severity:  normal        |   Keywords:
  Focuses:                |
--------------------------+-----------------------------
 So I caught this the other day. When ordering a query by
 {{{meta_value_num}}}, multiple posts sharing the same meta value display
 in a random order such that if you run two identical queries, the order of
 the posts could differ between the two.

 Example use case. I have a custom {{{class}}} post type with a {{{date}}}
 post meta. Many classes share the same date. On the frontend, I am
 displaying 12 classes at a time, ordered by date, and when users select to
 load more I fetch more posts from the server with and query more classes
 with
 {{{'offset' => $classes_showing}}} and {{{'orderby' =>
 'meta_value_num'}}}. Classes belonging to the same show up in different
 orders from query to query, which occasionally results in multiple classes
 shown on the frontend.

 Hopefully that was clear enough. Let me know if you need more code.
 Thanks.

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/48020>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform