Merged PRs

dolt

• 5147: go/store: Speed up sanity checks in nbs.Store
• 5146: go/libraries/doltcore/sqle: read_replica_database: Retry optimistic lock failures on read replica databases when updating our working set.
• 5140: go/store/nbs: store.go: Fix some races in usage of waitForGC.
• 5132: connect to remote branch not existent locally
  If the branch in the connection string is not available as local branch, try to find remote tracking branch that matches the defined branch name. If there is only one match, it creates local branch from that remote tracking branch and sets its upstream to it. If there are multiple remotes with the same branch names, it errors. For now, we assume there will not be remote name provided in the connection string, only <db_name>/<branch_name> is allowed.
• 5123: Added CALL ... AS OF
• 5114: add "create database" header to dolt dump sql files
  automatically adds CREATE DATABASE IF NOT EXISTS ...; USE db; to all dolt dump sql files, preventing errors from importing to dolt in non database directories
  fixes: #4837
• 5074: fixes for changes on info_schema tables
  Depends on dolthub/go-mysql-server#1501

go-mysql-server

• 1539: if privilegeSet is nil, return empty row for info schema tables
  • privilegeSet was nil for ld repository tests as there were no privileges granted and was trying to test on information_schema.views table.
  • the now exported method is used in ld to grant all privileges for the test user
    fixes test in https://github.com/dolthub/ld/pull/12642
• 1532: implement st_within() for Point
  Part 1/7
  This is the implementation of st_within(sql.Point(), <any geometry>).
  MySQL Reference
  The other geometry types are left as unsupported for now, to both reduce the size of the PR and because they're hard...
• 1528: Decorrelate filtered subqueries with single rel
  This decorrelates simple single relation scopes with filter expressions. Unnesting scopes can have dramatic effects on join planning. For the query that motivated this work (a changed integration query plan), latency went from 90 seconds -> 2 seconds.
  This PR uses a SelectSingleRel node to represent the folded scope, which passes through join planning before being converted back into Filter(Table) by normalizeSelectSingleRel after all rules.
• 1526: Added CALL ... AS OF
• 1501: verify and add more info schema tables
  Complete tables:
  • Fixed and verified row values for tables: TRIGGERS, CHECK_CONSTRAINTS, KEY_COLUMN_USAGE, KEY_COLUMN_USAGE, TABLE_CONSTRAINTS and SCHEMATA
  • Added REFERENTAIL_CONSTRAINTS table
    Fixed, but has missing info tables:
  • TABLES - missing columns/does not match MySQL values: avg_row_length, data_length, max_data_length, max_data_length, data_free
  • ROUTINES - missing stored functions
  • VIEWS - view_definition value does not match MySQL
    Changes:
  • added CreateViewStmt member to View definition to keep the information for algorithm, definer and security when it's created first. These are needed for information_schema.views table.
  • added PeekNextAutoIncrementValue to AutoIncrementTable interface for getting the next auto_increment value without incrementing the current value. This is implemented for both memory.Table and WritableDoltTable.

vitess

• 214: Added CALL ... AS OF
• 213: Added additional CASE form
  Forgot that there are two forms to CASE statements, so I added the missing version.

Closed Issues

• 5097: Slow importing with foreign keys
• 5108: [Feature Request] Consider branch auto-fetch on connection for replicas
• 4837: add create database header to dolt dump sql file
• 5106: Integrate pull request preview environments

Latency