ClickHouse / ClickHouse/pg_clickhouse
Improve SEMI JOIN testing and behaviors
Open
pushdown
- Dominant language
- C
- Stars
- 283
- Forks
- 21
- Avg merge
- 2d 6h
- Merged PRs (30d)
- 11
Description
Follow up the work in #58 to ensure the quality of SEMI JOIN pushdown:
- [ ] Add tests fo edge cases (multiple EXISTS, complex correlations, etc.) and fix any issues
- [ ] Only simple `Var = Var` equalities extracted as join keys. Complex expressions like `l_orderkey = o_orderkey + 1` won't be recognized. Add tests and fix them.
- [ ] Multiple EXISTS should work via chained `LEFT SEMI JOIN`s; add more tests to validate.
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.