This release is the first implementation of SQL Window Functions with ROW_NUMBER() being the first supported Window Function. More to come.

Other than that bug fixes and performance improvements on SQL JOINs and Dolt Merges.

Merged PRs

• 1369: disable foreign key checks on merge with warning
  Foreign key constraint violations on merge had the potential to make resolving conflicts between two commits impossible. Merges are now done without foreign key constraint validation. A new warning message was added when there is potential for this to be an issue. Foreign key constraint validation is enforced on commit.
• 1367: fix infinite loop when allocating encoding buffers larger than 2GBi
• 1365: Speed improvement. No need to flush() every row during a merge.
• 314: sql/analyzer/prune_columns.go: Turn off pruneColumns when a Subquery expression exists.
• 311: sql/analyzer/resolve_subqueries.go: Make subqueries which include subqueryaliases cacheable.
• 310: sql/plan/subquery.go: Make certain that analyzed nodes below a subquery that includes a subquery alias node see the row results they are expecting.
• 309: Follow specific rules for mysql float/double/error depending on the float ops.
• 308: Window functions
  This is a full implementation of window functions, with only the ROW_NUMBER() function supported. Partitions and order-by work for the OVER() clause, but other constructs (PRECEDING, FOLLOWING, etc.) are not supported.
  Other limitations:
  • Can't use window functions with GROUP BY
  • Can use non-window aggregates with window functions, but only if they are declared with an empty OVER clause