[wp-trac] [WordPress Trac] #29062: WP_Meta_Query with NOT EXISTS fails during multiple conditions

[WordPress Trac]

#29062: WP_Meta_Query with NOT EXISTS fails during multiple conditions
--------------------------+---------------------------
 Reporter:  johnrom       |       Owner:  boonebgorges
     Type:  defect (bug)  |      Status:  closed
 Priority:  normal        |   Milestone:  4.1
Component:  Query         |     Version:  3.9.1
 Severity:  normal        |  Resolution:  fixed
 Keywords:                |     Focuses:
--------------------------+---------------------------
Changes (by boonebgorges):

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


Comment:

 In [changeset:"29890"]:
 {{{
 #!CommitTicketReference repository="" revision="29890"
 Use only LEFT JOINs when a meta_query contains a NOT EXISTS clause.

 Mixing LEFT and INNER JOIN in these cases results in posts with no
 metadata
 being improperly excluded from results.

 Props johnrom.
 Fixes #29062.
 }}}

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