Changeset 1276 in tests for trunk/tests/meta/query.php

Timestamp:

04/29/2013 09:02:38 AM (11 years ago)

Author:

westi

Message:

Meta Queries: Add a test case to validate that when generating the meta query SQL for an empty value array we don't generate invalid SQL.

See #22096

File:

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

trunk/tests/meta/query.php

@@ -80 +80 @@
         $this->assertEquals( array( array( 'key' => 'abc', 'compare' => '=>' ) ), $query->queries );
     }
+
+    /*
+     * @ticket 22096
+     */
+    function test_empty_value_sql() {
+        global $wpdb;
+
+        $query = new WP_Meta_Query();
+
+        $the_complex_query['meta_query'] = array(
+            array( 'key' => 'my_first_key', 'value' => 'my_amazing_value' ),
+            array( 'key' => 'my_second_key', 'compare' => 'NOT EXISTS' ),
+            array( 'key' => 'my_third_key', 'value' => array( ), 'compare' => 'IN' ),
+        );
+
+        $query->parse_query_vars( $the_complex_query );
+
+        $sql = $query->get_sql( 'post', $wpdb->posts, 'ID', $this );
+
+        // We should have 2 joins - one for my_first_key and one for my_second_key
+        $this->assertEquals( 2, substr_count( $sql['join'], 'INNER JOIN' ) );
+
+        // The WHERE should check my_third_key against an unaliased table
+        $this->assertEquals( 1, substr_count( $sql['where'], "wp_postmeta.meta_key = 'my_third_key'" ) );
+
+    }
 }