Changeset 38044

Timestamp:

07/13/2016 11:38:29 AM (10 years ago)

Author:

ocean90

Message:

Database: Add unit test to test that a column type change for a table name with a hyphen is working after [37583].

Fixes #31679.

File:

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

trunk/tests/phpunit/tests/dbdelta.php

@@ -802 +802 @@
                 $this->assertEmpty( $updates );
         }
+
+        /**
+         * @ticket 31679
+         */
+        function test_column_type_change_with_hyphens_in_name() {
+                global $wpdb;
+
+                $schema = "
+                        CREATE TABLE {$wpdb->prefix}dbdelta_test2 (
+                                `foo-bar` varchar(255) DEFAULT NULL
+                        )
+                ";
+
+                $wpdb->query( $schema );
+
+                $schema_update = "
+                        CREATE TABLE {$wpdb->prefix}dbdelta_test2 (
+                                `foo-bar` text DEFAULT NULL
+                        )
+                ";
+
+                $updates = dbDelta( $schema_update );
+
+                $wpdb->query( "DROP TABLE IF EXISTS {$wpdb->prefix}dbdelta_test2" );
+
+                $this->assertSame(
+                        array(
+                                "{$wpdb->prefix}dbdelta_test2.foo-bar" => "Changed type of {$wpdb->prefix}dbdelta_test2.foo-bar from varchar(255) to text",
+                        ),
+                        $updates
+                );
+        }
 }