4paradigm / 4paradigm/OpenMLDB

Use simple expressions for join equality condition is supported

Open
#1,687 0 comments 0 reactions 1 assignee Claimed by @tobegit3hub View on GitHub
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.