net.sf.jsqlparser.JSQLParserException: Encountered unexpected token: "desc" "DESC"

[zhaochengbei]

Describe the bug parser error.

To Reproduce Steps to reproduce the behavior:

1. Example SQL : select a from b group by c desc;
2. Parsing this SQL using JSqlParser with this statements
3. Exception : JSQLParserException

Expected behavior parser success.

System

• mysql 5.7
• Java 1.8
• JSqlParser 4.0

[wumpz]

I have never seen such a construct. Is group by c desc a shortcut for group by c order by c desc?

[zhaochengbei]

This is an old way of writing. This SQL can be run on MySQL.