This release contains support for CREATE, USE, and DROP database statements. The databases created are in memory and session local. These statements are supported for compliance with the SQL specification to make Dolt work with certain tools. Dolt natively does not support multiple databases.

This release contains major performance improvements to JOIN statements.

Merged PRs

• 1329: CREATE DATABASE (DBDDL)
  This pr brings CREATE DATABASE functionality to dolt and adds associated test cases.
• 1328: Feature version support.
  FeatureVersion is now checked every time a RootVal is read, and is written with every call to doltdb.WriteRootValue().
  A CLI flag was added to dolt.go to enable FeatureVersion testing.
• 305: sql/analyzer: resolve_subqueries.go: Add a missing stripQueryProcess in resolveSubqueries.
• 303: sql/analyzer: Make join_search faster
• 301: Naive/hacky show grants
  hard-coded SHOW GRANTS handling:

  > dolt sql -q "show grants for current_user"
  +-------------------------------------------------------------+
  | Grants for root@%                                            |
  +-------------------------------------------------------------+
  | GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION |
  +-------------------------------------------------------------+
  

• 300: Added Stored Procedure interface for integrators
• 299: sql/{plan,analyzer}: Add IndexedInSubqueryFilter for selecting the subquery results first and then making indexed lookups into the child.
• 298: Add functionality for CREATE DATABASE
• 297: Append error codes/sql state to error messages for downstream clients.
• 48: Add the constants
  Updates our vitess with a bunch of constants
• 47: add support for if exists and if not exists for create database
• 46: Added CREATE PROCEDURE & FUNCTION
  This adds:

  CREATE PROCEDURE
  SHOW PROCEDURE STATUS
  SHOW FUNCTION STATUS
  DROP PROCEDURE
  CALL
  

  The SHOW...CODE statements are being skipped for now, as they're relatively unused compared to the above statements. Additionally, the CREATE statements do not have a fully fleshed-out routine body, as we currently do not parse all valid statements anyway.
• 45: Preliminary vitess support for window funcs.

Closed Issues

• 1324: panic running great expectations unittests