[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