github dolthub/dolt v1.57.0
1.57.0

latest releases: v1.59.4, v1.59.3, v1.59.2...
one month ago

Backwards Incompatible Changes

This version introduces a change to the dolt ci system tables that breaks import and export. Run the following command to update your tables:
dolt sql -q "alter table dolt_ci_workflow_saved_query_step_expected_row_column_results rename column expected_column_row_comparison_type to expected_row_count_comparison_type;"

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.

Merged PRs

dolt

  • 9527: dolt_commit and dolt_add to target branch

    Fixes: #9524

  • 9526: Update GC docs to have correct max for archive level
    Documentation bug. We have tests to ensure you can't specify --archive-level 2
    Fixes: #9521

  • 9525: return io.EOF for empty strict lookups
    When there is no lookup key/value, we should return io.EOF for strict lookups.
    Tests: dolthub/go-mysql-server#3097
    Fixes: #9523

  • 9517: Migrate dolt CI commands to query database
    This PR migrates the dolt CI subcommands to use SQL queries instead of directly modifying the database.
    It also fixes an existing panic when you try to run the commands while a server is running.
    There are several other small changes, fixing some typos and cleaning up functions.

go-mysql-server

  • 3097: test aggregates over indexes with false filter
  • 3095: Convert SetType to strings
    Fixes most of the broken tests in #9469 (skipping tests related to #9510 and #9511)
    also fixes #9473
  • 3091: sql/types: JSONWrapper: Thread Context on some methods on JSON-related types, such as ToInterface and Compare.

Closed Issues

  • 9523: SELECT COUNT WHERE query that should return zero results instead hangs indefinitely
  • 9524: Calling dolt specific procedures on another branch
  • 9521: "dolt gc --archive-level=" is missing 2nd archive level

Performance

Read Tests MySQL Dolt Multiple
covering_index_scan 1.93 0.68 0.35
groupby_scan 13.46 19.65 1.46
index_join 1.47 2.48 1.69
index_join_scan 1.44 1.44 1.0
index_scan 34.33 31.37 0.91
oltp_point_select 0.2 0.28 1.4
oltp_read_only 3.75 5.37 1.43
select_random_points 0.35 0.61 1.74
select_random_ranges 0.38 0.63 1.66
table_scan 34.33 34.33 1.0
types_table_scan 75.82 130.13 1.72
reads_mean_multiplier 1.31
Write Tests MySQL Dolt Multiple
oltp_delete_insert 8.28 6.55 0.79
oltp_insert 4.1 3.25 0.79
oltp_read_write 9.06 11.65 1.29
oltp_update_index 4.18 3.3 0.79
oltp_update_non_index 4.18 3.25 0.78
oltp_write_only 5.28 6.55 1.24
types_delete_insert 8.43 6.91 0.82
writes_mean_multiplier 0.93
TPC-C TPS Tests MySQL Dolt Multiple
tpcc-scale-factor-1 95.32 39.2 2.43
tpcc_tps_multiplier 2.43
Overall Mean Multiple 1.56

Don't miss a new dolt release

NewReleases is sending notifications on new releases.