Merged PRs

dolt

• 2143: Import fix to not put NullValue into types.Tuples for map values
• 2142: Bump GMS
• 2139: common library fetchRefSpec
  • consolidate getRefSpecs functions from cli/env
  • fetch argument switching matches git more closely -- specifying the remote is necessary, no default to origin
• 2135: /go/libraries/doltcore/{env,doltdb,ref}: Add init.defaultBranch to Dolt Config
  mirrors Git config functionality:

  git init
  hint: Using 'master' as the name for the initial branch. This default branch name
  hint: is subject to change. To configure the initial branch name to use in all
  hint: of your new repositories, which will suppress this warning, call:
  hint:
  hint:   git config --global init.defaultBranch <name>
  

• 2131: Create Dolt Database
• 2112: Only show key name, not column tag number
  Closes #2107.

go-mysql-server

• 552: Fixed actual default collation representative
• 551: Check Error when building Session
• 549: Mutable DatabaseProvider refactor
• 548: Fix Resolve Defaults
• 547: Expose CREATE DATABASE to integrators
  Remove AddDatabase functionality from Catalog and DatabaseProvider. Must have a DatabaseProvider with a static set of Databases to construct a Catalog.
  New Databases can be created with CreateDatabase, which is now an integrator function.
• 544: sql/plan: exchange_test.go: Sometimes these tests fail under -race because they are racey. Fix that.
• 540: sql/expression/function/aggregation: Change aggregation functions to work better with group by expressions.
  The existing code seems to be expecting rows to arrive in order of the group by expression. But the analyzer does not arrange for that to happen.
  Instead, this PR changes the approach so that each aggregation function duplicates its Child expression(s) as part of its per-aggregation state. That way it can Eval against its per-group-by Child and get the correct results out of Distinct for example.
  This PR updates AVG, FIRST, LAST, MAX, MIN and SUM to do this. COUNT(DISTINCT ...) is handled by a special expression node instead, and nothing has been changed in Count or CountDistinct. group_concat also seems to handle DISTINCT itself, and so I have not changed anything there. Json aggregation did not look immediately amenable to combining with DISTINCT, because the Update functions seemed to error when the child expression returned nil, so I have not changed them either.

vitess

• 84: support for value and status keywords
  needed two features for mlflow:
  • column named value (alter table t modify value float(53) not null)
  • check named status (alter table a drop check status)
• 83: Max/drop pk

Closed Issues

• 2107: Bad error message for foreign key constraint violation in import