[wp-trac] [WordPress Trac] #48377: sql_mode ANSI is incompatible with WP in MySQL 5.7.5+

[WordPress Trac]

#48377: sql_mode ANSI is incompatible with WP in MySQL 5.7.5+
--------------------------+-----------------------------
 Reporter:  jnylen0       |       Owner:  SergeyBiryukov
     Type:  defect (bug)  |      Status:  closed
 Priority:  normal        |   Milestone:  5.4
Component:  Database      |     Version:
 Severity:  normal        |  Resolution:  fixed
 Keywords:                |     Focuses:
--------------------------+-----------------------------
Changes (by SergeyBiryukov):

 * owner:  (none) => SergeyBiryukov
 * status:  new => closed
 * resolution:   => fixed


Comment:

 In [changeset:"47171" 47171]:
 {{{
 #!CommitTicketReference repository="" revision="47171"
 Database: Add `ANSI` to the list of incompatible SQL modes.

 Starting with MySQL 5.7.5, the `ANSI` mode implies `ONLY_FULL_GROUP_BY`,
 which is already listed in `wpdb` as incompatible per [27072].

 When `ANSI` is enabled on MySQL 5.7.5+, `ONLY_FULL_GROUP_BY` remains
 enabled even after being "unset" by `wpdb::set_sql_mode()`.

 To prevent this, the `ANSI` mode should also be listed as incompatible. It
 is not enabled on default MySQL installations.

 Props jnylen0.
 Fixes #48377.
 }}}

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