Changeset 41496 for trunk/tests/phpunit/tests/db.php

Timestamp:

09/19/2017 05:55:33 PM (9 years ago)

Author:

aaroncampbell

Message:

Database: Hardening to bring wpdb::prepare() inline with documentation.

wpdb::prepare() supports %s, %d, and %F as placeholders in the query string. Any other non-escaped % will be escaped.

File:

• trunk/tests/phpunit/tests/db.php (modified) (2 diffs)

trunk/tests/phpunit/tests/db.php

@@ -274 +274 @@
         }
 
+
         /**
          * Test that SQL modes are set correctly
@@ -1116 +1117 @@
                 $this->assertSame( 'utf8_general_ci', $result['collate'] );
         }
+
+        /**
+         *
+         */
+        function test_prepare_with_unescaped_percents() {
+                global $wpdb;
+
+                $sql = $wpdb->prepare( '%d %1$d %%% %', 1 );
+                $this->assertEquals( '1 %1$d %% %', $sql );
+        }
 }