TherChenYang commented on PR #29230:
URL: https://github.com/apache/shardingsphere/pull/29230#issuecomment-1853360923

   > I've encountered an issue during testing where I consistently receive the 
following error:
   > 
   > ```
   >   org.apache.shardingsphere.sql.parser.exception.SQLParsingException: You 
have an error in your SQL syntax: SELECT Test1Col = x FROM #t, no viable 
alternative at input '<EOF>' at line 1, position 27, near 
[@6,27:26='<EOF>',<-1>,1:27]
   > ```
   > 
   > Could someone provide a hint or suggestions on what might be causing this 
issue? I think parser doesn't get it what is `'#'`, but I have tried add '#' to 
IDENTIFIER_ to tableName.
   
   I ran into the same problem that this sql can be parsed in the antlr plugin 
but will get an error when parsed using a Parser
   
![image](https://github.com/apache/shardingsphere/assets/124348939/b881008c-199a-4d5c-b298-df3e8f58e1ea)
   
![image](https://github.com/apache/shardingsphere/assets/124348939/250c3552-7fdd-414a-9670-0300ff05e148)
   


-- 
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]

Reply via email to