We are releasing Dolt 0.18.3 with a host of bug fixes and performance improvements. In particular:

• SHOW TABLES now supports AS OF syntax, which can point at a timestamp or branch
• subqueries can now reference their surrounding outer scope, bringing them into line with MySQL subqueries
• substantial memory footprint improvements, particularly when importing data

Merged PRs

• 837: /{.github, go}: remove check-committers check from ci
• 835: Updated go-mysql-server, added test for SHOW TABLES AS OF
• 834: Andy/release tags
  First pass at implementing dolt tag. Basic functionality to create, list, and delete tags. For now the command is hidden. At the Noms layer, tags are implemented as commits. Still todo:
  • Checkout a tag (Git does this via detached head)
  • Push/Pull tags to/from a remote
• 831: Updated to hard fork of vitess
• 829: Zachmu/mysql update
  Fixed compile errors and problems in query differ in latest go-mysql-server (not checked in yet). Will update go-mysql-server in go.mod before checking this in. Tests will fail until then.
• 827: add --show-current option to dolt branch
  I added --show-current option to dolt branch cli.
  ref. #818
• 826: shallow clone
• 825: Updated version for release of version 0.18.2
• 159: Updated references for hard fork of vitess
• 158: Fixed panic when using non-literals as column defaults
  This fixes #104
• 157: Fixed the run script and a couple of the integrations
• 156: Bug fix for issue 152
  This fixes #152
• 155: Zachmu/delete js
  Deleted JS integration and unused theme files.
• 154: Zachmu/analyzer scope 5
  Final-ish solution for subquery expression analysis. Haven't yet merged the original PR since I still haven't fixed dolt to work with this.
• 151: Zachmu/analyzer scope 3
  Partial implementation of subqueries with outer scope resolution. Not every subquery works yet, but I believe that this is strictly additive in terms of capabilities: no query that worked before is broken by this change, and many now pass. I want to get this merged in since it includes a few large interface changes and file moves that could conflict with other work. I will verify that this increases pass rates in sqllogictest before merging.

Closed Issues

• 830: Dropping named foreign key does not allow the foreign key name to be reused
• 152: Better error message for unquoted string in AS OF queries