apache / apache/datafusion-sqlparser-rs

join query in multiy table

Open
#395 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Rust
Stars
3.5k
Forks
772
Avg merge
4d 9h
Merged PRs (30d)
17

Description

Hi,
```sql
select * from student t1 left join class t2 on t1.sid = t2.sid left join use t3 on t2.id = t3.id
```
can be parsed successed.

```sql
select * from student t1 left join class t2 left join user t3 on t2.id = t3.id on t1.sid = t2.sid
```
will be failed

any idea?

Contributor guide

No contributing guide indexed for this repository

Research direction

Reproduce both SQL examples in the parser and compare how the nested LEFT JOIN forms are handled. Trace the failing second query through the SQL parsing entry point, then add coverage for both forms and confirm that the previously failing query parses successfully.

Written by the indexing model from the issue text.

Assessment

Tech stack
rust, sql
Domain
compilers, databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.