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

Timestamp:

04/29/2013 09:02:38 AM (13 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'" ) );
+
+        }
 }