risingwave
risingwave copied to clipboard
Incorrect result with `ORDER BY` in `OVER(PARTITION BY ...)`
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