4paradigm / 4paradigm/OpenMLDB

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

Offen
#2,667 0 Kommentare 0 Reaktionen 1 zugewiesene Person Zugewiesen an @zhanghaohit Auf GitHub ansehen
bug execute-engine
Vorherrschende Sprache
C++
Sterne
1.7k
Forks
331
Ø Merge
12 T. 12 Std.
Gemergte PRs (30 T.)
1

Beschreibung

**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.

Beitragsleitfaden

Beitragsleitfaden öffnen

Rechercherichtung

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.

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

Neue Issues direkt in Ihr Postfach

Eine kurze Übersicht über anfängerfreundliche GitHub-Issues.