This release contains backwards incompatible changes:
- The behavior of the
filter-branchcommand has changed. It requires a new option flag,--query. It no longer ignores some errors unless you provide the new--continueflag. Its output has been altered.
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
- 6936: More flexibility for
filter-branchcommand
Fixes #6895
The command can now process multiple queries by default, and will ignore errors executing them with a--continueflag. This is a breaking change:- Previously, certain errors were detected and ignored by default. Now this behavior is controlled by the --continue flag.
- Previously, the query to execute was specified as an argument. Now it's a flag,
--query, or can be read via STDIN.
- 6932: /.github/scripts/performance-benchmarking/get-mysql-dolt-job-json.sh: revert precision 3
- 6923: fix empty Field in
prolly.Range
When creatingprolly.Ranges forpointLookupPartitions, we never set the Field member variable. As a result, point lookups wouldn't return correctly.
This impacts specifically keyless multi-arity lookups. Indexes on regular tables and single key keyless lookups were not impacted by this bug.
Companion PR: dolthub/go-mysql-server#2118
go-mysql-server
- 2120: Prevent virtual columns from being used in primary keys
Also tests for stored generated columns in primary keys - 2116: Grant Options privs need the AdminOnly treatment too
This addresses a gap discovered while writing dolt tests - Grant Option on procedures is not currently validated correctly, resulting in only super users being able to set grants on procedures. This should address that. - 2115: Fix ExistsSubquery with functions
OurhoistSelectExistsoptimization incorrectly generatesSemiJoinswhen there are OuterScope column references in projections in subqueries. In the future, a possible optimization could be to haveSemiLateralJoinsthat properly grant this visibility.
Also contains small refactoring and extra debug information forcoalescefunction.
Fixes one of the queries here: #6898
Closed Issues
Latency
| Read Tests | MySQL | Dolt | Multiple |
|---|---|---|---|
| covering_index_scan | 2.11 | 2.76 | 1.3 |
| groupby_scan | 13.22 | 17.32 | 1.3 |
| index_join | 1.32 | 5.0 | 3.8 |
| index_join_scan | 1.25 | 2.18 | 1.7 |
| index_scan | 33.72 | 55.82 | 1.7 |
| oltp_point_select | 0.17 | 0.42 | 2.5 |
| oltp_read_only | 3.36 | 7.43 | 2.2 |
| select_random_points | 0.32 | 0.69 | 2.2 |
| select_random_ranges | 0.39 | 0.94 | 2.4 |
| table_scan | 34.33 | 55.82 | 1.6 |
| types_table_scan | 74.46 | 161.51 | 2.2 |
| reads_mean_multiplier | 2.1 |
| Write Tests | MySQL | Dolt | Multiple |
|---|---|---|---|
| bulk_insert | 0.0 | 0.0 | 0.0 |
| oltp_delete_insert | 7.98 | 6.79 | 0.9 |
| oltp_insert | 3.75 | 3.36 | 0.9 |
| oltp_read_write | 8.28 | 14.73 | 1.8 |
| oltp_update_index | 3.82 | 3.36 | 0.9 |
| oltp_update_non_index | 3.82 | 3.3 | 0.9 |
| oltp_write_only | 5.28 | 7.56 | 1.4 |
| types_delete_insert | 7.7 | 7.17 | 0.9 |
| writes_mean_multiplier | 1.0 |
| Overall Mean Multiple | 1.6 |
|---|