Skip to content

[BUG] [5.1] : MySql : JOIN FETCH Failing to parse #2229

Open
@michari

Description

@michari

Failing To Parse SQL

  • Join Fetch query is failing to parse
  • Example: JOIN FETCH can't be parsed

SQL Example:

  • Simplified Query Example, focusing on the failing feature
select c from Customer c  left join fetch c.orders o

Software Information:

  • JSqlParser 5.1
  • Database - My SQL

stacktrace

et.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "JOIN" "JOIN"
    at line 1, column 33.

Was expecting one of:

    <EOF>
    <ST_SEMICOLON>

	at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:48520) ~[jsqlparser-5.1.jar:na]
	at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:48341) ~[jsqlparser-5.1.jar:na]
	at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:345) ~[jsqlparser-5.1.jar:na]
	at net.sf.jsqlparser.parser.CCJSqlParserUtil$1.call(CCJSqlParserUtil.java:341) ~[jsqlparser-5.1.jar:na]
	at net.sf.jsqlparser.parser.CCJSqlParserUtil$1.call(CCJSqlParserUtil.java:338) ~[jsqlparser-5.1.jar:na]    

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions