java.sql.SQLSyntaxErrorException: Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'environment.t1.so2' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
原因：mysql8.0的sql_mode 开启了only_full_group_by模式
解决方法 在mysql配置文件中关闭only_full_group_by模式
参考链接：一文带你了解mysql sql model的only_full_group_by模式
标签：full,group,incompatible,only,mode,sql From： https://www.cnblogs.com/skmoran/p/16717078.html