Laravel 9 only_full_group_by

[stephenjason89]

"nuwave/lighthouse": "^v5.48.2",

on laravel 8 everything works as expected

However on laravel 9 it throws me errors

any help is deeply appreciated

[spawnia]

It appears that upgrading to Laravel 9 changed the setting of the SQL mode ONLY_FULL_GROUP_BY.

While the example query where you only select the field tag makes sense, consider that a query that includes additional fields not present in the aggregate will lead to nonsensical results, e.g. requesting field id. Generally, GROUP BY change the shape/semantics of the SQL result and should only be used in dedicated fields, not mixed with general purpose fields.

[stephenjason89]

Hello @spawnia ,
I have the 2 projects running
1 is using laravel 8
1 is using laravel 9

They both use the same mysql db and settings
However they yield different results.
Laravel 9 throws an error where it clearly should not.

I understand the use of ONLY_FULL_GROUP_BY and would like to keep on using it.
On my query only tag is selected and no other fields which can't be used like id

[spawnia]

The resulting SQL statement will have SELECT *.

The design problem is that the API allows misuse, you could query ID when using groupByModel, which would be nonsensical. You can avoid this misuse by just having a separate field that queries the group by.

You can use the following channels to ask support questions:

• Use the laravel-lighthouse tag on Stackoverflow
• Hop into Slack

[stephenjason89]

@spawnia Thank you for the clarification.