[wp-trac] [WordPress Trac] #32081: comments query w/ meta_value and comments__in returns clause is ambiguous db error

[WordPress Trac]

#32081: comments query w/ meta_value and comments__in returns clause is ambiguous
db error
----------------------------------------+---------------------------
 Reporter:  willgladstone               |       Owner:  boonebgorges
     Type:  defect (bug)                |      Status:  closed
 Priority:  normal                      |   Milestone:  4.3
Component:  Comments                    |     Version:  4.1.2
 Severity:  normal                      |  Resolution:  fixed
 Keywords:  has-patch needs-unit-tests  |     Focuses:
----------------------------------------+---------------------------
Changes (by boonebgorges):

 * status:  assigned => closed
 * resolution:   => fixed


Comment:

 In [changeset:"32461"]:
 {{{
 #!CommitTicketReference repository="" revision="32461"
 Use table prefix for `comment__in` and `comment__not_in` SQL clauses of
 `WP_Comment_Query`.

 The prefix prevents ambiguity when joining against other tables.

 Props willgladstone.
 Fixes #32081.
 }}}

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