在sql加入注释符号，解析error

[542928492]

Describe the bug
加入一些sql与注释相关的内容不能运行解析，比如符号 #

To Reproduce
Steps to reproduce the behavior:

1. Example SQL （this sql navicate can run success，JSqlParser can‘not parser）

String sql = " select * from t_aim_sys_user where id = '11' #limit 3";

2. Parsing this SQL using JSqlParser with this statements

Statement statement = CCJSqlParserUtil.parse(sql);

3. Exception
   Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "#limit" <S_IDENTIFIER>

Expected behavior
A clear and concise description of what you expected to happen.

System

• Database you are using
  mysql 5.6
• Java Version
  1.8
• JSqlParser version
  3.1

[542928492]

Or is there any way to get the real execution SQL

[wumpz]

Please use English.

[wumpz]

Are you positive that your SQL is correct? I only know this limit clause without this #. Jsqlparser supports this.

[jibiyr]

@542928492 because your sql is illegal

[manticore-projects]

Let me have a guess here:

select * from t_aim_sys_user where id = '11' --limit 3

But instead the # is used for commenting which seems to be valid in MySQL (only).
Although this collides with other RDBMS where #myColumn is a valid Column name.

Please feedback or we would close this issue.