Handle joins between columns with different types. This may currently result in a Cartesian Product operator.
Open
- Dominant language
- C
- Stars
- 12.8k
- Forks
- 794
- Avg merge
- 2d 14h
- Merged PRs (30d)
- 31
Description
Handle joins between columns with different types. This may currently result in a Cartesian Product operator.
Contributor guide
Research direction
Start by reproducing a join between columns with different types and inspect the generated plan for a Cartesian Product operator. Trace the join planning path in the Citus PostgreSQL extension; done means compatible join handling avoids an unintended Cartesian Product and is covered by a regression test.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- c, postgresql, sql
- Domain
- databases, distributed-systems
- Issue type
- Bug
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 20/100