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 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;