[wp-trac] [WordPress Trac] #34838: Comment descendant queries do not have determinate order

WordPress Trac noreply at wordpress.org
Thu Dec 3 15:33:26 UTC 2015


#34838: Comment descendant queries do not have determinate order
--------------------------+------------------
 Reporter:  boonebgorges  |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  high          |   Milestone:  4.4
Component:  Comments      |     Version:
 Severity:  major         |  Resolution:
 Keywords:  has-patch     |     Focuses:
--------------------------+------------------

Comment (by boonebgorges):

 Replying to [comment:2 pento]:
 > Should it be ordered by `comment_ID` or `comment_date`, for if the
 comment date has been edited?

 Oh right, I forgot that this might be edited. Two things:

 - I like to have `comment_ID` as at least the secondary sort, because
 comment timestamps can be shared, in which case we don't have a
 determinate order.
 - `comment_date` does not have an index, so we should use
 `comment_date_gmt`.

 See [attachment:34838.2.diff]

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


More information about the wp-trac mailing list