[wp-trac] [WordPress Trac] #30478: Comment query results returned in an inconsistent order on some versions of MySQL

[WordPress Trac]

#30478: Comment query results returned in an inconsistent order on some versions of
MySQL
--------------------------+-----------------------------
 Reporter:  boonebgorges  |      Owner:
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  Comments      |    Version:
 Severity:  normal        |   Keywords:
  Focuses:                |
--------------------------+-----------------------------
 The default 'orderby' for comment queries is 'comment_date_gmt'. When
 multiple comments have the same value for 'comment_date_gmt', MySQL has no
 consistent way to break the tie. This is particularly evident when running
 the unit tests on older versions of MySQL, as the details of this
 tiebreaking algorithm appear to be non-deterministic in MySQL 5.0.x. See
 https://travis-ci.org/pento/develop.wordpress/jobs/41917240 and #30462.

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