parse error between with oracle outer join(+)

[realizm]

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:

[wumpz]

That is right. JSqlParser does not support this old join syntax in this between construct.