Merged PRs
dolt
- 6071: replace encoding/json with goccy/go-json for improved unmarshalling
- 6060: Test CI with automatic server connection for CLI commands.
This adds additional CI workflows that start a Dolt SQL server before running the bats tests. The dolt commands in the tests should connect to the running server instead of running their own engine.
The filelocal-remote.bats
contains a list of bats files that are not yet confirmed to work against a remote server because they contain dolt commands that haven't been migrated yet. This is a burndown list that will shrink as we migrate more commands.
go-mysql-server
- 1806: improve conversion from JsonDocument to string
- 1803: Added "utf8mb3_czech_ci" collation, fixed missing collation check for enum/set
Fixes dolthub/go-mysql-server#1801
Adds the requested collation, and fixes the panic. The panic came from an oversight when checking for a collation's implementation.enum
andset
use the collation during type creation, which occurs before we've verified the collation's implementation. The other string types do not use the collation during type creation, so we return the appropriate error as a result.
Closed Issues
- 6076: Dolt backup restore drops user
root
, prevents access to other databases. - 5936: Add
dolt table import --append
- 5662: JSON operator
->>
not supported - 1801: Creating an enum column with collation utf8_czech_ci causes panic
Latency
Read Tests | MySQL | Dolt | Multiple |
---|---|---|---|
covering_index_scan | 1.89 | 2.71 | 1.4 |
groupby_scan | 12.08 | 16.71 | 1.4 |
index_join | 1.16 | 4.25 | 3.7 |
index_join_scan | 1.1 | 2.11 | 1.9 |
index_scan | 30.26 | 54.83 | 1.8 |
oltp_point_select | 0.14 | 0.47 | 3.4 |
oltp_read_only | 2.71 | 7.98 | 2.9 |
select_random_points | 0.29 | 0.77 | 2.7 |
select_random_ranges | 0.34 | 1.08 | 3.2 |
table_scan | 30.26 | 54.83 | 1.8 |
types_table_scan | 68.05 | 158.63 | 2.3 |
reads_mean_multiplier | 2.4 |
Write Tests | MySQL | Dolt | Multiple |
---|---|---|---|
bulk_insert | 0.001 | 0.001 | 1.0 |
oltp_delete_insert | 5.0 | 6.09 | 1.2 |
oltp_insert | 2.43 | 2.97 | 1.2 |
oltp_read_write | 6.32 | 15.55 | 2.5 |
oltp_update_index | 2.52 | 3.07 | 1.2 |
oltp_update_non_index | 2.57 | 3.02 | 1.2 |
oltp_write_only | 3.55 | 7.7 | 2.2 |
types_delete_insert | 4.82 | 6.79 | 1.4 |
writes_mean_multiplier | 1.5 |
Overall Mean Multiple | 2.0 |
---|