ORDER BY Mapping to error column

[Max-Cheng]

Steps to reproduce the behavior (Required)

set sql_dialect = 'trino';
SELECT Count(a) a
FROM   (SELECT 1 a)
ORDER  BY a; 

Expected behavior (Required)

trino:root> SELECT Count(a) a
         -> FROM   (SELECT 1 a)
         -> ORDER  BY a;
 a
---
 1
(1 row)

Real behavior (Required)

ERROR 1064 (HY000): Getting analyzing error. Detail message: 'a' must be an aggregate expression or appear in GROUP BY clause.

StarRocks version (Required)

branch-3.2.9