11.131. Release 0.110
General Changes
- Fix result truncation bug in window function
row_number()
when performing apartitioned 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;