Changeset 33260 for branches/4.2/tests/phpunit/tests/db.php

Timestamp:

07/14/2015 10:20:55 AM (9 years ago)

Author:

pento

Message:

WPDB: When extracting the table name from a query, we had a 1000 character limit on the SQL string that would be searched. This was a hangover from when the code was imported from HyperDB, and isn't appropriate for Core, where a wider range of queries are likely to be run.

Merges [33259] to the 4.2 branch.

Fixes #32763

File:

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

branches/4.2/tests/phpunit/tests/db.php

@@ -534 +534 @@
             "SELECT * FROM `$table`",
 
+            "SELECT * FROM (SELECT * FROM $table) as subquery",
+
             "INSERT $table",
             "INSERT IGNORE $table",
@@ -628 +630 @@
             "SHOW CREATE TABLE $table",
             "SHOW INDEX FROM $table",
+
+            // @ticket 32763
+            "SELECT " . str_repeat( 'a', 10000 ) . " FROM (SELECT * FROM $table) as subquery",
         );