[wp-trac] [WordPress Trac] #29062: WP_Meta_Query with NOT EXISTS fails during multiple conditions (was: WP_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:  reviewing
 Priority:  normal                        |   Milestone:  Future Release
Component:  Query                         |     Version:  3.9.1
 Severity:  normal                        |  Resolution:
 Keywords:  needs-patch needs-unit-tests  |     Focuses:
------------------------------------------+-----------------------------
Changes (by boonebgorges):

 * keywords:   => needs-patch needs-unit-tests
 * owner:   => boonebgorges
 * status:  new => reviewing
 * milestone:  Awaiting Review => Future Release


Comment:

 >  I think whenever a NOT EXISTS statement exists, all joins should be
 LEFT

 I think this is probably right. Somewhat related: #29447.

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