[MySQL8] groupby sort issue

[Jako]

The following code does not work anymore with MySQL 8:

$c->groupby($this->classKey . '.key', 'ASC');

According to @digitalpenguin it has to be reduced to:

$c->groupby($this->classKey . '.key');

[muzzwood]

Here's some info about it:
https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html#upgrade-sql-changes

It now needs to be done with an ORDER BY clause.

[Jako]

Yes, but xPDO has to handle this or throw/log some deprecated message.