[GitHub] [shardingsphere] RaigorJiang opened a new issue, #21209: Oracle Hierarchical Queries cannot be parsed properly.

[GitBox]

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

   ## Bug Report
   
   ### Which version of ShardingSphere did you use?
   master 3b269505a4bd1b6b354aee28fe9a001d628309be
   
   ### Expected behavior
   SQL is parsed correctly.
   
   ### Description
   #### Doc of Oracle Hierarchical Queries
   
https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/Hierarchical-Queries.html#GUID-0118DF1D-B9A9-41EB-8556-C6E7D6A5A84E
   
   #### The parsing result of the following statement is incomplete
   - Example 1
   ```sql
   SELECT employee_id, last_name, manager_id
      FROM employees
      CONNECT BY PRIOR employee_id = manager_id;
   ```
   parse result:
   <img width="572" alt="image" 
src="https://user-images.githubusercontent.com/5668787/192320656-947f87a4-631e-4105-b3a2-a871b1492864.png";>
   
   
   - Example 2
   ```sql
   SELECT parent_entity,child_entity
   FROM entities
   START WITH child_entity =’abet’
   CONNECT BY child_entity= PRIOR parent_entity
   ```
   parse result:
   <img width="672" alt="image" 
src="https://user-images.githubusercontent.com/5668787/192321122-91a08fe8-010e-45df-92fc-68f9824a99c5.png";>
   
   - Example 3
   ```sql
   select column_name FROM department de 
   START WITH de.id in (1,2) CONNECT BY PRIOR de.sys_id = de.PARENT_ID
   ```
   parse result:
   <img width="445" alt="image" 
src="https://user-images.githubusercontent.com/5668787/192321488-e97f4001-33ed-4d39-845e-fd7a4371ed1e.png";>
   
   


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