[wp-trac] [WordPress Trac] #36343: Taxonomy query matching specified term or NOT EXISTS does not return expected result

[WordPress Trac]

#36343: Taxonomy query matching specified term or NOT EXISTS does not return
expected result
--------------------------------------+---------------------------
 Reporter:  crstauf                   |       Owner:  boonebgorges
     Type:  defect (bug)              |      Status:  closed
 Priority:  normal                    |   Milestone:  4.6
Component:  Query                     |     Version:  4.1
 Severity:  normal                    |  Resolution:  fixed
 Keywords:  has-patch has-unit-tests  |     Focuses:
--------------------------------------+---------------------------
Changes (by boonebgorges):

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


Comment:

 In [changeset:"37184"]:
 {{{
 #!CommitTicketReference repository="" revision="37184"
 Use `LEFT JOIN` when building `WP_Tax_Query` SQL.

 `LEFT JOIN` ensures that `NOT EXISTS` queries will not miss posts that
 have
 no taxonomy data whatsoever.

 Props swissspidy, crstauf.
 Fixes #36343.
 }}}

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