Merged PRs

dolt

• 5865: Drop the formatting flag from the engine
  Small step to untangling shell and query engine. #3922
  Existing tests cover behavior. This is a fairly straight forward refactor.
• 5863: Testing dolt commit in branch control bats tests
  This case was not tested and a customer was having issues so improved our tests
• 5823: Two code clean ups
  • More the format flag out of the sql engine. It's only used by the sql command, and causes confusion
  • Drop the Dbddl code path. It's not longer required.

go-mysql-server

• 1751: Unions finalize subquery expressions
  The SUBQUERY -> UNION -> SUBQUERY_EXPR pattern was subject to an edge case where the outer SUBQUERY disabled recursively finalizing the inner SUBQUERY_EXPR. The intervening UNION node blocked the outer reach, but failed to re-enable finalizeSubquery during finalizeUnion. This PR edits the finalizeUnionSelector to explicitly re-enable finalize nested subqueries.
  This PR also touches hoistOutOfScopeFilters for the same edge case.
  Issue: #5875
• 1747: Added latin1_spanish_ci and latin1_danish_ci collations
  Fixes #5866
• 1746: update json_set support for edge cases
  updated logic of json_set to support more input edge cases
• 1743: Optimize division with integers by using floats internally instead of decimal.Decimal
  Fix for #5832
  Seems unlikely to break anything in Dolt, but I went ahead and ran Dolt CI tests: #5857

vitess

• 234: go/netutil/conn.go: Avoid panicing when ConnWithTimeouts has a Set{,}Deadline method called.
  Clients does not expect setting deadlines on connections to panic. In particular, the standard library's TLS implementation adopts an existing net.Conn and will call SetWriteDeadline on it in certain cases.
  It makes more sense to allow the deadlines to be managed by the client when they see fit. This changes the behavior to simply forward the deadlines along as soon as the client code has shown an interest in managing the deadlines.
• 231: support 'show events' statement parsing
  • Added support for SHOW EVENTS statement parsing
  • Added support for SHOW CREATE EVENT statement parsing
  • Removed FULL option from SHOW TRIGGERS as it's not supported in MySQL.

Closed Issues

• 5019: Feature request: Optimize initialization for large databases
• 5877: PHP Client drops connection on empty call dolt_commit
• 5839: SIGSEGV when attempting to create a new branch while in detached head state.
• 5744: Panic if trying to create a commit on a "use"d tag
• 4570: Three-way merge does not handle type changes
• 5866: Collation latin1_spanish_ci not implemented
• 5568: limit in subquery pushed above where clause
• 5659: Implement SQL function find_in_set
• 5808: Database won't start after import
• 5183: One-time "optimistic lock failed on database Root update" on read replicas after dolt upgrade

Latency