mysql sql_mode的问题

[z8323664]

提示：

1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cobubrazor.d.date_sk' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by, Time: 0.014000s

mysql> show variables like "%sql_mode%";
+---------------+------------------------------------------------------------------------------------------------------------------------+
| Variable_name | Value                                                                                                                  |
+---------------+------------------------------------------------------------------------------------------------------------------------+
| sql_mode      | STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
+---------------+------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.01 sec)
 
mysql> 

这是为啥？第一个是存储过程， 难道没用吗？

[z8323664]

mysql版本是5.7.23， 为什么都没有only_full_group_by却还提示呢

[ACMAIN_CHM]

[z8323664]

问题已经解决， 来个接分的