Merged PRs

dolt

• 6287: Run backwards compatibility tests against more recent versions of dolt.
  We no longer support the old __LD_1__ file format, so the backwards compatibility tests right now are only testing against massively out of date and unsupported versions of DOLT.
  This list includes v0.50.0, the first version where the new file format is the default, as well as v0.75.0, the other major release before v1.0.0, and then v1.0.0 and every minor release since.
• 6285: Fix: unstaged ignored tables are staged after a cherry-pick abort
  Fix issue where unstaged ignored tables are staged after a cherry-pick abort
• 6284: Autoincrement bug fixes
  This PR adds the ability to manually reset a table's next auto increment to a lower value than those previously used, and fixes a number of other long standing bugs related to auto increment mangement
  Fixes #6253
• 6259: Migrate dolt cherry-pick to only use SQL
  This change migrates dolt cherry-pick to only use SQL.
  Related: #3922

go-mysql-server

• 1868: Fix bug in OrderedDistinct over Projection
  A mistype was checking the table name twice for column equality, rather than table and column name. The bug led to using OrderedDistinct in inappropriate cases.
• 1867: Support for USING character set expressions
  Fixes #6291
• 1865: Add CustomValidator interface
  In many places we expect to see a commit hash in our result.
  Since the hashes take into account the system time when computing, it is difficult to predict what they will be.
  This PR adds a new interface that can be implemented on the dolt side to check for commit hashes.
• 1864: No parallelism for children of ordered distinct
  We permitted parallelism into an OrderedDistinct node, which is a specialized Distinct node that expects results sorted on a specific index key. This change prevents parallelizing children of OrderedDistinct.

vitess

• 253: Automatically concatenate adjacent string literals
  Fixes #5232
  This is to match the mysql behavior:

  mysql> select "a" 'b'   "c";
  +-----+
  | a   |
  +-----+
  | abc |
  +-----+

  The grammar can't accommodate this so it has to go in the lexer. It doesn't work if the strings are broken up by a mysql special comment, so we still have to special case that.
  Also removed support for using string literals as table aliases. MySQL has a mode to support using double-quoted strings only as identifiers, but it's not on by default and isn't supported anywhere else in the grammar.
• 252: Fixed keyword usage in primary key clauses
  Fixes #6290
• 251: Fixed missing support for collations as strings
  Fixes issue #6192
  We only allowed collations to be declared after the CREATE TABLE portion in their non-string form. This adds support for the string form.

Closed Issues

• 6253: Can't set auto_increment counter to values already used even if records are deleted
• 5232: Support implicit string concatenation
• 6291: Support CONVERT USING <collation> syntax
• 6290: primary key (password) requires password to be backticked

Latency