[wp-trac] [WordPress Trac] #55218: WP_Comment_Query: "Column 'comment_ID' in where clause is ambiguous" when mixing 'include_unapproved' and 'meta_query'

[WordPress Trac]

#55218: WP_Comment_Query: "Column 'comment_ID' in where clause is ambiguous" when
mixing 'include_unapproved' and 'meta_query'
---------------------------------------------+----------------------------
 Reporter:  genosseeinhorn                   |       Owner:  peterwilsoncc
     Type:  defect (bug)                     |      Status:  closed
 Priority:  normal                           |   Milestone:  6.0
Component:  Comments                         |     Version:  5.9
 Severity:  minor                            |  Resolution:  fixed
 Keywords:  has-patch has-unit-tests commit  |     Focuses:
---------------------------------------------+----------------------------
Changes (by peterwilsoncc):

 * owner:  (none) => peterwilsoncc
 * status:  new => closed
 * resolution:   => fixed


Comment:

 In [changeset:"53291" 53291]:
 {{{
 #!CommitTicketReference repository="" revision="53291"
 Comments: Avoid DB error in comment meta queries.

 In `WP_Comment_Query` always include the table name when referencing
 `wp_comments.comment_ID`. This avoids ambiguity in when making meta
 queries as `wp_commentmeta` includes a column of the same name.

 Follow up to [47887].

 Props genosseeinhorn, azouamauriac, audrasjb, peterwilsoncc.
 Fixes #55218.
 }}}

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