Skip to content

Can't find correct current row when frame type is range in window function #9868

@xzhangxian1008

Description

@xzhangxian1008

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

drop table if exists t;
create table t (p int, o int, v int);
insert into t values (1, 1, 1), (1, 2, 2), (1, 2, 3);
alter table t set tiflash replica 1;
set tidb_enforce_mpp=1;
select last_value(v) over (partition by p order by o range between 1 preceding and current row) as res from t;

2. What did you expect to see? (Required)

+------+
| res  |
+------+
|    1 |
|    3 |
|    3 |
+------+

3. What did you see instead (Required)

+------+
| res  |
+------+
|    1 |
|    2 |
|    3 |
+------+

4. What is your TiFlash version? (Required)

nightly(3bd8c24d1a1e)

Metadata

Metadata

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions