Error should be thrown when there's ASC/DESC with GROUP BY clause

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. What did you do? If possible, provide a recipe for reproducing the error.

CREATE TABLE t1 (id INTEGER, sex CHAR(1));
SELECT sex, AVG(id), ROW_NUMBER() OVER w FROM t1
GROUP BY sex ASC
WINDOW w AS () ORDER BY sex DESC;

2. What did you expect to see?

Error ASC or DESC with GROUP BY isn't allowed with window functions; put ASC or DESC in ORDER BY is thrown.

3. What did you see instead?

Execute successfully with no warning.

4. What version of TiDB are you using (tidb-server -V or run select tidb_version(); on TiDB)?