Merged PRs
dolt
- 6378: Fix misleading documentation for --host flag
- 6375: Bug fix: Commits created with
cherry-pick
should only have one parent commit
When a cherry-pick requires conflict resolution, we set MergeState metadata in the working set to mark that a merge is in progress.dolt commit
sees this metadata and incorrectly records the cherry-picked commit as a parent of the new, created commit. This PR fixes this, so that commits created by cherry-pick always have only one parent. To do this, we record an extra flag in MergeState that the current merge is a cherry-pick. - 6374: adds support for
db/branch
syntax with--use-db
global arg
Adds support fordb/branch
syntax with--use-db
global arg. - 6373: Support clone_admin grants for authenticating to remotesapi
Fixes #6354
GMS PR: dolthub/go-mysql-server#1882 - 6372: Fixed backup to require a dolt directory
Fixes #6365
go-mysql-server
- 1887: have
plan.EmptyTable
implementsql.DeletableTable
We throw an error when trying to delete from EmptyTable.
This error is partially caused by dolthub/go-mysql-server#1885
The error didn't show up in GMS as there are Exchange nodes that appear in dolt side that don't appear here. - 1886: Apply index optimization to
Offset
nodes and drop 0Offsets
This PR applies the index sort optimization to plans that look likeLIMIT(OFFSET(SORT()))
.
Additionally, this PR dropsOFFSET
nodes that start at 0, as they don't change the output.
Fix for: #6347 - 1885: have
plan.EmptyTable
implementsql.Updatable
interface
In order to not throwtable doesn't support UPDATE
error, theEmptyTable
node should implement the Updatable interface.
Additionally, there are other private noop iterators to prevent nil panics.
Fix for: #5397 - 1884: Fix data race in processlist map
Do a deep copy of maps and any nested maps to prevent concurrent read/write access.
Fix for: #6332 - 1882: Add dynamic privilege CLONE_ADMIN
Closed Issues
- 6351: Left pad hex literals that aren't even lengths
- 6379: Panic due to invalid cast
- 6354: Support giving SQL users grants to remotesapi
- 6347: Query with OFFSET does not use Index
- 5397: error updating table with impossible where clause
- 6365: segmentation fault while try to create a local backup in a dolthub/dolt-sql-server:1.7.5 docker image
Latency
Read Tests | MySQL | Dolt | Multiple |
---|---|---|---|
covering_index_scan | 2.07 | 3.02 | 1.5 |
groupby_scan | 13.22 | 18.28 | 1.4 |
index_join | 1.25 | 4.74 | 3.8 |
index_join_scan | 1.21 | 2.26 | 1.9 |
index_scan | 32.53 | 58.92 | 1.8 |
oltp_point_select | 0.14 | 0.46 | 3.3 |
oltp_read_only | 2.66 | 8.13 | 3.1 |
select_random_points | 0.31 | 0.78 | 2.5 |
select_random_ranges | 0.37 | 1.14 | 3.1 |
table_scan | 32.53 | 58.92 | 1.8 |
types_table_scan | 75.82 | 173.58 | 2.3 |
reads_mean_multiplier | 2.4 |
Write Tests | MySQL | Dolt | Multiple |
---|---|---|---|
bulk_insert | 0.001 | 0.001 | 1.0 |
oltp_delete_insert | 4.65 | 6.09 | 1.3 |
oltp_insert | 2.39 | 2.91 | 1.2 |
oltp_read_write | 5.99 | 15.55 | 2.6 |
oltp_update_index | 2.39 | 3.02 | 1.3 |
oltp_update_non_index | 2.39 | 2.97 | 1.2 |
oltp_write_only | 3.49 | 7.56 | 2.2 |
types_delete_insert | 4.49 | 6.79 | 1.5 |
writes_mean_multiplier | 1.5 |
Overall Mean Multiple | 2.0 |
---|