Skip to content

1.38.1
Compare
Choose a tag to compare
@github-actions github-actions released this 17 May 22:38
v1.38.1
26e1d5b

Merged PRs

dolt

  • 7877: keep sql.Schema for conflicts table schema
    Previously, we would create a new schema of NomStringKind for every column. Now, we just reuse the underlying sql.Schema.
    #7874
  • 7876: Improve error messages for CLI commands when a sql-server is running
    Related to #7873
    Resolves #7875
  • 7866: update release process for new config refactor
  • 7864: move config
  • 7862: Bug fix: sql-server should initialize persisted global vars
    The local config store (.dolt/config.json) can store persisted global variable values, but when --data-dir is used when starting a sql-server, the local configuration doesn't get loaded properly.
  • 7860: Bug fix: load local config when using --data-dir
    When using the --data-dir flag to work on a Dolt directory outside of the current working directory, the local configuration in the Dolt directory wasn't getting correctly loaded. This change evaluates the --data-dir parameter earlier, so that the first time we load the Dolt environment, we can pass the data directory and get the local configuration loaded correctly.
  • 7858: [nbs] safer peek root hash record
  • 7848: Added additional function to RootValue
    This just adds a function to the RootValue for special merge logic, which is used by Doltgres.
  • 7846: [dsess] session trigger cache

go-mysql-server

  • 2499: fix LIKE NULL edge case
    This PR fixes an edge case where SELECT <str> LIKE NULL should return NULL instead of false.
  • 2497: trim whitespace when converting strings to numbers
    fixes #7854
  • 2495: fix panic in VALUES constructor
    When the number of rows in a ... VALUES ROW(...), ROW(...) statement were not equal, we would throw a panic.
    This PR also unskips some tests that are now fixed.
    Companion PR: #6849
    fixes: #6849
  • 2494: Replace count star also matches single column pk
  • 2493: Implement status variables for Slow_queries, Max_used_connections, Com_select, and Connections
    Adds support for four new status variables:
    • Slow_queries
    • Max_used_connections
    • Com_select
    • Connections
      Note that Connections currently only reports the successful connection attempts, but MySQL includes all connection attempts in that status variable. To capture the failed attempts, we'll need to expose that information from the Vitess layer.
      Also removes a mutex that was covering the whole scope over all status variables. Now that each individual status variable has a value that uses an atomic instance, we don't need to synchronize at a larger scope.
      Related to #7646
  • 2492: skip source values analyze when it only contains simple types

vitess

  • 345: parse type aliases in cast
    add support for statements like:
    • select cast(<str> as character)
    • select cast(<str> as double precision)
    • select cast(<str> as read)
  • 344: make row optional in VALUES constructor and insert statement
    This PR adds additional syntax support for VALUE constructor.
    fixes #6849
    fixes #7853
  • 338: Add a schema qualifier to table names

Closed Issues

  • 7873: Running sql-server from an empty state make inconsistent repository
  • 7874: Failed to write conflicts table
  • 7875: Confusing error messages when using Dolt CLI from within a running Dolt sql-server directory
  • 7854: trim whitespace when casting from string
  • 7853: make ROW keyword optional in VALUES statement
  • 6849: support INSERT INTO ... (VALUES ROW(...)) statement
  • 7845: Make sure deleting a branch behaves similarly to drop database

Performance

Read Tests MySQL Dolt Multiple
covering_index_scan 2.07 3.02 1.5
groupby_scan 13.22 17.63 1.3
index_join 1.34 5.18 3.9
index_join_scan 1.27 2.22 1.7
index_scan 34.33 54.83 1.6
oltp_point_select 0.17 0.51 3.0
oltp_read_only 3.36 8.43 2.5
select_random_points 0.32 0.8 2.5
select_random_ranges 0.39 0.95 2.4
table_scan 34.33 55.82 1.6
types_table_scan 73.13 137.35 1.9
reads_mean_multiplier 2.2
Write Tests MySQL Dolt Multiple
oltp_delete_insert 7.98 6.67 0.8
oltp_insert 3.75 3.25 0.9
oltp_read_write 8.28 15.83 1.9
oltp_update_index 3.82 3.49 0.9
oltp_update_non_index 3.82 3.43 0.9
oltp_write_only 5.28 7.56 1.4
types_delete_insert 7.56 7.56 1.0
writes_mean_multiplier 1.1
TPC-C TPS Tests MySQL Dolt Multiple
tpcc-scale-factor-1 101.35 22.45 4.9
tpcc_tps_multiplier 4.9
Overall Mean Multiple 2.73
Assets 10