4paradigm / 4paradigm/OpenMLDB
select into and request mode will get multiple incorrect result
- 主要语言
- C++
- 星标
- 1.7k
- 派生
- 331
- 平均合并
- 12 天 12 小时
- 30 天内合并 PR
- 1
描述
**Bug Description**
Use the demo docker image.
Execute the following sql will get one correct data.
```
SELECT c1, c2, sum(c3) OVER w1 AS w1_c3_sum FROM demo_table1 WINDOW w1 AS (PARTITION BY demo_table1.c1 ORDER BY demo_table1.c6 ROWS BETWEEN 2 PRECEDING AND CURRENT ROW) CONFIG (execute_mode = 'request', values = ("aaa", 11, 22, 1.2, 1.3, 1635247427000, "2021-05-20"));
```
Execute the following sql will get multiple incorrect data.
```
SELECT c1, c2, sum(c3) OVER w1 AS w1_c3_sum FROM demo_table1 WINDOW w1 AS (PARTITION BY demo_table1.c1 ORDER BY demo_table1.c6 ROWS BETWEEN 2 PRECEDING AND CURRENT ROW) INTO outfile "online.csv" OPTIONS (header = false, mode = 'overwrite') CONFIG (execute_mode = 'request', values = ("aaa", 11, 22, 1.2, 1.3, 1635247427000, "2021-05-20"));
```
贡献指南
调研方向
The issue involves a window function query producing incorrect results when combined with SELECT INTO OUTFILE in request mode. Start by examining the query execution path for request mode and the INTO OUTFILE handling in the codebase. Look for differences in result set generation or serialization between the two query forms. Run the provided SQL against the demo docker image to reproduce the issue, then trace through the relevant database engine modules.
由索引模型根据 Issue 内容生成。
评估
- 技术栈
- sql
- 领域
- databases, machine-learning
- Issue 类型
- 缺陷
- 难度
- 4/5
- 预计耗时
- 3-5 天
- 活跃度
- 停滞
- 描述清晰度
- 基本清楚
- 新手友好度
- 30/100