JSqlParser icon indicating copy to clipboard operation
JSqlParser copied to clipboard

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

Open michari opened this issue 7 months ago • 0 comments

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]    

michari avatar Apr 15 '25 16:04 michari