risingwave icon indicating copy to clipboard operation
risingwave copied to clipboard

Incorrect result with `ORDER BY` in `OVER(PARTITION BY ...)`

Open YuanchengJiang opened this issue 2 years ago • 3 comments

Describe the bug

The result is not expected.

Error message/log

Actual result: [(1,),(2,)]

To Reproduce

CREATE TABLE test (c_0 INT);
INSERT INTO test VALUES (1);
INSERT INTO test VALUES (2);
SELECT DISTINCT count(1) OVER(PARTITION BY T1.c_0>=T1.c_0 ORDER BY 1) FROM test AS T1;

Expected behavior

Expected result: [(2,)]

How did you deploy RisingWave?

Docker

The version of RisingWave

PostgreSQL 9.5-RisingWave-1.3.0-alpha (60b342965d960ea2d6769d6c412f79318b42739e)

Additional context

No response

YuanchengJiang avatar Oct 12 '23 12:10 YuanchengJiang