4paradigm / 4paradigm/OpenMLDB

Inconsistent results in online/offline mode while join condition includes null

Abierto
#3,685 2 comentarios 0 reacciones 2 asignados Reclamado por @aceforeverd Ver en GitHub
bug execute-engine high-priority
Lenguaje dominante
C++
Estrellas
1.7k
Forks
331
Merge medio
12 d 12 h
PR fusionados (30 d)
1

Descripción

```
table: t1
columns: [ "c1 string","c2 int","c3 bigint","c4 timestamp" ]
indexs: [ "index1:c1:c4" ]
rows:
- [ NULL,2,3,1590738989000 ]
```
```
table: t2
- columns: [ "c1 string","c2 int","c3 bigint","c4 timestamp" ]
indexs: [ "index1:c1:c4" ]
rows:
- [ NULL,2,3,1590738989000 ]
```
`sql: select t1.c1,t1.c2,t2.c3,t2.c4 from t1 last join t2 ORDER BY t2.c4 on t1.c1=t2.c1;`
expect rows:
- [ null,2,3,1590738989000 ]

real rows:
- [ null,2,null,null ]

Guía de contribución

Abrir la guía de contribución

Línea de trabajo

The issue shows a SQL join query with a NULL equality condition producing different results in online vs offline modes. Start by locating the join implementation for 'last join' in the query engine, likely in the SQL execution or optimizer modules. Examine how NULL comparisons are handled in join conditions across execution modes. Run the provided test case to reproduce the inconsistency, then trace through the join logic to identify the divergence.

Escrito por el modelo de indexación a partir del texto del issue.

Evaluación

Stack tecnológico
sql
Área
databases, machine-learning
Tipo de issue
Error
Dificultad
4/5
Tiempo estimado
3-5 días
Estado de actividad
Estancado
Claridad
Bastante claro
Aptitud para principiantes
35/100

Recibe los nuevos issues en tu correo

Un resumen breve de issues de GitHub para principiantes.