Merged PRs

This release contains backwards incompatible changes:

• dolt merge command line tool's exit status has changed for conflicts in merges. Perviously merges which resulted in conflicts returned an exit status of 0, indicating success. This release changes the behavior to return a 1 in the event of a failed merge.

Per Dolt’s versioning policy, this is a minor version bump because these changes may impact existing applications. Please reach out to us on GitHub or Discord if you have questions or need help with any of these changes.

dolt

• 6815: Update README now that drop database is reverseable
• 6810: Prevent dolt_checkout from creating new branches in read-only databases
  Fixes: #6785
• 6774: migrate dolt pull to use sql queries
  This change updates dolt pull to use the appropriate sql engine to generate results.
  Related: #3922

go-mysql-server

• 2074: optimize min(pk) and max(pk)
  This PR adds an optimization to queries that have a MIN or MAX aggregation over a PRIMARY KEY column.
  Since indexes are already sorted (and we support a reverse iterator) we can look at the first/last row to answer queries in this form.
  The new analyzer rule, replaceAgg, converts queries of the format select max(pk) ... from ... to the equivalent select pk ... from ... order by pk limit 1. Then, we depend on an replacePkSort to apply IndexedTableAccess
  Additionally, this PR has replacePkSort optimization apply to queries that have filters (specifically those that were pushed down to IndexedTableAccess)
  There is also a some refactoring and tidying up.
  Fixes #6793
• 2073: Bug fixes for explicit DEFAULT values in INSERT statements
  Previously this was broken when DEFAULT values referred to other columns.
  Fixes #6430
  Needs more tests, but this fixes the immediate buggy behavior.
  Also fixes a related bug in MySQL: https://bugs.mysql.com/bug.php?id=112708
• 2072: support json_valid() function
  Add support for JSON_VALID(val) function
• 2070: Add routines to PrivilegeSets
  Added some Unit tests as well. This is in preparation for supporting routine grants.
• 2068: Virtual column proof of concept
  This needs a lot more tests, but this demonstrates the approach within can work well enough
• 2065: Remove redundant information_schema creation in the driver example
  In the driver's example, information_schema is duplicated.
  It is created in two places.
  1. factory.Resolve()
  2. Catalog in Analyzer in Driver.OpenConnector()
     There is no need to create it in the factory.Resolve().
     I checked databases using this:

  diff --git a/driver/_example/main.go b/driver/_example/main.go
  index 34e0580ed..adbc1a249 100644
  --- a/driver/_example/main.go
  +++ b/driver/_example/main.go
  @@ -35,6 +35,14 @@ func main() {
  rows, err := db.Query("SELECT * FROM mytable")
  must(err)
  dump(rows)
  +
  +       rows, err = db.Query("SHOW DATABASES")
  +       must(err)
  +       for rows.Next() {
  +               var db string
  +               must(rows.Scan(&db))
  +               fmt.Println("db:", db)
  +       }
  }
  func must(err error) {

Closed Issues

• 6793: No index used when calling select max(date) ...
• 6430: Column defaults do not get applied correctly with explicit DEFAULT keyword
• 6785: Read-only databases allow creating new branches using DOLT_CHECKOUT()
• 6808: Support JSON_VALID()
• 6788: Make uuid primary keys function more like auto_increment
• 6799: Make Laravel example app work with Dolt
• 6286: Fix field indexes after analysis

Latency