Merged PRs

dolt

• 8677: parse user vars as interface{} instead of always string The variable defined for the YAML Marshaller to write user variables to was defined as a map[string]string, which caused all variables to be read as a string even when they weren't quoted. Changing it to a map[string]interface{} fixes that. fixes: https://github.com/dolthub/dolt/issues/8672
• 8675: chore: use errors.New to replace fmt.Errorf with no parameters use errors.New to replace fmt.Errorf with no parameters
• 8674: [stats] persist schema hashes for purging We previously would flush stats when an active server detected schema changes, but the same problem affects initializing a server's stats after offline table alters. The prototype here uses tags to persist schema hashes so that we detect differences between stored and present table changes. Additional improvements to debug logging and error handling. Fixes a separate bug related to re-initializing database statistics after a drop within the same server lifetime. Note: There are interruption points in-between detecting schema changes, deleting the schema tags, and deleting the data off disk. There is also an interruption point between writing a schema tag and writing the associated data. I've tried structuring the orderings so that the worst-case scenario is we have to do repeated stats collection work:
  • stats data is only ever written after an associated schema tag is written
  • we delete the tags before deleting data, and missing tags indicates invalid data So an interrupted delete will continue to delete after the process is picked up. And an interrupted write will be missed and have to be recollected.
• 8673: fix panic for virtual columns in dolt_diff_<tbl> This PR fixes the panic when attempting to view a diff on a table with virtual generated columns by just skipping over the values. Ideally, we'd be able to resolve the generated column values themselves and show the diff, but that is not near at hand. Fixes: https://github.com/dolthub/dolt/issues/8665
• 8669: Add BATS tests to cover caching_sha2_password use with mysql client
• 8667: README update Added link to blog post with more info on the removal of mysql_native_password authentication in MySQL-9.0 and how to use Dolt's new support for caching_sha2_password authentication.
• 8650: Enable larger statements for dolt_procedures Increase the supported stored procedure length from 1K to 8K.

go-mysql-server

• 2793: Revert byte copying optimization
• 2792: Fix the warning checks in enginetest to be more strict Previously if an error was expected but none was produced the test would pass.
• 2791: Properly cast ENUMs to TEXT for CASE and CONVERT statements fixes: https://github.com/dolthub/dolt/issues/8598
• 2787: Enable support for caching_sha2_password auth This change enables users configured with the caching_sha2_password auth plugin to authenticate to a running SQL server. The default authentication plugin is still mysql_native_password, but users can opt-in to caching_sha2_password by creating a user and explicitly specifying the auth plugin. Note that the caching_sha2_password auth plugin requires running the SQL server with a certificate so that TLS connections can be established. Depends on: https://github.com/dolthub/vitess/pull/390 Related to: https://github.com/dolthub/dolt/issues/8496

Closed Issues

• 8598: enum conversion type has unexpected results
• 8672: Can't set a numeric session variable using user_session_vars section of config.yaml
• 8592: Make Dolt work with mydumper
• 8665: Panic on dolt_diff_* with generated column
• 8496: Support caching_sha2_password authentication method
• 8642: Getting error for select * from dolt_procedures for repo used in dolt docs