[wp-trac] [WordPress Trac] #26847: MySQL 5.6 default install can break WordPress

[WordPress Trac]

#26847: MySQL 5.6 default install can break WordPress
------------------------------+---------------------
 Reporter:  pento             |       Owner:  nacin
     Type:  defect (bug)      |      Status:  closed
 Priority:  normal            |   Milestone:  3.9
Component:  Database          |     Version:  2.7
 Severity:  normal            |  Resolution:  fixed
 Keywords:  has-patch commit  |     Focuses:
------------------------------+---------------------

Comment (by felixq):

 Changelog MySQL 5.6.17:

 Incompatible Change: The deprecated ERROR_FOR_DIVISION_BY_ZERO,
 NO_ZERO_DATE, and NO_ZERO_IN_DATE SQL modes now do nothing. Instead, their
 previous effects are included in the effects of strict SQL mode
 (STRICT_ALL_TABLES or STRICT_TRANS_TABLES). In other words, strict mode
 now means the same thing as the previous meaning of strict mode plus the
 ERROR_FOR_DIVISION_BY_ZERO, NO_ZERO_DATE, and NO_ZERO_IN_DATE modes. This
 change reduces the number of SQL modes with an effect dependent on strict
 mode and makes them part of strict mode itself.

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