Merged PRs
dolt
- 6144: Feature: Support for cherry-picking commits that require conflict resolution
This change enablesdolt cherry-pick
andcall dolt_cherry_pick(...)
to cherry-pick commits that cause conflicts or constraint violations and to cherry-pick commits that contain schema changes. - 6143: Ripped out batch processing in SQL engine / session
This functionality is pretty fragile and requires a lot of special-casing in various places to get right, and I no longer have confidence it's correct. There are lots of statement types that work incorrectly in the primary use case (importing a large SQL script). It won't work when talking to a running server without a lot of work, and probably won't provide much benefit. So kill it. - 6142: New interface method to return underlying dolt dbs from a SqlDatabase…
… implementation (rather than type switch) - 6106: Create the batsee output directory if one doesn't exist yet.
Create the batsee output directory if one doesn't exist yet.
Also adding the output directory to .gitignore.
go-mysql-server
- 1823: Trim spaces and empty statements to the right in planbuilder.Parse
Closed Issues
- 6136:
WHERE
clause withLIKE
expression overJSON
column results in nil panic
Latency
Read Tests | MySQL | Dolt | Multiple |
---|---|---|---|
covering_index_scan | 1.96 | 2.97 | 1.5 |
groupby_scan | 12.3 | 17.01 | 1.4 |
index_join | 1.16 | 4.41 | 3.8 |
index_join_scan | 1.12 | 2.14 | 1.9 |
index_scan | 30.81 | 54.83 | 1.8 |
oltp_point_select | 0.14 | 0.46 | 3.3 |
oltp_read_only | 2.86 | 7.98 | 2.8 |
select_random_points | 0.29 | 0.75 | 2.6 |
select_random_ranges | 0.35 | 1.06 | 3.0 |
table_scan | 31.37 | 55.82 | 1.8 |
types_table_scan | 70.55 | 158.63 | 2.2 |
reads_mean_multiplier | 2.4 |
Write Tests | MySQL | Dolt | Multiple |
---|---|---|---|
bulk_insert | 0.001 | 0.001 | 1.0 |
oltp_delete_insert | 4.82 | 5.99 | 1.2 |
oltp_insert | 2.61 | 2.91 | 1.1 |
oltp_read_write | 6.43 | 15.27 | 2.4 |
oltp_update_index | 2.57 | 3.02 | 1.2 |
oltp_update_non_index | 2.61 | 3.02 | 1.2 |
oltp_write_only | 3.75 | 7.56 | 2.0 |
types_delete_insert | 4.82 | 6.55 | 1.4 |
writes_mean_multiplier | 1.4 |
Overall Mean Multiple | 2.0 |
---|