13.163. 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 minimum N rows. For example:

    1. SELECT * FROM (
    2. SELECT row_number() OVER (PARTITION BY orderstatus ORDER BY orderdate) AS rn,
    3. custkey, orderdate, orderstatus
    4. FROM orders
    5. ) WHERE rn <= 5;