this is incompatible with sql_mode=only_full_group_by

mysql 遷移到5.7後業務日志中出現：

this is incompatible with sql_mode=only_full_group_by

解決方法：

1. https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-functions.html

2. sql mode 設定為空。