[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:
--------------------------+------------------

Comment (by avahura):

 Basically i agree with you, but how to check NULL meta value with usage of
 WP query builder then? This should be easy. NOT EXISTS could mean meta
 (row) not exists or meta value not exists, but you use "compare" for
 values check ( "=", ">", "IN" and etc. ) and NOT EXISTS uses in "compare"
 as well. We just use it in different contexts.
  Also you can prevent NULL writing as meta value and just remove such meta
 or even add "NULL" as meta_value and parse it accordingly.

  Probably i don't right.

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