11.108. Release 0.110
General Changes
- Fix result truncation bug in window function row_number() when performing apartitioned top-N that chooses the maximum or minimum N rows. For example:
SELECT * FROM (
SELECT row_number() OVER (PARTITION BY orderstatus ORDER BY orderdate) AS rn,
custkey, orderdate, orderstatus
FROM orders
) WHERE rn <= 5;
原文: https://prestodb.io/docs/current/release/release-0.110.html