[wp-trac] [WordPress Trac] #59481: dbDelta do useless request when type case is not the same between query and describe result

[WordPress Trac]

#59481: dbDelta do useless request when type case is not the same between query and
describe result
--------------------------------------+--------------------------
 Reporter:  tristanleboss             |       Owner:  johnbillion
     Type:  defect (bug)              |      Status:  closed
 Priority:  normal                    |   Milestone:  6.9
Component:  Database                  |     Version:  6.3
 Severity:  normal                    |  Resolution:  fixed
 Keywords:  has-patch has-unit-tests  |     Focuses:
--------------------------------------+--------------------------
Changes (by SergeyBiryukov):

 * status:  reviewing => closed
 * resolution:   => fixed


Comment:

 In [changeset:"60789" 60789]:
 {{{
 #!CommitTicketReference repository="" revision="60789"
 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.
 }}}

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/59481#comment:10>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform