xpdo
xpdo copied to clipboard
[Feature request] groupby to automatically add attribute in select
If strict mode is turned on in mysql/mariadb you can not do group by without also having that attribute in the selects.
There's been many issues reported on this. Although it is a flaw in their SQL queries, the ORM wrapper could be to nice that it fixes this for them.
modxcms/revolution#13287
I have talked with @opengeek about this and autocreating select clauses should be a BC. Maybe he could tell more here.