[DiscordArchive] <@109652764488892416> do you know which sql files / queries create an issue with "ONLY_FULL_GROUP_BY
[DiscordArchive] <@109652764488892416> do you know which sql files / queries create an issue with "ONLY_FULL_GROUP_BY
Original source
MySQL 5.7.5 and up implements detection of functional dependence. If the ONLY_FULL_GROUP_BY SQL mode is enabled (which it is by default), MySQL rejects queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are neither named in the GROUP BY clause nor are functionally dependent on them. (Before 5.7.5, MySQL does not detect functional dependency and ONLY_FULL_GROUP_BY is not enabled by default.
rektbyfaith
01-28-2019, 05:40 PM #11Archived author: Barbz • Posted: 2019-01-28T17:40:38.750000+00:00
Original source
MySQL 5.7.5 and up implements detection of functional dependence. If the ONLY_FULL_GROUP_BY SQL mode is enabled (which it is by default), MySQL rejects queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are neither named in the GROUP BY clause nor are functionally dependent on them. (Before 5.7.5, MySQL does not detect functional dependency and ONLY_FULL_GROUP_BY is not enabled by default.
1 Guest(s)
1 Guest(s)