[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:  6.0
Component:  Database        |     Version:
 Severity:  normal          |  Resolution:
 Keywords:  has-patch       |     Focuses:
----------------------------+---------------------

Comment (by JavierCasares):

 I'm having this problems with MariaDB 10.5.

 https://make.wordpress.org/hosting/test-results/r52797/wpsabot-r52797/

 I think this may be related with

 {{{
 @@SQL_MODE:
 STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
 }}}

 Mainly: STRICT_TRANS_TABLES. MariaDB 10.2.4+ has the STRICT_TRANS_TABLES
 by default...

 https://mariadb.com/kb/en/sql-mode/#strict_trans_tables

 Strict mode. Statements with invalid or missing data are aborted and
 rolled back, except that for non-transactional storage engines and
 statements affecting multiple rows where the invalid or missing data is
 not the first row, MariaDB will convert the invalid value to the closest
 valid value, or, if a value is missing, insert the column default value.
 Default since MariaDB 10.2.4.

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