Merged PRs

dolt

• 6731: Bug fix: Allow dolt_checkout() and dolt status when running in read-only mode
  The stored procedures for dolt_checkout and dolt_count_commits weren't marked as being read-only, so when run against a read-only sql-server, they resulted in an error about the database being read-only.
  Fixes: #6730
• 6720: Fixed a bug in table writers where error state wasn't being appropriately cleared
  New tests for this bug in dolthub/go-mysql-server#2035
• 6717: update maven version for ORMDockerfile
• 6108: Feature: Event execution for dolt sql-server
  Depends on: dolthub/go-mysql-server#1786

go-mysql-server

• 2035: Tests for errors during insert not fouling a session
• 2034: prevent creating trigger on view
  fixes #6432
• 2033: Add VERBOSE_ANALYZER environment variable.
  This environment variable will make the analyzer output the current optimization plan after each analyzer rule.
• 2031: UNIX_TIMESTAMP() respects session time zone
  • For UNIX_TIMESTAMP() function, it converts the time value to be in the current session TZ instead of UTC TZ before returning the final value because the initial value is parsed as in UTC TZ, which is incorrect.
  • The default value of system_time_zone global variable will be set to the system TZ instead of UTC.
• 1786: support event execution
  This PR adds event execution logic implementing EventScheduler interface in the engine.
  Notes:
  • Event Scheduler status cannot be updated at run-time.
  • Event DISABLE ON SLAVE status is not supported. It will be set to DISABLE by default.
    Corresponding Dolt changes: #6108

Closed Issues

• 6730: Read-Only databases should still allow calling dolt_checkout()
• 5498: Support CREATE EVENT statement
• 6706: Dolt sql-server hangs weirdly when used as the backing store to Altium Designer
• 6432: Prevent creating triggers on views
• 6712: unix_timestamp(date) doesn't respect a session time zone
• 4190: Stitchdata requires innodb_lock_wait_timeout be defined to connect to a Dolt database through MySQL connector
• 4477: Indexes on tables in non-current database aren't used
• 2145: SQL method to examine schema diffs
• 2395: Precision of int-typed columns lost in information schema
• 3518: Support Parquet as an output format in the -r option
• 3700: Implement dolt patch and dolt apply
• 3797: Suboptimal join query plan for TPC-C "new order" transaction
• 4304: UpdateJoins don't honor check constraints on all tables
• 5324: Old versions of dolt not available through homebrew
• 6502: Support information_schema.columns AS OF in parser
• 5996: Leak in hosted instance causing a crash

Latency