4paradigm / 4paradigm/OpenMLDB
Empty tables use group functions to prompt empty set
- 主要语言
- C++
- 星标
- 1.7k
- 派生
- 331
- 平均合并
- 12 天 12 小时
- 30 天内合并 PR
- 1
描述
Empty tables use group functions to prompt empty set
## Expected Behavior
count(*) => 0
## Current Behavior
empty set
## case
```yaml
- id: 3
desc: "表是空的"
tags: ["TODO","@chengjing,bug,"]
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 bigint"]
rows:
- [0,0,0,0,0]
```
贡献指南
调研方向
The issue includes a test case in YAML showing that aggregate functions (count, max, min, avg, sum) on an empty table return 'empty set' instead of zeros. Look for the SQL execution engine code handling aggregate functions and empty result sets. Run the provided test to reproduce the issue, then examine how aggregate functions compute results when no rows are present.
由索引模型根据 Issue 内容生成。
评估
- 技术栈
- sql
- 领域
- databases
- Issue 类型
- 缺陷
- 难度
- 3/5
- 预计耗时
- 1-2 天
- 活跃度
- 停滞
- 描述清晰度
- 基本清楚
- 新手友好度
- 45/100