Merged PRs

dolt

• 2221: Fix some JSON path quoting issues.
• 2220: Add configurable memory cap on used memory in table editor accumulators.
• 2219: Optimize memory usage for some write use cases.
• 2217: go/libraries/doltcore/remotestorage: Allow a write cache to limit memory usage.
• 2211: refactor: move from io/ioutil to io and os package
  The io/ioutil package has been deprecated in Go 1.16 (See https://golang.org/doc/go1.16#ioutil).
• 2208: initial dolt backup cli
  • backup namespacing is the same as remote namespacing, but different field in repo state
  • introduce a RootSync command, which backups are based off of
  • until we cleanup clone, you can still clone a backup and accidentally get working sets
  • bats checks for different ref cases that we expect to exist after a backup -> restore
• 2207: Update load data bats to remove secure_file_priv
• 2205: Unblock Keyless SQL Diffs and Minimize SQL Diffs
  Allows for dolt diff -sql to be used for keyless tables and add alter pk support for sql diffs.
• 2204: go/store/nbs: table_reader.go: canReadAhead: Limit how large a read can get from coalescing individual chunk reads.
• 2196: config, clone, backups refactor
  • previously env variables are now dolt config variables for better locality
  • move clone logic into library functions
  • multi env test setup is more like a builder and implements clone so that we can have repos with common ancestors
• 2194: Added a test for disabling foreign keys during SQL export
  Additional test for #1669
• 2193: Bug fix for SQL export of enum columns
  Fixes #2187
• 2191: Add a warning for CREATE DATABASE
  Warning is due to CREATE DATABASE not persisting after the server exits
• 2182: FF head on read replica
  • adds dsqle.ReadReplicaDatabase which implements dsqle.SqlDatabase
  • expands uses of dsqle.Database to accommodate all dsqle.SqlDatabase implementations
  • Read replica DB decorates db.StartTransaction to execute a fetch on DOLT_READ_REPLICA_REMOTE
  • ReadReplicaDatabase is -not- read only right now, need another decorator or field
  • cli and sql bats tests
  • sql dolt tests this is skipped due to in process server conflicts with multiple ongoing tests
  • bunch of sql shadow functions (create table, stage, commit, push) to allow for testing multiple dEnv's side-by-side

go-mysql-server

• 573: Add several features that unblock mysql workbench
  This pr implements
  1. Show STATUS
  2. Set CHARACTER SET
• 572: Add the EXISTS Operator for Select Where Filters
  Adds the exists operator as described here: https://dev.mysql.com/doc/refman/8.0/en/exists-and-not-exists-subqueries.html
• 567: sql/plan,analyzer: Fix HashLookup for cases where there is a schema prefix not visible to the direct join parent.
• 555: Fix handling of secure_file_priv for LOAD DATA

Closed Issues

• 2168: Make dolt diff -r sql render minimal UPDATE statements
• 2166: MySQL Workbench 8.0 Connection Error
• 802: dolt init fails on nfs-mounted directories
• 1390: document the format of s3 remote strings
• 1603: Require SSL
• 1439: Implement EXISTS() function
• 1709: dolt table import with --no-gc deadlocks unexpectedly
• 1851: dolt should update schema on table import --replace
• 1997: DOLT_PULL and DOLT_PUSH SQL functions
• 2113: Rename "master" to "main"
• 2164: Support EXISTS predicates and expressions
• 1539: Django 3.2 MySQL backend fails with function: 'convert_tz' not found
• 2187: SQL export doesn't quote enums
• 499: "ORDER BY" expressions behaviour compatible with MySQL?