Merged PRs

dolt

• 5634: Added support for ALTER TABLE ... COLLATE
  Fixes #5623
  Builds upon dolthub/vitess#229 and dolthub/go-mysql-server#1676

go-mysql-server

• 1679: Small fix for a join-related regression in Dolt
• 1677: fix for duplicate hash tuple in
  This is the old explain:

  tmp> explain select * from t where i in (1, 1);
  +---------------------------------------+
  | plan                                  |
  +---------------------------------------+
  | Filter                                |
  |  ├─ (t.i HASH IN (1, 1))              |
  |  └─ IndexedTableAccess(t)             |
  |      ├─ index: [t.i]                  |
  |      ├─ filters: [{[1, 1]}, {[1, 1]}] |
  |      └─ columns: [i]                  |
  +---------------------------------------+
  6 rows in set (0.00 sec)

  We just had duplicate Ranges inside the filters, which cause multiple lookups for the same value.
  A side-effect of this change is that the filters are now sorted in the explain query, so that's nice.
  Example: https://github.com/dolthub/go-mysql-server/pull/1677/files#diff-eae6109880e132a9197c2b536f62e9572fc34d8e7c65e957dd37f48657790a94L2392-R2392
• 1676: Added support for ALTER TABLE ... COLLATE
  Fixes #5623
  Builds upon dolthub/vitess#229
• 1675: SET multiple system variables including 'NAMES' and 'CHARSET'
• 1669: clean up hoisting
  Variety of refactors related to hoisting subqueries and unnesting scopes.
  • remove SingleSelectRel
  • empty join expansion
  • limits + filters should be tested in memo now
  • fix to anti join correctness for empty right-hand rel
• 1660: Added a permissive collation coercibility model
  This PR adds support for collation coercion by granting every expression, node, and type the ability to report their own coercibility. In addition, we're extremely permissible now, and do not report any coercibility errors, which deviates from MySQL. This still attempts to adhere to MySQL's coercibility rules as much as possible though.

vitess

• 229: Added support for ALTER TABLE ... COLLATE
  Fixes #5623
• 226: supporting syntax for user variables in PREPARE statements
  fix for: #5530

Closed Issues

• 4428: Collation Coercibility
• 5623: Missing support for ALTER TABLE table_name COLLATE utf8mb4_bin;
• 5630: "Out of range for int" error

Latency