[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:  Awaiting Review
Component:  Query         |     Version:  4.7
 Severity:  normal        |  Resolution:
 Keywords:                |     Focuses:
--------------------------+------------------------------
Changes (by dd32):

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


Comment:

 My apologies, I misread your initial post.

 I disagree that `NULL` should be matched by `NOT EXISTS`, as the row does
 exist, it just has a null value.

 It doesn't look like we have a good way in meta queries to handle `NULL`
 at present though.

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