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

Timestamp:

09/19/2017 05:55:33 PM (7 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 );
+    }
 }