Can't parse with query inner join

I have statement :
SELECT * FROM TABLE1 tb1
INNER JOIN TABLE2 tb2
INNER JOIN TABLE3 tb3
INNER JOIN TABLE4 tb4
ON (tb3.aaa = tb4.aaa)
ON (tb2.aaa = tb3.aaa)
ON (tb1.aaa = tb2.aaa)

I try :
Select select = (Select) CCJSqlParserUtil.parse("SELECT * FROM TABLE1 tb1 "
+ "INNER JOIN TABLE2 tb2 "
+ "INNER JOIN TABLE3 tb3 "
+ "INNER JOIN TABLE4 tb4 "
+ "ON (tb3.aaa = tb4.aaa) "
+ "ON (tb2.aaa = tb3.aaa) "
+ "ON (tb1.aaa = tb2.aaa)");

Expected behavior
Exception in thread "main" net.sf.jsqlparser.JSQLParserException: Encountered unexpected token: "ON" "ON"
at line 1, column 115.
System

Database you are using : Oracle
Java Version : 1.8
JSqlParser version : 4.1

Greetings.

unfortunately I am not sure if your Statement is valid.
Changing it into valid syntax will work:

SELECT *
FROM table1 tb1
    INNER JOIN (TABLE2 tb2 INNER JOIN (TABLE3 tb3 INNER JOIN TABLE4 tb4 ON tb3.aaa = tb4.aaa) ON tb2.aaa = tb3.aaa)
        ON tb1.aaa = tb2.aaa
;

You can test it here online and interactively

Please close the issue after verification.

Thanks for your support,
But this is statement is valid.
You can check it below :
sqlstatement
check valid SQL oracle :
https://www.eversql.com/sql-syntax-check-validator/

Do you have an idea for this issue?
Maybe, convert the statement to JSQLParse have to parse it.

JSQLParser does expect the extra-brackets around the nested joins, although this might be subject to a change/improvement because in fact the RDBMS do not expect these extra-brackets.

JSQLParser does not support your initial statement.

according to https://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_10002.htm#BABGHCBD

my assumption on the syntax seems to be correct.

I have just checked in H2 and also Oracle itself

select *
from risk.instrument a
inner join risk.instrument b
inner join risk.instrument c
on b.id_instrument=c.id_instrument
on a.id_instrument = b.id_instrument

It is indeed a valid statement and we will need to refactor the JOIN expressions accordingly.
The original report is legit, thank you for reporting it.

I look forward to your updates

Implement Joins with multiple trailing ON Expressions

@manticore-projects

Dear @manticore-projects ,
How to get a version to have the resolver

How to get a version to have the resolver

Greetings, either pull from the PR (which has not been accepted yet) or use the attached unoffical snapshot I built for you.
jsqlparser-4.2-SNAPSHOT_UNOFFICAL.jar.zip

Implement Joins with multiple trailing ON Expressions (#1303)

fix(parser): parse INSERT ON CONFLICT after a join's trailing ON

fix(parser): parse INSERT ON CONFLICT after a join's trailing ON (#2551)

Navigation Menu

Repository navigation

Can't parse with query inner join #1302

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Can't parse with query inner join #1302

Description

Activity

manticore-projects commented on Aug 14, 2021

longht95 commented on Aug 14, 2021

manticore-projects commented on Aug 14, 2021

manticore-projects commented on Aug 14, 2021

manticore-projects commented on Aug 14, 2021

longht95 commented on Aug 14, 2021

longht95 commented on Sep 3, 2021

manticore-projects commented on Sep 4, 2021

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions