4paradigm / 4paradigm/OpenMLDB
There is no data in the result of full table aggregation calculation for an empty table
- 主要语言
- C++
- 星标
- 1.7k
- 派生
- 331
- 平均合并
- 12 天 12 小时
- 30 天内合并 PR
- 1
描述
**Bug Description**
There is no data in the result of full table aggregation calculation for an empty table

+ 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.
贡献指南
调研方向
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.
由索引模型根据 Issue 内容生成。
评估
- 技术栈
- sql
- 领域
- databases, machine-learning
- Issue 类型
- 缺陷
- 难度
- 3/5
- 预计耗时
- 1-2 天
- 活跃度
- 停滞
- 描述清晰度
- 基本清楚
- 新手友好度
- 45/100