Merged PRs
dolt
- 5173: Fix 3 merge bugs related to secondary indexes
- The schema of the dolt_constraint_violations table was incorrect.
- Unique key violations were being thrown by merge even if the index key included a null value.
- The primary key was being built incorrectly for the unique key violations generated by merge. Previously it was assumed that the primary index's key was a suffix of the secondary index's key. This is not the case when the index key includes a column in the primary key.
Closed Issues
Latency
| Read Tests | MySQL | Dolt | Multiple |
|---|---|---|---|
| covering_index_scan | 1.93 | 2.76 | 1.4 |
| groupby_scan | 12.3 | 16.41 | 1.3 |
| index_join | 1.16 | 4.65 | 4.0 |
| index_join_scan | 1.12 | 3.96 | 3.5 |
| index_scan | 30.26 | 53.85 | 1.8 |
| oltp_point_select | 0.15 | 0.49 | 3.3 |
| oltp_read_only | 2.97 | 8.58 | 2.9 |
| select_random_points | 0.3 | 0.77 | 2.6 |
| select_random_ranges | 0.35 | 1.16 | 3.3 |
| table_scan | 30.81 | 63.32 | 2.1 |
| types_table_scan | 69.29 | 189.93 | 2.7 |
| reads_mean_multiplier | 2.6 |
| Write Tests | MySQL | Dolt | Multiple |
|---|---|---|---|
| bulk_insert | 0.001 | 0.001 | 1.0 |
| oltp_delete_insert | 2.81 | 16.71 | 5.9 |
| oltp_insert | 1.37 | 3.68 | 2.7 |
| oltp_read_write | 5.18 | 26.2 | 5.1 |
| oltp_update_index | 1.52 | 8.13 | 5.3 |
| oltp_update_non_index | 1.44 | 8.9 | 6.2 |
| oltp_write_only | 2.22 | 15.27 | 6.9 |
| types_delete_insert | 2.91 | 18.28 | 6.3 |
| writes_mean_multiplier | 4.9 |
| Overall Mean Multiple | 3.6 |
|---|