Merged PRs
dolt
- 8984: Fix schema merge bug when schema is identical with multiple indexes on the same columns
FIxes: #8975
Closed Issues
- 8975: Cannot merge branches when two indexes covers same column
- 8907: Why DOLT_DIFF_SUMMARY shows record without data change and schema change?
- 8977: Can't
select ''
Performance
| Read Tests | MySQL | Dolt | Multiple |
|---|---|---|---|
| covering_index_scan | 1.93 | 0.67 | 0.35 |
| groupby_scan | 13.22 | 17.95 | 1.36 |
| index_join | 1.47 | 2.43 | 1.65 |
| index_join_scan | 1.47 | 1.44 | 0.98 |
| index_scan | 34.33 | 30.26 | 0.88 |
| oltp_point_select | 0.18 | 0.26 | 1.44 |
| oltp_read_only | 3.49 | 5.28 | 1.51 |
| select_random_points | 0.33 | 0.6 | 1.82 |
| select_random_ranges | 0.37 | 0.62 | 1.68 |
| table_scan | 34.95 | 31.37 | 0.9 |
| types_table_scan | 75.82 | 114.72 | 1.51 |
| reads_mean_multiplier | 1.28 |
| Write Tests | MySQL | Dolt | Multiple |
|---|---|---|---|
| oltp_delete_insert | 8.9 | 6.32 | 0.71 |
| oltp_insert | 4.1 | 3.07 | 0.75 |
| oltp_read_write | 8.9 | 11.45 | 1.29 |
| oltp_update_index | 4.18 | 3.13 | 0.75 |
| oltp_update_non_index | 4.18 | 3.07 | 0.73 |
| oltp_write_only | 5.67 | 6.32 | 1.11 |
| types_delete_insert | 8.43 | 6.67 | 0.79 |
| writes_mean_multiplier | 0.88 |
| TPC-C TPS Tests | MySQL | Dolt | Multiple |
|---|---|---|---|
| tpcc-scale-factor-1 | 95.47 | 39.83 | 2.4 |
| tpcc_tps_multiplier | 2.4 |
| Overall Mean Multiple | 1.52 |
|---|