4paradigm / 4paradigm/OpenMLDB
LAST JOIN with complex condition not work on offline mode
- Vorherrschende Sprache
- C++
- Sterne
- 1.7k
- Forks
- 331
- Ø Merge
- 12 T. 12 Std.
- Gemergte PRs (30 T.)
- 1
Beschreibung
**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)
Beitragsleitfaden
Rechercherichtung
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.
Vom Indexierungsmodell aus dem Issue-Text verfasst.
Bewertung
- Tech-Stack
- sql
- Bereich
- databases, machine-learning
- Issue-Typ
- Bug
- Schwierigkeit
- 3/5
- Geschätzter Aufwand
- 1-2 Tage
- Aktivitätsstatus
- Veraltet
- Klarheit
- Größtenteils klar
- Anfängerfreundlichkeit
- 45/100