Skip to content

v10.1.20

Latest

Choose a tag to compare

@github-actions github-actions released this 04 Nov 14:13
2dbe3e4

What's Changed

Features

  • Add standard deviation and variance window functions by @virzak in #63

Other Changes

  • Translate Select with an element index to ROW_NUMBER by @virzak in #65
  • Add NTILE, CUME_DIST, FIRST_VALUE, LAST_VALUE and NTH_VALUE by @virzak in #64
  • Test that Npgsql's full-text Rank is not taken for the window function by @virzak in #66
  • Translate Where with an element index to ROW_NUMBER by @virzak in #67
  • Translate DistinctBy to the first row of each key by @virzak in #68
  • Keep each test's query in its own variable by @virzak in #69
  • Snapshot the generated SQL and the generator output with Verify by @virzak in #70
  • Report which window functions can return NULL by @virzak in #71
  • Translate GroupBy followed by SelectMany to partitioned window functions by @virzak in #72
  • Translate TakeWhile and SkipWhile to a running count of failures by @virzak in #73
  • Rewrite correlated aggregates over the same rows to partitioned windows by @virzak in #74
  • Rewrite correlated aggregates over preceding rows to ordered windows by @virzak in #75
  • Rewrite correlated previous and next row subqueries to LAG and LEAD by @virzak in #76
  • Rewrite uncorrelated aggregates over the same rows to an empty OVER() by @virzak in #77
  • Pin System.Security.Cryptography.Pkcs to a patched version by @virzak in #79
  • Don't push a query into a subquery for rows already in one by @virzak in #80

Full Changelog: v10.1.1...v10.1.20