Merged PRs

dolt

• 6363: CLI remote connections
  Enable the connection of SQL enabled CLI commands to remote servers with addition of three flags:
  • --host - The server to connect to. Using this flag forces the use of a remote connection no matter what.
  • --port - The port to use. Defaults to 3306. No effect when --host is not used.
  • --no-tls - Disable the use of SSL. This is required to connect to your local host.
    Also special cased the sql command to allow starting without a DB. Enables connecting to an empty repo so you can CREATE DATABASE FOO.
• 6362: add warning message for unmigrated cli commands
  Adds warning message for unmigrated cli commands when they are attempted to be used remotely.
• 6288: migrates dolt merge to use sql queries
  This change updates dolt merge to use the appropriate sql engine to generate results.
  Related: #3922

go-mysql-server

• 1877: Add "Sliding Range Join" execution plan
  This is the draft implementation of the "Sliding Range Join" execution plan. This allows for more performant joins when the join condition checks that the column on one table is within a range specified by two columns on the other table.
  TODO: Elaborate in this description before making this PR not a draft.
• 1875: match notation for decimal parsing
  Follow up to dolthub/go-mysql-server#1874
  Turns out it is possible to specify floats using scientific notation, which caused some issues with conversions especially around large decimals.
• 1874: avoid scientific notation for floats/decimals
  We use some string comparison logic to find precision loss and determine if something should be float/decimal type.
  When printing very large floats, the %v format option in the fmt packages defaults to scientific notation, so like 1.234e567.
  This does not work well with our (hacky) string code.
  The %f option doesn't work very well, as it likes to append .00000.
  It appears strconv.FormatFloat does what we want, so I just picked that.
  fmt package docs: https://pkg.go.dev/fmt
  Format Float docs: https://pkg.go.dev/strconv#FormatFloat
  fix for: #6322
• 1873: Supporting mysql.help_ tables
  This first pass adds the table schemas to the mysql database for help_keyword, help_category, help_topic, and help_relation. There is no support for data in the tables yet; we're starting with just table schemas to see if that's enough for tool compatibility.
  Related to: #6308
  I still need to do acceptance testing with the exact repro in the issue linked above. I'll follow up with Max on that tomorrow to confirm. I'm hoping just supporting the schema will be enough for the FusionAuth tool, but we may end up needing to populate these tables, too.
• 1862: implementing lateral joins

vitess

• 254: Fix for using unqouted reserved words ('count' specifically) in the VALUES function
• 250: support LATERAL syntax
  syntax for: #6194

Closed Issues

Latency