Merged PRs
dolt
- 7877: keep
sql.Schema
for conflicts table schema
Previously, we would create a new schema ofNomStringKind
for every column. Now, we just reuse the underlying sql.Schema.
#7874 - 7876: Improve error messages for CLI commands when a sql-server is running
Related to #7873
Resolves #7875 - 7866: update release process for new config refactor
- 7864: move config
- 7862: Bug fix:
sql-server
should initialize persisted global vars
The local config store (.dolt/config.json
) can store persisted global variable values, but when--data-dir
is used when starting asql-server
, the local configuration doesn't get loaded properly. - 7860: Bug fix: load local config when using
--data-dir
When using the--data-dir
flag to work on a Dolt directory outside of the current working directory, the local configuration in the Dolt directory wasn't getting correctly loaded. This change evaluates the--data-dir
parameter earlier, so that the first time we load the Dolt environment, we can pass the data directory and get the local configuration loaded correctly. - 7858: [nbs] safer peek root hash record
- 7848: Added additional function to RootValue
This just adds a function to theRootValue
for special merge logic, which is used by Doltgres. - 7846: [dsess] session trigger cache
go-mysql-server
- 2499: fix
LIKE NULL
edge case
This PR fixes an edge case whereSELECT <str> LIKE NULL
should returnNULL
instead offalse
. - 2497: trim whitespace when converting strings to numbers
fixes #7854 - 2495: fix panic in
VALUES
constructor
When the number of rows in a... VALUES ROW(...), ROW(...)
statement were not equal, we would throw a panic.
This PR also unskips some tests that are now fixed.
Companion PR: #6849
fixes: #6849 - 2494: Replace count star also matches single column pk
- 2493: Implement status variables for
Slow_queries
,Max_used_connections
,Com_select
, andConnections
Adds support for four new status variables:- Slow_queries
- Max_used_connections
- Com_select
- Connections
Note thatConnections
currently only reports the successful connection attempts, but MySQL includes all connection attempts in that status variable. To capture the failed attempts, we'll need to expose that information from the Vitess layer.
Also removes a mutex that was covering the whole scope over all status variables. Now that each individual status variable has a value that uses anatomic
instance, we don't need to synchronize at a larger scope.
Related to #7646
- 2492: skip source values analyze when it only contains simple types
vitess
- 345: parse type aliases in cast
add support for statements like:select cast(<str> as character)
select cast(<str> as double precision)
select cast(<str> as read)
- 344: make
row
optional in VALUES constructor and insert statement
This PR adds additional syntax support for VALUE constructor.
fixes #6849
fixes #7853 - 338: Add a schema qualifier to table names
Closed Issues
- 7873: Running sql-server from an empty state make inconsistent repository
- 7874: Failed to write conflicts table
- 7875: Confusing error messages when using Dolt CLI from within a running Dolt sql-server directory
- 7854: trim whitespace when casting from string
- 7853: make
ROW
keyword optional inVALUES
statement - 6849: support
INSERT INTO ... (VALUES ROW(...))
statement - 7845: Make sure deleting a branch behaves similarly to
drop database
Performance
Read Tests | MySQL | Dolt | Multiple |
---|---|---|---|
covering_index_scan | 2.07 | 3.02 | 1.5 |
groupby_scan | 13.22 | 17.63 | 1.3 |
index_join | 1.34 | 5.18 | 3.9 |
index_join_scan | 1.27 | 2.22 | 1.7 |
index_scan | 34.33 | 54.83 | 1.6 |
oltp_point_select | 0.17 | 0.51 | 3.0 |
oltp_read_only | 3.36 | 8.43 | 2.5 |
select_random_points | 0.32 | 0.8 | 2.5 |
select_random_ranges | 0.39 | 0.95 | 2.4 |
table_scan | 34.33 | 55.82 | 1.6 |
types_table_scan | 73.13 | 137.35 | 1.9 |
reads_mean_multiplier | 2.2 |
Write Tests | MySQL | Dolt | Multiple |
---|---|---|---|
oltp_delete_insert | 7.98 | 6.67 | 0.8 |
oltp_insert | 3.75 | 3.25 | 0.9 |
oltp_read_write | 8.28 | 15.83 | 1.9 |
oltp_update_index | 3.82 | 3.49 | 0.9 |
oltp_update_non_index | 3.82 | 3.43 | 0.9 |
oltp_write_only | 5.28 | 7.56 | 1.4 |
types_delete_insert | 7.56 | 7.56 | 1.0 |
writes_mean_multiplier | 1.1 |
TPC-C TPS Tests | MySQL | Dolt | Multiple |
---|---|---|---|
tpcc-scale-factor-1 | 101.35 | 22.45 | 4.9 |
tpcc_tps_multiplier | 4.9 |
Overall Mean Multiple | 2.73 |
---|