Expression #1 of ORDER BY clause is not in SELECT list, references column 'xxxx' which is not in SELECT list; this is incompatible with DISTINCT

select DISTINCT(left(created_on, 10)) createDate from record where plan_id = '123456789' order by created_on desc; 
报错信息：
Expression #1 of ORDER BY clause is not in SELECT list, 
references column 'xxxx' which is not in SELECT list; 
this is incompatible with DISTINCT

问题原因：

mysql5.7.5及以上版本将sql_mode的ONLY_FULL_GROUP_BY模式默认设置为打开状态，会导致一些错误：

1、我们使用GROUP BY查询时，出现在SELECT字段后面的只能是GROUP
BY后面的分组字段，或使用聚合函数包裹着的字段，否则会报错如下信息： 　　Expression #1 of SELECT list is
not in GROUP BY clause and contains nonaggregated column
‘xxx’ which is not functionally dependent on columns
in GROUP BY clause; this is incompatible with
sql_mode=only_full_group_by
详见：https://www.cnblogs.com/wongzzh/p/15303934.html
2、当使用ORDER BY查询时，不能使用SELECT
DISTINCT去重查询。否则会报错如下信息： Expression #1 of ORDER BY clause is not in
SELECT list, references column ‘xxx’ which is not in
SELECT list; this is incompatible with DISTINCT

解决办法：

select DISTINCT(left(created_on, 10)) createDate from record where plan_id = '123456789' ;