Always check against the **Latest SNAPSHOT of JSQLParser** and the [Syntax Diagram](https://jsqlparser.github.io/JSqlParser/syntax_snapshot.html) ### Failing SQL Feature: - Parsing error on Oracle Hierarachy statement - Example: `CONNECT BY PRIOR` can't be parsed ### SQL Example: - This query ```SELECT dummy FROM dual CONNECT BY dummy LIKE PRIOR dummy || '.%' ``` raise parsing errror ```net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "like" "LIKE" at line 1, column 41. Was expecting one of: <EOF> <ST_SEMICOLON> ``` ### Software Information: - JSqlParser 5.1 - Oracle Databse 19c Stadard Edition Reference : https://docs.oracle.com/cd/B12037_01/server.101/b10759/queries003.htm
Always check against the Latest SNAPSHOT of JSQLParser and the Syntax Diagram
Failing SQL Feature:
CONNECT BY PRIORcan't be parsedSQL Example:
SELECT dummy FROM dual CONNECT BY dummy LIKE PRIOR dummy || '.%'raise parsing errror
Software Information:
Reference : https://docs.oracle.com/cd/B12037_01/server.101/b10759/queries003.htm