Merged PRs

dolt

• 5244: go/store/nbs: upload table parts on push for GCS backed NBS
• 5242: output correct result for empty JSON
• 5240: go/store/nbs: Update table-file-exists sanity check to not check for files which are already in our view of upstream.
• 5239: integration-tests: hardcoded versions for python deps
• 5234: add --author arg to dolt tag command on both CLI and SQL
• 5231: go/store/tree: use constant-time root node access for last key lookup
• 5228: Quick fix for unnecessary error being logged
  We started logging an error instead of swallowing it, which is good, but we need to check if it's the ErrDatabaseNotFound error we know we might see, and not log an error if it's that expected case.
• 5225: add bats tests for information schema tables
  Added bats tests for some supported information_schema tables for specific column values that must match to MySQL information_schema result. Some tables and columns are not covered here because some has constant information such as keywords table, which is tested in GMS engine tests, and some columns are created_time or sql_mode which always varies.
• 5223: Added dolt_show_branch_databases system variable
  When set to 1, will cause a revision database for each branch to appear in show databases, information schema tables, etc.

go-mysql-server

• 1566: set utf8mb3_general_ci as information_schema database's collation
  DataGrip expects utf8mb3_general_ci as information_schema's default collation for MySQL.
• 1564: fixes handling of null set values
  Null set values were being ignored completely. This PR fixes this issue and addresses the display issue which shows an extra comma when null set values are present in multi-member set values.
  fixes: #4966
• 1562: Varchars don't error for failed IN cast to smaller varchar
  This does not address conversions between strings and non-string types, and type casting for index lookups, which look somewhat more complex in mysql.
• 1561: Small tweaks for binlog replication
  A few more small changes to support binlog replication:
  • Increasing the length of the Last_Error field returned by SHOW REPLICA STATUS so that we can accommodate longer messages (the other two error message fields had already been increased).
  • Making the @@GLOBAL.gtid_executed system var writable, so that the Dolt binlog processor can keep it updated.
  • Adding the @@sql_log_bin system var so that mysqldumps can process cleanly (mysqldump includes SET @@SESSION.SQL_LOG_BIN= 0; in the dump file when gtid_mode is enabled on the server).
• 1560: fix expression round trip bug
  scalar expressions need to round-trip for CHECK constraints, which expect to re-parse what they serialize with String().
• 1559: small fix for information_schema.parameters table
  This column name was updated on MySQL docs
• 1553: Merge join inclusion correctness
  Merge join was not principled selecting 1) monotonic filters and 2) sorting indexes that aligned with the filter of choice. We also failed to push filters referencing a single table out of join conditions.

Closed Issues

• 4966: Set values containing '' are not displayed correctly
• 5236: dolt sql ... --result-format=json fails to return a valid JSON when result set is empty
• 5158: Using --result-fomat gives an error when requesting the working head of a repository using the @@db_working system variable
• 5224: Missing author in DOLT_TAG
• 5219: Optionally SHOW SCHEMAS should show all db.branch combinations available

Latency