4paradigm / 4paradigm/OpenMLDB
Use simple expressions for join equality condition is supported
Open
batch-engine
sql
- Dominant language
- C++
- Stars
- 1.7k
- Forks
- 331
- Avg merge
- 12d 12h
- Merged PRs (30d)
- 1
Description
Now we can join with condition `t1.c1 >= t2.c1 * 1000` but not `t1.c1 = t2.c1 * 1000`.
Contributor guide
Research direction
Look at the SQL join condition parsing and evaluation code, likely in the query planner or executor. The issue indicates support for inequality joins but not equality with expressions. Find where join conditions are validated and extended to allow simple expressions like multiplication on the right side. Test with a join query using `t1.c1 = t2.c1 * 1000` to verify the fix.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases, machine-learning
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100