- 🇵🇱Poland azovsky
Please note that on MySQL ONLY_FULL_GROUP_BY SQL mode is enabled by default, but on MariaDB is disabled by default.
I am try to add GROUP BY and MAX aggregation function with multiple joins in PDO query but drupal core side getting sql_mode=only_full_group_by error issue with multiple fields group by.
Error:
"GROUP BY clause and contains nonaggregated column 'dbname.field_name' which is not functionally dependent on columns in GROUP BY clause. this is incompatible with sql_mode=only_full_group_by issue."
Closed: works as designed
10.0 ✨
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
Please note that on MySQL ONLY_FULL_GROUP_BY SQL mode is enabled by default, but on MariaDB is disabled by default.