4paradigm / 4paradigm/OpenMLDB

LAST JOIN with complex condition not work on offline mode

Open
#3,240 0 comments 0 reactions 1 assignee Claimed by @tobegit3hub View on GitHub
bug high-priority
Dominant language
C++
Stars
1.7k
Forks
331
Avg merge
12d 12h
Merged PRs (30d)
1

Description

**Bug Description**

**Offline sql and error message**

### select t1.col1 from t1 last join t2 order by t2.std_time on int(t1.col1)=int(t2.col1) and t1.col1=t2.col1;

> ERROR yarn.Client: Application diagnostics message: User class threw exception: com._4paradigm.hybridse.sdk.UnsupportedHybridSeException: Fail to resolve expr type: kExprCast, expr node: int32(t1.col1)

Contributor guide

Open the contributing guide

Research direction

The error occurs during SQL expression type resolution in offline mode for a LAST JOIN with a cast condition. Look at the SQL parser and type resolver, likely in the hybridse sdk. The failing expression is `int(t1.col1)`. Run the provided SQL in offline mode to reproduce, then trace through the cast expression handling.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
databases, machine-learning
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 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.