Merged PRs

dolt

• 1688: integration-tests/bats: Add some simple bats tests to views in sql-server multi-head mode.
• 1681: Fixed occasional panic from nil VRW on BLOB pks
• 1667: Add dolt log functionality
• 1666: Update some bats tests
• 1665: Beginnings of SQL transaction support.
  Only START TRANSACTION and COMMIT are supported.
  Needs SAVEPOINT, ROLLBACK.
• 1663: Fixed index editors getting to an invalid state on error.
• 1658: Fixed index name handling & self foreign keys on commit.
• 1608: Improve performance of GC.

  go-mysql-server

  • 410: Commit transactions without beginning them, to support commit without a selected database
  • 409: Add the partitions table
    Adds the empty partition table
  • 404: sql/analyzer: Push filters under SubqueryAliases which they apply to.
    This allows optimizations to be applied to the filter clauses within the SubqueryAlias node, including pushdown and index lookup.
  • 403: sql/analyzer: Split analysis of subqueries so that once-after rules are applied uniformly.
  • 402: Added _binary support & REGEXP_LIKE
    Removed REGEXP_MATCHES as it does not exist in MySQL. It is a PostgreSQL function.
  • 401: Add the json_contains function.
  • 400: Support for transactions. Start transaction and Commit implemented so far, as well as @@autocommit handling
  • 398: Fixed view test script
  • 397: Changed default handling & delay fk table resolution
  • 396: /server: Unwrap netutil.ConnWithTimeouts in pollForClosedConnection
  • 395: Refactor nil check handling in check constraints.
  • 394: Fixed bug that only allowed some select statements as view definitions
  • 392: Fixed REPLACE logic to now match MySQL
    Previously we thought that REPLACE was a DELETE then INSERT, but this is not the actual order that MySQL takes.
  • 391: Install a format checker script and workflow.
  • 390: Adds the key column usage table
    https://dev.mysql.com/doc/refman/8.0/en/information-schema-key-column-usage-table.html

  vitess

  • 73: go/vt/sqlparser: Follow MySQL in making ORDER BY/LIMIT on left hand of UNION a syntax error.
  • 72: Added savepoint and friends

  Closed Issues

  • 1670: dolt merge-base
  • 1662: Bug: sql-server fails with TablePlus while introspecting schema due to UUID
  • 1659: GCP Authentication Fails on Google Colab