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 |
---|