Changeset 41497 for branches/4.8/tests/phpunit/tests/db.php

Timestamp:

09/19/2017 06:10:58 PM (8 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.

Merges [41496] to 4.8 branch.

Location:

branches/4.8

Files:

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

branches/4.8/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 );
+    }
 }