[wp-trac] [WordPress Trac] #39540: NOT EXISTS meta condition doesn't work if meta has NULL value.

[WordPress Trac]

#39540: NOT EXISTS meta condition doesn't work if meta has NULL value.
--------------------------+------------------
 Reporter:  avahura       |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  4.8
Component:  Query         |     Version:  4.7
 Severity:  normal        |  Resolution:
 Keywords:  needs-patch   |     Focuses:
--------------------------+------------------
Changes (by dd32):

 * keywords:   => needs-patch
 * milestone:  Awaiting Review => 4.8


Comment:

 This makes sense to me; `NOT EXISTS` shouldn't return rows which have
 literal `NULL`s as values, so testing if the ID column exists instead of
 the value column makes sense.

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