Changeset 26053 for trunk/tests/phpunit/tests/meta/query.php

Timestamp:

11/08/2013 10:51:03 PM (13 years ago)

Author:

wonderboymusic

Message:

Respect the compare operator value in meta_query when value evaluates to null. Adds Unit Test.

Props bradyvercher, gradyetc.
Fixes #22967.

File:

• trunk/tests/phpunit/tests/meta/query.php (modified) (1 diff)

trunk/tests/phpunit/tests/meta/query.php

@@ -106 +106 @@
 
         }
+
+        /**
+         * @ticket 22967
+         */ 
+        function test_null_value_sql() {
+                global $wpdb;
+
+                $query = new WP_Meta_Query( array(
+                        array( 'key' => 'abc', 'value' => null, 'compare' => '=' )
+                ) );
+                $sql = $query->get_sql( 'post', $wpdb->posts, 'ID', $this );
+
+                $this->assertEquals( 1, substr_count( $sql['where'], "CAST($wpdb->postmeta.meta_value AS CHAR) = '')" ) );
+        }
 }