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

Timestamp:

09/19/2019 03:02:20 PM (7 years ago)

Author:

boonebgorges

Message:

Query: Expand the list of operators available to compare_key in WP_Meta_Query.

compare_key, introduced in #42409, previously supported only = and LIKE
operators. This changeset introduces a number of other operators: !=, IN,
NOT IN, NOT LIKE, RLIKE, REGEXP, NOT REGEXP, EXISTS, and NOT EXISTS
(the latter two aliased to = and !=, respectively). To support case-sensitive
regular expression key comparisons, the new type_key parameter will force
a MySQL CAST when 'BINARY' is passed.

Props soulseekah.
Fixes #43346.

File:

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

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

@@ -739 +739 @@
 
         /**
+         * Verifies only that meta_type_key is passed. See query/metaQuery.php for more complete tests.
+         *
+         * @ticket 43446
+         */
+        public function test_meta_type_key_should_be_passed_to_meta_query() {
+                $posts = self::factory()->post->create_many( 3 );
+
+                add_post_meta( $posts[0], 'AAA_FOO_AAA', 'abc' );
+                add_post_meta( $posts[1], 'aaa_bar_aaa', 'abc' );
+                add_post_meta( $posts[2], 'aaa_foo_bbb', 'abc' );
+                add_post_meta( $posts[2], 'aaa_foo_aaa', 'abc' );
+
+                $q = new WP_Query(
+                        array(
+                                'meta_key'         => 'AAA_foo_.*',
+                                'meta_compare_key' => 'REGEXP',
+                                'fields'           => 'ids',
+                        )
+                );
+
+                $this->assertEqualSets( array( $posts[0], $posts[2] ), $q->posts );
+
+                $q = new WP_Query(
+                        array(
+                                'meta_key'         => 'AAA_FOO_.*',
+                                'meta_compare_key' => 'REGEXP',
+                                'meta_type_key'    => 'BINARY',
+                                'fields'           => 'ids',
+                                'fields'           => 'ids',
+                        )
+                );
+
+                $this->assertEqualSets( array( $posts[0] ), $q->posts );
+        }
+
+        /**
          * This is the clause that ensures that empty arrays are not valid queries.
          */