Merged PRs
dolt
- 6215: fix error return code in commit
fixescommit
to return an error when there is an error processing result rows - 6212: Add
dolt_schema_diff
table function
dolt_schema_diff
will return the schema diffs between refs and optionally will filter those changes to a specific table.
This is a new table function that provides us with the information we need for dolt diff.
The original PR for this change was accidentally merged too early. The comments from that PR have been integrated into this change. - 6203: Bug fixes for resolving the default DB name to the correct branch, was broken in several cases
go-mysql-server
- 1847: Fix TargetSchema.Resolved() to check targetSchema column default expressions
A coupleSchemaTarget
implementations weren't checking if thetargetSchema
was resolved as part of theResolved()
method. Added tests, audited the other implementations, and simplified the logic to use a new method onSchema
to check that column default expressions are resolved.
Fixes: #6206
Dolt CI Run: #6213 - 1846: update
information_schema.processlist
to correctly display status of processes and databases
We used to hardcode"Query"
, now we referenceprocess.Command
Additionally, we now get the database from the current session and use that variable.
fix for: #6023 - 1843: Improvements to
CAST
andCONVERT
functions
This PR adds support for casting/converting toFLOAT
andDOUBLE
types with theCAST
andCONVERT
functions. It also adds support for length (aka precision) and scale type constraints (e.g.CAST(1.2345 AS DECIMAL(3,2))
).
Parser support forDOUBLE
andFLOAT
withCAST
andCONVERT
: dolthub/vitess#249
Fixes: #5835
Closed Issues
- 6206: Panic when altering a column in a table where another column uses a function in a default expression
- 6183: dolt is hitting a sql lock when trying to start after shutting down
- 5835: CAST not fully supported
- 6023:
information_schema.processlist
result is inconsistent withshow processlist
Latency
Read Tests | MySQL | Dolt | Multiple |
---|---|---|---|
covering_index_scan | 1.93 | 2.71 | 1.4 |
groupby_scan | 12.3 | 16.71 | 1.4 |
index_join | 1.18 | 4.33 | 3.7 |
index_join_scan | 1.14 | 2.14 | 1.9 |
index_scan | 30.26 | 55.82 | 1.8 |
oltp_point_select | 0.14 | 0.46 | 3.3 |
oltp_read_only | 2.86 | 8.13 | 2.8 |
select_random_points | 0.29 | 0.75 | 2.6 |
select_random_ranges | 0.35 | 1.08 | 3.1 |
table_scan | 30.81 | 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.49 | 5.67 | 1.3 |
oltp_insert | 2.18 | 2.76 | 1.3 |
oltp_read_write | 6.09 | 15.27 | 2.5 |
oltp_update_index | 2.26 | 2.91 | 1.3 |
oltp_update_non_index | 2.26 | 2.81 | 1.2 |
oltp_write_only | 3.25 | 7.43 | 2.3 |
types_delete_insert | 4.57 | 6.32 | 1.4 |
writes_mean_multiplier | 1.5 |
Overall Mean Multiple | 2.0 |
---|