Release 0.110
General Changes
Fix result truncation bug in window function
row_number()
when performing a partitioned top-N that chooses the maximum or minimumN
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;