4paradigm / 4paradigm/OpenMLDB

request mode: window union over (last join) expect wrong schema of union query

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

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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.