Closed
Description
Always check against the Latest SNAPSHOT of JSQLParser and the Syntax Diagram
Failing SQL Feature:
- Encountered unexpected token: "or" "OR". Was expecting: "CONNECT"
- it parses well when the operator is in ParenthesedExpressionList, but can't when it directly in StartExpression.
- Oracle accept both. (with or without parentheses)
- [https://docs.oracle.com/cd/E11882_01/server.112/e41084/queries003.htm]
SQL Example:
- Simplified Query Example, focusing on the failing feature
select name from product where level > 1 start with 1 = 1 or 1 = 2 connect by nextversion = prior activeversion
Software Information:
- JSqlParser 5.1
- Oracle 19c
Metadata
Metadata
Assignees
Labels
No labels