Changeset 38591 for trunk/tests/phpunit/tests/dbdelta.php

Timestamp:

09/12/2016 05:08:17 AM (9 years ago)

Author:

pento

Message:

Database: Normalise index names in dbDelta().

When comparing index definitions, normalise the index names to lower case, as they are not case sensitive within MySQL.

Fixes #34874.

File:

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

trunk/tests/phpunit/tests/dbdelta.php

@@ -804 +804 @@
 
     /**
+     * @ticket 34874
+     */
+    function test_key_names_are_not_case_sensitive_and_do_not_recreate_indices() {
+        global $wpdb;
+
+        $updates = dbDelta(
+            "
+            CREATE TABLE {$wpdb->prefix}dbdelta_test (
+                id bigint(20) NOT NULL AUTO_INCREMENT,
+                column_1 varchar(255) NOT NULL,
+                column_2 text,
+                column_3 blob,
+                PRIMARY KEY  (id),
+                KEY KEY_1 (column_1),
+                KEY compOUND_key (id,column_1),
+                FULLTEXT KEY FULLtext_kEY (column_1)
+            ) ENGINE=MyISAM
+            ", false );
+
+        $this->assertEmpty( $updates );
+    }
+
+    /**
      * @ticket 31679
      */