We are pleased to announce Dolt 0.22.7.

This release focuses on bug fixes, and performance improvements in SQL. In particular delivered huge performance improvements in our SQL implementation. You can find the scope of these performance improvements detailed on our benchmarks page.

Merged PRs

• 1116: partition ranges, covering indexes, smarter iterators
• 1111: README quotes changed bugfix for windows terminal
  On the README there are instructions on how to add values into a table. The values in one portion have single quotes on the outside and have double-quotes for any string. While that format works in a Unix terminal, it doesn't work in
• 1109: Attempt to add default decimal type to FromKind
• 1108: Fixed dolt status output incorrectly displayed for staged files
  The function printStagedDiffs always returned 0, even when there were diffs not staged. This return was also causing it to print in printStatus "nothing to commit, working tree clean". This was not the case.
  I changed printStagedDiffs to return the number of the staged tables plus the number of staged docs instead. This prevents it from entering the if statement with the print also.
• 1107: go/libraries/doltcore/{row, sqle, table}: Generalize TableReader
  Created table.SqlTableReader as a replacement for directly reading from table maps. Used it to replace types.MapIterator in sqle.doltTableRowIter
• 1106: Added verify-constraints command
• 1105: /MySQLDockerfile: peg version to match Gemfile.lock BUNDLED WITH
• 1103: /go/cmd/dolt: added feature flag for keyless schemas
• 1102: go/libraries/doltcore/{doltdb,table}: remove row access methods from doltdb.Table
  Removed:
  • Table.GetRowByPKVals()
  • Table.GetRow()
  • Table.GetRows()
    Had do to some refactoring along the way to fix dependency cycles.
    Reversed dependency rowconv -> pipeline to pipeline -> rowconv
• 1101: Ensure that MERGE() works properly with fast forward.
  Added test case as well.
• 1098: Export NewJSONReader to use in dolthubapi
• 1097: Fixed table import allowing NULLs in the primary key
  Fixes #1096
• 1093: go/libraries/doltcore/table/editor: Convert TableEditor to interface
• 1090: Add --author, -m to COMMIT. Add --author to MERGE()
  COMMIT('-m', 'hi', '--author', 'John Doe john@doe.com')
  MERGE('feature-branch', '--author', 'John Doe john@doe.com')
• 1089: Add the Dolt mascot to README
• 1088: fixed rand seed
• 1087: increase query parallelism from the default of 2 to 8
• 1085: split TableEditors and IndexEditor to their own package
• 1084: bats/: keyless spec
  This is a set of skipped BATS tests that provide a spec for keyless tables.
• 1082: Fixed internal index comparisons considering unnecessary parameters
  Fixes #1081
• 1080: Fixed shell error loop on UNIQUE violation
  Fixes #1079
• 1078: Upgraded to latest go-mysql-server with support for indexed joins on any number of tables
• 1075: Support for CURRENT_USER SQL function without ()
• 1074: Add dolt_commit error check when autocommit is off
  Fails loudly when autocommit is off for dolt_commit.
• 245: Fixed tuple comparisons
• 240: Enginetests for Keyless tables
• 239: naked functions
  Fix for naked CURRENT_USER function call was in vitess, this just adds tests.

Closed Issues

• 1099: MERGE() is creating a new commit on FFs.
• 1096: Table import can allow NULLs in the primary key
• 1081: "string is too large for column"
• 1079: Indefinitely errors in SQL shell once a UNIQUE constraint has been violated
• 1071: Throw error in DOLT_COMMIT if autocommit is not true
• 241: expression.Tuple is uncomparable