Skip to content

1.6.1

Compare
Choose a tag to compare
@github-actions github-actions released this 23 Jun 20:27

Merged PRs

dolt

  • 6215: fix error return code in commit
    fixes commit 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 couple SchemaTarget implementations weren't checking if the targetSchema was resolved as part of the Resolved() method. Added tests, audited the other implementations, and simplified the logic to use a new method on Schema 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 reference process.Command
    Additionally, we now get the database from the current session and use that variable.
    fix for: #6023
  • 1843: Improvements to CAST and CONVERT functions
    This PR adds support for casting/converting to FLOAT and DOUBLE types with the CAST and CONVERT functions. It also adds support for length (aka precision) and scale type constraints (e.g. CAST(1.2345 AS DECIMAL(3,2))).
    Parser support for DOUBLE and FLOAT with CAST and CONVERT: 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 with show 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