ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘xxx.sxxx_.id‘ which is
异常信息
2022-1-6 09:05:28 [http-nio-8092-exec-8] WARN [SqlExceptionHelper]:137 SQL Error: 1055, SQLState: 42000
2022-1-6 09:05:28 [http-nio-8092-exec-8] ERROR [SqlExceptionHelper]:142 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘xxx.sxxx_.id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
重点
ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘xxx.sxxx_.id’ which is not functionally dependent on columns in GROUP BY clause
意思就是order by后面的参数必须出现在结果的字段中。假如要order by id，那么就要select id出来才可以。