Repository navigation
parse error between with oracle outer join(+) #672
Description
Actual Behavior
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "BETWEEN" "BETWEEN"
at line 1, column 49.
Was expecting one of:
"."
";"
"AND"
"CONNECT"
"EXCEPT"
"FOR"
"GROUP"
"HAVING"
"INTERSECT"
"MINUS"
"ORDER"
"START"
"UNION"
<EOF>
at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:18047)
Steps to Reproduce the Problem
String sql = "SELECT * FROM table1 t1,table2 t2 WHERE t1.col1 BETWEEN t2.col2(+) AND t2.col3(+)";
JSqlParser jSqlParser = new CCJSqlParserManager();
try {
jSqlParser.parse(new StringReader(sql));
} catch (JSQLParserException e) {
e.printStackTrace();
}
Specifications
- Version: 1.2
- Platform: JDK 1.7
- Subsystem:
Activity
wumpz commentedon Sep 8, 2018
That is right. JSqlParser does not support this old join syntax in this between construct.
fudianchn commentedon Sep 8, 2026
AI disclosure: this comment was prepared with AI coding agents, reviewed and revised line by line by me.
Root cause: the grammar consumes the Oracle
(+)postfix at three sites (after the condition left operand inCondition(), after the comparison right-hand side inRegularConditionRHS(), and inPrimaryExpression()only before,or)for IN lists), but theBETWEENstart and end operands reach none of them, soBETWEEN t2.col2(+)fails on the(token.Fix proposed in #2564: consume
(+)after bothBETWEENoperands (same blockCondition()already uses), marking the operandColumnvia the existingSupportsOldOracleJoinSyntaxinterface, no AST change. All operand forms covered: both-marked, single-sided,NOT BETWEEN,SYMMETRIC, parenthesized conditions, joinONclauses.fix(parser): parse Oracle outer join operator (+) on BETWEEN operands (…
fix(parser): parse Oracle outer join operator (+) on BETWEEN operands (…
fix(parser): parse Oracle outer join operator (+) on BETWEEN operands (…