[wp-trac] [WordPress Trac] #49364: dbDelta() should not change display width for integer data types on MySQL 8.0.17+

[WordPress Trac]

#49364: dbDelta() should not change display width for integer data types on MySQL
8.0.17+
----------------------------+---------------------
 Reporter:  SergeyBiryukov  |       Owner:  (none)
     Type:  defect (bug)    |      Status:  new
 Priority:  normal          |   Milestone:  5.9
Component:  Database        |     Version:
 Severity:  normal          |  Resolution:
 Keywords:  has-patch       |     Focuses:
----------------------------+---------------------
Changes (by pbearne):

 * keywords:  has-patch needs-testing has-unit-tests => has-patch


Comment:

 Hi All

 I dug into this and checked the testing

 It seems to me that we will have issues with current code/plugins still
 trying to use the old format
 So I added a regx_replace to fix the SQL on the fly

 Maybe we should look at adding a do_it_wrong notice but I didn't do that
 it would increase the overhead

 The new patch is in pull request #1781 and the combined  patch is in #1782

 I hope this helps

 Paul

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