github dolthub/dolt v1.59.2
1.59.2

latest release: v1.59.3
one day ago

Merged PRs

dolt

go-mysql-server

  • 3193: Left and right joins should not be optimized into cross joins
    fixes #9782
  • 3192: fix update join with conflicting aliases
    Update joins with SubqueryAlias with TableAlias matching an outer TableAlias would result in the incorrect table getting picked when resolving Foreign Keys. Fix here is to not Inspect OpaqueNodes to avoid incorrectly overriding any aliases; they shouldn't be visible anyway.
  • 3191: Use Decimal.String() for key in hashjoin lookups
    fixes #9777
    Decimals are not hashable so we have to use Decimal.String() as a key instead.
  • 3162: Add support for VECTOR type
    This PR adds a VECTOR type to GMS. Vectors are arrays of 32-bit floats.
    It also adds several functions that take vectors as arguments, including converting vectors to and from strings, and functions for computing distances between vectors.
    Finally, it ensures that vector types work correctly when passed to existing functions (such as BIT_LENGTH, MD5, etc.)

Closed Issues

Performance

Read Tests MySQL Dolt Multiple
covering_index_scan 1.86 0.67 0.36
groupby_scan 13.7 18.61 1.36
index_join 1.5 2.43 1.62
index_join_scan 1.47 1.42 0.97
index_scan 34.33 30.26 0.88
oltp_point_select 0.21 0.28 1.33
oltp_read_only 3.82 5.37 1.41
select_random_points 0.35 0.58 1.66
select_random_ranges 0.39 0.61 1.56
table_scan 34.33 32.53 0.95
types_table_scan 75.82 127.81 1.69
reads_mean_multiplier 1.25
Write Tests MySQL Dolt Multiple
oltp_delete_insert 8.43 6.55 0.78
oltp_insert 4.18 3.25 0.78
oltp_read_write 9.22 11.87 1.29
oltp_update_index 4.25 3.3 0.78
oltp_update_non_index 4.25 3.25 0.76
oltp_write_only 5.28 6.43 1.22
types_delete_insert 8.58 6.91 0.81
writes_mean_multiplier 0.92
TPC-C TPS Tests MySQL Dolt Multiple
tpcc-scale-factor-1 93.62 39.7 2.36
tpcc_tps_multiplier 2.36
Overall Mean Multiple 1.51

Don't miss a new dolt release

NewReleases is sending notifications on new releases.