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 returnio.EOF
for strict lookups.
Tests: dolthub/go-mysql-server#3097
Fixes: #9523 -
9517: Migrate dolt CI commands to query database
This PR migrates thedolt 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 |
---|