zgq7 commented on issue #14224:
URL:
https://github.com/apache/shardingsphere/issues/14224#issuecomment-1000022258
@tuichenchuxin
```java
@Test
public void build5() {
SQLParserExecutor sqlParserExecutor = new SQLParserExecutor("MySQL",
false);
try {
sqlParserExecutor.parse("select a.rank from table_name a");
log.info("sharding jdbc sql 编译成功");
} catch (Exception e) {
log.error("sharding jdbc sql 编译报错：", e);
}
}
```
it alse occure a error，because there has a column which name is rank ...
```text
11:38:44.972 [main] ERROR - sharding jdbc sql 编译报错：
org.apache.shardingsphere.sql.parser.exception.SQLParsingException: You have
an error in your SQL syntax
at
org.apache.shardingsphere.sql.parser.core.database.parser.SQLParserExecutor.twoPhaseParse(SQLParserExecutor.java:68)
at
org.apache.shardingsphere.sql.parser.core.database.parser.SQLParserExecutor.parse(SQLParserExecutor.java:49)
```
if the column name is ranke，the case will pass 。:bug::bug::bug:
maybe these are still many sql parse problems in my project ，do you have
good advice for me ?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
