[wp-trac] [WordPress Trac] #8857: Make WP MySQL strict mode compliant

WordPress Trac noreply at wordpress.org
Wed Apr 16 14:18:05 UTC 2014


#8857: Make WP MySQL strict mode compliant
-------------------------+----------------------
 Reporter:  ghostks      |       Owner:
     Type:  enhancement  |      Status:  closed
 Priority:  lowest       |   Milestone:
Component:  Database     |     Version:  2.7
 Severity:  minor        |  Resolution:  wontfix
 Keywords:               |     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/8857#comment:13>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform


More information about the wp-trac mailing list