search

pavanvd / postgres-xl

Public Postgres-XL repository
Mozilla Public License 2.0
4 stars 3 forks source link

ERROR: failed to deconstruct sort operators into partitioning/ordering operators #18

Open pavanvd opened 9 years ago

pavanvd commented 9 years ago

The following test case fails in XL:

postgres=# CREATE TABLE test (a int, b int);
postgres=# EXPLAIN SELECT last_value(a) OVER (PARTITION by b) FROM (SELECT * FROM test  ORDER BY a) AS s ORDER BY a;
ERROR:  failed to deconstruct sort operators into partitioning/ordering operators