Merged PRs

dolt

• 7688: add alternative type check for auto_increment type validation
• 7679: dolt_verify_constraints() support for all constraint types
  The dolt_verify_constraints() stored procedure now supports verifying all constraint types: foreign keys, not null, unique, and check constraints. This new implementation reuses merge logic to calculate the constraint violations.
  Note that the dolt constraints verify CLI command next needs to be migrated to use this stored procedure so that it can also verify all constraint violation types. Until then, customers can use dolt sql -q "CALL dolt_verify_constraints(...)" if they want to verify all constraint types from the CLI.
  Doc updates: dolthub/docs#2093
  Fixes: #6320

go-mysql-server

• 2437: lowercase when looking up self referential foreign key columns
  fixes: #7700
• 2436: Making @@server_id default value match MySQL
• 2434: Fixing the default value for the binlog_checksum system variable
  Small change to make the default value of the global binlog_checksum system variable match MySQL's default value (i.e. "CRC32").
• 2433: NULL to nil
  The SHOW FIELDS/COLUMNS FROM <table> query would return the string "NULL" for Default column rather than nil.
  This mattered for Knex, which relied on it being NULL and not "NULL".
  fixes: #7692
• 2432: support Threads_connected and Threads_running status variables
  This PR adds support for Threads_connected and Threads_running status variables.
  Additionally, the local enginetest are flaking consistently in dolt ci, so those have been removed;
  we have handler tests for com_delete, com_insert, and com_update anyway.
  Related: #7646
• 2431: Setting Innodb_buffer_pool_pages_total to 1, to avoid an issue with Datadog's collector
  Datadog's metric collector errors out with a divide by zero error if the Innodb_buffer_pool_pages_total status variable is 0; changing it to 1 avoids this and allows the agent to collect metrics from Dolt.
• 2430: have status variables use go routines
  This PR changes Status Variables to update through go routines, to avoid slowing down query execution due to the mutexes present.
• 2426: use @@session.collation_server during create database ...
  This PR makes it so create database ... actually reads the @@session.collation_server variable.
  Additionally, this ensures that settings @@character_set_server sets @@collation_server and vice versa.
  Interestingly, it seems like MySQL actually ignores the global scope of these system variables, and reads the session scope instead.
  fixes #7651

vitess

• 329: Changes to binlog event creation functions
  • Exposing the Length() function in the BinlogEvent interface so calling code can access the event size present in a binlog event's header. Needed for calculating binlog file position.
  • Renaming FakeBinlogStream → BinlogStream so calling code can use it when serializing binlog events.
• 328: revert decimals
  issue: dolthub/vitess#328

Closed Issues

• 7700: self referential foreign key is case sensitive
• 7649: Questions about Dolt
• 7651: set global character_set_server not working the same way in MySQL, may lead inconsistency
• 6320: dolt verify-contraints does not check unique constraints
• 7692: Show fields returns 'NULL' (in quotes)
• 7665: Error 1105: type time.Time not supported as bind var