4paradigm / 4paradigm/OpenMLDB
request mode: window union over (last join) expect wrong schema of union query
Open
bug
execute-engine
- Dominant language
- C++
- Stars
- 1.7k
- Forks
- 331
- Avg merge
- 12d 12h
- Merged PRs (30d)
- 1
Description
In request mode, `window union over (t1 last join t2) ` , the union query expect a schema of t1 (left query), it should be `t1 + t2` instead
Contributor guide
Research direction
The issue is about a window union query in request mode expecting the wrong schema. Look at the SQL parser and query planner for window union operations, especially around 'last join'. Check the schema inference logic for union queries in request mode. The fix likely involves updating the schema combination logic to include columns from both t1 and t2.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases, machine-learning
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100