3 ms·
It only allows that if you’ve set it to do so. The default SQL_MODE variable includes ONLY_FULL_GROUP_BY. However, in their brilliance, AWS RDS defaults to onl
by sgarland 3y ago
It only allows that if you’ve set it to do so. The default SQL_MODE variable includes ONLY_FULL_GROUP_BY.
However, in their brilliance, AWS RDS defaults to only NO_ENGINE_SUBSTITUTION for SQL_MODE, thus merrily allowing partial aggregates with non-deterministic results. Wheee!
https://github.com/awsdocs/amazon-rds-user-guide/issues/160 https://github.com/awsdocs/amazon-rds-user-guide/issues/160
- paulddraper 3y agoPrior to 5.7, MySQL always accepted non-aggregated fields. Version 5.7 introduced ONLY_FULL_GROUP_BY, but since that change broke lots of code that depended on this historical behavior, many people disabled it.