Conflict between DISTINCT and ORDER BY

[ShaoxunLi]

Steps to reproduce the behavior (Required)

starrocks> select * from t;
+------+------+
| a    | b    |
+------+------+
|    4 | 4    |
|    5 | 1    |
|    1 | 1    |
|    3 | 3    |
|    2 | 2    |
+------+------+
5 rows in set (0.02 sec)

Real behavior (Required)

Setting sql_mode should make this SQL execute successfully, but it does not

starrocks> SELECT DISTINCT a from t order by b;
ERROR 1064 (HY000): Getting analyzing error at line 1, column 34. Detail message: '`test`.`t`.`b`' must be an aggregate expression or appear in GROUP BY clause.
starrocks> 
starrocks> set sql_mode = 0;
Query OK, 0 rows affected (0.00 sec)
starrocks> 
starrocks> SELECT DISTINCT a from t order by b;
ERROR 1064 (HY000): only found column statistics: {3: any_value}, but missing statistic of col: 1: a.

StarRocks version (Required)

3.1.10

[Baojia-Yang]

Keep an eye on this issue