Changeset 60789 for trunk/src/wp-admin/includes/upgrade.php

Timestamp:

09/21/2025 03:50:56 PM (3 months ago)

Author:

SergeyBiryukov

Message:

Database: Do not unnecessarily alter table in dbDelta() for field type case differences.

This aims to avoid extra changes to database structure when type case is the only difference:

Changed type of wp_table.field from varchar(255) to VARCHAR(255)

Follow-up to [1575], [37532].

Props leewillis77, tristanleboss, lordspace, johnbillion, SergeyBiryukov.
Fixes #59481.

File:

• trunk/src/wp-admin/includes/upgrade.php (modified) (1 diff)

trunk/src/wp-admin/includes/upgrade.php

@@ -3204 +3204 @@
 
                 // Is actual field type different from the field type in query?
-                if ( $tablefield->Type !== $fieldtype ) {
+                if ( $tablefield->Type !== $fieldtype_lowercased ) {
                     $do_change = true;
                     if ( in_array( $fieldtype_lowercased, $text_fields, true ) && in_array( $tablefield_type_lowercased, $text_fields, true ) ) {