[GitHub] [shardingsphere] strongduanmu opened a new issue, #26816: SQLParsingException occurs when select statement contains level and START WITH ... CONNECT BY

[via GitHub]

strongduanmu opened a new issue, #26816:
URL: https://github.com/apache/shardingsphere/issues/26816

   ## Bug Report
   
   ### Which version of ShardingSphere did you use?
   
   
[112ed6f](https://github.com/apache/shardingsphere/commit/112ed6f8a652b3b408c248375840a2ff321f56dd)
   
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   
   ShardingSphere-JDBC
   
   ### Expected behavior
   
   Parse following sql successfully.
   
   ```sql
   select * from (
                           SELECT level, ORG.* FROM SYS_ORG ORG
                           WHERE org.rgn_div_cd is not null and org.is_del=0
   
                           START WITH ORG.ID = ? CONNECT BY PRIOR ORG_PID = ID  
   order by level
                   ) a     where rownum = 1
   ```
   
   ### Actual behavior
   
   ```
   org.apache.shardingsphere.sql.parser.exception.SQLParsingException: You have 
an error in your SQL syntax: select * from (
      SELECT level, ORG.* FROM SYS_ORG ORG
      WHERE org.rgn_div_cd is not null and org.is_del=0
       
      START WITH ORG.ID = ? CONNECT BY PRIOR ORG_PID = ID order by level
     ) a where rownum = 1, no viable alternative at input 
'select*from(SELECTlevel' at line 2, position 10, near 
[@5,26:30='level',<518>,2:10],monitor=login_exception,org.mybatis.spring.MyBatisSystemException:
 nested exception is org.apache.ibatis.executor.ExecutorException: Error 
preparing statement.  Cause: 
org.apache.shardingsphere.sql.parser.exception.SQLParsingException: You have an 
error in your SQL syntax: select * from (
      SELECT level, ORG.* FROM SYS_ORG ORG
      WHERE org.rgn_div_cd is not null and org.is_del=0
       
      START WITH ORG.ID = ? CONNECT BY PRIOR ORG_PID = ID order by level
     ) a where rownum = 1, no viable alternative at input 
'select*from(SELECTlevel' at line 2, position 10, near 
[@5,26:30='level',<518>,2:10]
   ```
   
   ### Reason analyze (If you can)
   
   ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule 
configuration, when exception occur etc.
   
   ### Example codes for reproduce this issue (such as a github link).
   


-- 
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: 
notifications-unsubscr...@shardingsphere.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org