Changeset 30846 for trunk/src/wp-includes/meta.php

Timestamp:

12/14/2014 07:00:31 PM (12 years ago)

Author:

boonebgorges

Message:

In WP_Meta_Query, interpret 'value' correctly when used with EXISTS/NOT EXISTS.

As in earlier versions, EXISTS with a value is equivalent to '=', while NOT
EXISTS should always ignore 'value'.

Props barrykooij.
Fixes #30681 for trunk.

File:

• trunk/src/wp-includes/meta.php (modified) (1 diff)

trunk/src/wp-includes/meta.php

@@ -1420 +1420 @@
                                         break;
 
+                                // EXISTS with a value is interpreted as '='.
+                                case 'EXISTS' :
+                                        $meta_compare = '=';
+                                        $where = $wpdb->prepare( '%s', $meta_value );
+                                        break;
+
+                                // 'value' is ignored for NOT EXISTS.
+                                case 'NOT EXISTS' :
+                                        $where = '';
+                                        break;
+
                                 default :
                                         $where = $wpdb->prepare( '%s', $meta_value );