GV

GeezerVison

The World Wide Web, restored to 800 pixels of glory.

Home|About|Gaming cabinet|Archives|How it works|Starter sites

On this site

  • Sign in
  • ActionsCI/CD and automation
  • CodespacesCloud development environments
  • All Features
  • Documentation
  • Training
  • Certifications
  • Build with Copilot
  • Customize Copilot
  • Integrations
  • Trending repos
  • GitHub Sponsors
  • Developer articles
  • Enterprises

This view

  • Original page
  • New address

GeezerVison is showing github.com — [BUG] [5.1] : MySql : JOIN FETCH Failing to parse · Issue #2229 · JSQLParser/JSqlParser

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

New issue
Copy link
New issue
Copy link
Closed
#2375
Closed
[BUG] [5.1] : MySql : JOIN FETCH Failing to parse#2229
#2375
Copy link
Labels
MySQLMySQL specific issueMySQL specific issueSponsor neededexotic

Description

@michari
michari
opened on Apr 15, 2025
Issue body actions

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]

Activity

  1. manticore-projects
    added
    MySQLMySQL specific issueMySQL specific issue
    exotic
    Sponsor needed
    on Apr 18, 2025
  2. manticore-projects
    closed this as completedin #2375on Feb 12, 2026
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    MySQLMySQL specific issueMySQL specific issueSponsor neededexotic

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions
      You are visitor 01402520 — GeezerVison does not store the pages you look up.
      Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.