You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/09/26 15:47:13 UTC
[GitHub] [shardingsphere] RaigorJiang opened a new issue, #21209: Oracle Hierarchical Queries cannot be parsed properly.
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-unsubscribe@shardingsphere.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu commented on issue #21209: Oracle Hierarchical Queries cannot be parsed properly.
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #21209:
URL: https://github.com/apache/shardingsphere/issues/21209#issuecomment-1258813445
@chakkk309 Do you want to solve this issue?
--
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-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] chakkk309 commented on issue #21209: Oracle Hierarchical Queries cannot be parsed properly.
Posted by GitBox <gi...@apache.org>.
chakkk309 commented on issue #21209:
URL: https://github.com/apache/shardingsphere/issues/21209#issuecomment-1258837782
> @chakkk309 Do you want to solve this issue?
Sure, I will check it. Please assign it to 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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Oracle Hierarchical Queries cannot be parsed properly. [shardingsphere]
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang closed issue #21209: Oracle Hierarchical Queries cannot be parsed properly.
URL: https://github.com/apache/shardingsphere/issues/21209
--
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-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Oracle Hierarchical Queries cannot be parsed properly. [shardingsphere]
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #21209:
URL: https://github.com/apache/shardingsphere/issues/21209#issuecomment-1994066528
The above SQLs is now supported
--
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-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org