Merged PRs

dolt

• 4068: Add storage format information to dolt version and add new sql function dolt_storage_format(). Add dolt init --new-format
  • Adds --new-format to dolt init. For example:

  $ dolt init --new-format
  

  • Adds storage format information to dolt version. For example:

  $ dolt version
  dolt version 0.40.24
  database storage format: OLD ( __LD_1__ )
  

  We considered making a separate command called dolt storage_format, but decided against it to promote discoverability of the current storage format that dolt is using.
  • Adds a new sql function that returns the format used by the currently selected database. For example:

  > SELECT dolt_storage_format();
  +-----------------------+
  | dolt_storage_format() |
  +-----------------------+
  | NEW ( __DOLT__ )      |
  +-----------------------+
  

  • dolt_version() is unchanged:

  > SELECT dolt_version();
  +----------------+
  | dolt_version() |
  +----------------+
  | 0.40.24        |
  +----------------+
  

  In the SQL context, we decided to display the storage format in a new function. The reasoning is partly due to the fact that MySQL functions do not support multiple return columns and partly to make parsing either the dolt version or storage format by clients easy.
• 4066: Fixed flakey history table test
• 4064: go/store/prolly: Fix race in diffOrderedTrees
• 4048: Clean up the import benchmarker notes
• 4021: Refactoring Dolt's use of ExternalStoredProcedureDatabase to ExternalStoredProcedureProvider
  Fixes: #3934
  Depends on: dolthub/go-mysql-server#1156

go-mysql-server

• 1177: Secondary Lookup Range Templates
  Do not use the IndexBuilder for secondary lookups. Directly create the equality ranges and/or nullable filters.
  index_join_scan latency change locally on OXS: 4.8ms -> 3.8 ms (-20%).
  No interface changes, regular Dolt bump passes at the time the PR was created.
• 1172: Allow common table expressions in INSERT, UPDATE, DELETE statements
  This fixes #4025
• 1156: Refactoring ExternalStoredProcedureDatabase to ExternalStoredProcedureProvider
  From #3934, we want customers to be able to call the dolt_clone stored procedure when no database is selected.

vitess

• 184: Added parse tests for all functions
• 183: resolving unreserved keyword inconsistencies with MySQL
  Tests have been updated to document the inconsistencies below.
  Changes:
  • unreserved many keywords
  • allow reserved keywords to be used as identifiers when they are qualified
    Words that parse in dolt, but don't in MySQL:
  • dual
  • minute_second
    Words that don't parse in dolt (only in quries that use these in where conditions), but do in MySQL:
  • escape
  • next
  • off
  • sql_cache
  • sql_no_cache
    Fix for: #3977
• 182: Fix error in REPEAT function

Closed Issues

• 3879: Building from source fails "package embed is not in GOROOT"
• 3880: Panic when running dolt sql-server in a directory with old and new format dolt databases
• 3881: Running dolt sql-server creates an empty .doltcfg directory. Potential UX issue.
• 3950: Cant merge and because dolt does not let me resolve conflicts
• 3977: Nonreserved keywords require escaping
• 3979: Dolt insists reserved words are always quoted
• 4059: panic: unknown encoding when running dolt diff --summary
• 3934: call dolt_clone() does not work if you have not used a database