4paradigm / 4paradigm/OpenMLDB

There is no data in the result of full table aggregation calculation for an empty table

Ouverte
#2,667 0 commentaires 0 réactions 1 personne assignée Assignée à @zhanghaohit Voir sur GitHub
bug execute-engine
Langage dominant
C++
Étoiles
1.7k
Forks
331
Merge moyen
12 j 12 h
PR mergées (30 j)
1

Description

**Bug Description**
There is no data in the result of full table aggregation calculation for an empty table
![image](https://user-images.githubusercontent.com/18275570/196114883-86d9e911-97bc-43d3-b9be-1510af4da0e2.png)

+ case
```yaml
- id: 3
desc: "表是空的"
tags: ["TODO","@chengjing,bug,"]
mode: request-unsupport
inputs:
-
columns : ["id bigint","c1 string","c2 int","c7 timestamp"]
indexs: ["index1:c1:c7"]
sql: select count(c2) as v1,max(c2) as v2,min(c2) as v3,avg(c2) as v4,sum(c2) as v5 from {0};
expect:
order: c1
columns: ["v1 int","v2 int","v3 int","v4 double","v5 int"]
rows:
- [0,null,null,null,null]
```

**Expected Behavior**
Expect to have data
**Relation Case**
test_udaf_table.yaml id:3
**Steps to Reproduce**

1.
2.
3.
4.

Guide de contribution

Ouvrir le guide de contribution

Piste de recherche

The bug is in test_udaf_table.yaml case id:3, which expects aggregation results (count, max, min, avg, sum) on an empty table to return a row with nulls. Look at the SQL aggregation logic for empty tables, likely in the query engine or UDAF implementation. Run the specific test to see the current failure, then trace where empty table results are generated.

Rédigé par le modèle d'indexation à partir du texte de l'issue.

Évaluation

Stack technique
sql
Domaine
databases, machine-learning
Type d'issue
Bug
Difficulté
3/5
Temps estimé
1-2 jours
Activité
À l'abandon
Clarté
Plutôt claire
Accessibilité débutants
45/100

Recevez les nouvelles issues par e-mail

Un résumé court des issues GitHub adaptées aux débutants.