[wp-trac] [WordPress Trac] #44349: Posts show up multiple times in backend when they have the exact same date

[WordPress Trac]

#44349: Posts show up multiple times in backend when they have the exact same date
-------------------------------------------+------------------------------
 Reporter:  wzshop                         |       Owner:  (none)
     Type:  defect (bug)                   |      Status:  new
 Priority:  normal                         |   Milestone:  Awaiting Review
Component:  Query                          |     Version:  4.9.6
 Severity:  normal                         |  Resolution:
 Keywords:  reporter-feedback 2nd-opinion  |     Focuses:
-------------------------------------------+------------------------------

Comment (by johnbillion):

 I've seen this indeterminate sort order bug appear in several places in
 core when working on applications that ingest or generate a large amount
 data in bulk, therefore resulting in multiple posts with the exact same
 date.

 The correct solution is to add secondary field to the orderby clause, as
 suggested above, eg `post_date, ID`, but this would need careful
 consideration.

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