Merged PRs
dolt
- 6544: Moved AutoIncrementGetter to an internal interface
Fixes #6543.
Companion to dolthub/go-mysql-server#1956.
TheAutoIncrementGetterwas moved from the editor to the table years ago, however the GMS interface remained. We had an internal reliance on the interface, even though GMS does not use it at all, so the interface has been moved to be an internal interface only. This fixes the panic as seen in the issue.
go-mysql-server
- 1950: Honor precision for datetime and timestamp, default to 0 (no fractional seconds)
Closed Issues
- 6543: Fulltext and autoincrement together causes Panic
- 6257: Correctness Issue with Exists subquery
- 6394: Valid join query erroneously reported as ambiguous
- 5789: JOIN USING support
Latency
| Read Tests | MySQL | Dolt | Multiple |
|---|---|---|---|
| covering_index_scan | 2.07 | 2.91 | 1.4 |
| groupby_scan | 13.22 | 17.95 | 1.4 |
| index_join | 1.27 | 4.74 | 3.7 |
| index_join_scan | 1.21 | 2.3 | 1.9 |
| index_scan | 32.53 | 57.87 | 1.8 |
| oltp_point_select | 0.14 | 0.45 | 3.2 |
| oltp_read_only | 2.71 | 7.98 | 2.9 |
| select_random_points | 0.31 | 0.83 | 2.7 |
| select_random_ranges | 0.37 | 1.18 | 3.2 |
| table_scan | 33.12 | 57.87 | 1.7 |
| types_table_scan | 74.46 | 167.44 | 2.2 |
| reads_mean_multiplier | 2.4 |
| Write Tests | MySQL | Dolt | Multiple |
|---|---|---|---|
| bulk_insert | 0.001 | 0.001 | 1.0 |
| oltp_delete_insert | 4.41 | 5.67 | 1.3 |
| oltp_insert | 2.14 | 2.76 | 1.3 |
| oltp_read_write | 5.88 | 15.0 | 2.6 |
| oltp_update_index | 2.26 | 2.86 | 1.3 |
| oltp_update_non_index | 2.48 | 2.81 | 1.1 |
| oltp_write_only | 3.19 | 7.3 | 2.3 |
| types_delete_insert | 4.49 | 6.09 | 1.4 |
| writes_mean_multiplier | 1.5 |
| Overall Mean Multiple | 2.0 |
|---|