\MySQL57Database
This is intended to _fix_ problem `Expression #1 of ORDER BY clause is not in SELECT list.....which is not in SELECT list; this is incompatible with DISTINCT` caused by some modules.
The distinct _error_ occures with MySQL >5.7.5 where the option __ONLY_FULL_GROUP_BY__ became part of the combination on __ANSI__
(which also includes 'REAL_AS_FLOAT, PIPES_AS_CONCAT, ANSI_QUOTES, IGNORE_SPACE') used by SilverStripe for sql_mode.
See also https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sql-mode-combo
Synopsis
Hierarchy
Extends
- MySQLDatabase