Skip to content

1.40.2

Compare
Choose a tag to compare
@github-actions github-actions released this 14 Jun 23:02

Merged PRs

dolt

  • 7963: Create pg_catalog by default for Doltgres
    This makes it such that pg_catalog is created by default when Doltgres is using Dolt. In addition, adds a new function to hook into schema functionality.

go-mysql-server

vitess

  • 354: support VALUES statement
    This PR add syntax support for VALUES statment as an alias for SELECT * FROM ....
    We are still missing SELECT (VALUES ...) (support for values as a select_expression).
    syntax for #8012
  • 353: allow backticks in system and user variables
    This PR allows the use of backticks in system and user variables.
    We are more lenient than MySQL when it comes to backticks in set statements.
    For example, we allow set @abc.def = 10, while MySQL throws an error.
    This is because we treat this as a qualified column identifer and automatically strip the backticks.
    test bump dolthub/go-mysql-server#2548
    fixes #8010

Closed Issues

  • 8012: VALUES statement not supported

Performance

Read Tests MySQL Dolt Multiple
covering_index_scan 2.07 2.81 1.4
groupby_scan 13.46 17.32 1.3
index_join 1.37 5.37 3.9
index_join_scan 1.27 10.84 8.5
index_scan 34.95 53.85 1.5
oltp_point_select 0.18 0.46 2.6
oltp_read_only 3.49 7.56 2.2
select_random_points 0.34 0.75 2.2
select_random_ranges 0.39 0.9 2.3
table_scan 34.95 54.83 1.6
types_table_scan 75.82 137.35 1.8
reads_mean_multiplier 2.7
Write Tests MySQL Dolt Multiple
oltp_delete_insert 7.98 6.09 0.8
oltp_insert 3.82 3.02 0.8
oltp_read_write 8.58 13.95 1.6
oltp_update_index 3.89 3.07 0.8
oltp_update_non_index 3.89 3.02 0.8
oltp_write_only 5.37 6.32 1.2
types_delete_insert 7.7 6.67 0.9
writes_mean_multiplier 1.0
TPC-C TPS Tests MySQL Dolt Multiple
tpcc-scale-factor-1 99.66 26.16 3.8
tpcc_tps_multiplier 3.8
Overall Mean Multiple 2.50