mysql sql查询拼上group by问题

报错日志：
#Error querying database. Cause: java.sql.SQLSyntaxErrorException: Expression #57 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘gbw.gs.ID’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

发现是：是数据库的sql_mode出了问题。
SQL模式默认情况下是only_full_group_by ，MySQL就会拒绝选择列表、条件或顺序列表引用的查询，这些查询将引用组中未命名的非聚合列，而不是在功能上依赖于它们。

SHOW SESSION VARIABLES;
SHOW GLOBAL VARIABLES;
select @@sql_mode;

可见：session和global 的sql_mode的值都为：

ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

解决方案：

set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

set session sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

重启服务