Merged PRs
dolt
- 4875: Changes to schema instantiation
Fix for #4862
Changes the way we instantiate schema.Schema in Dolt. In the past, we've had a couple bugs that have been caused by codepaths that build new schema objects. We've accidentally dropped primary key ordinals twice before and in #4862 we dropped indexes, checks, and collations. - 4873: use range instead of point lookups for non-unique indexes
fix for: #4861
tests here: dolthub/go-mysql-server#1425
go-mysql-server
- 1426: Have JSONDocument implement driver.Valuer
- 1425: tests for non-unique indexes over keyless tables
Non-unique indexes work as expected for in-memory tables, but there were no tests.
companion pr: #4873
tests for: #4861
Closed Issues
Latency
| Read Tests | MySQL | Dolt | Multiple |
|---|---|---|---|
| covering_index_scan | 2.07 | 2.97 | 1.4 |
| groupby_scan | 12.98 | 18.28 | 1.4 |
| index_join | 1.27 | 5.0 | 3.9 |
| index_join_scan | 1.21 | 4.25 | 3.5 |
| index_scan | 32.53 | 59.99 | 1.8 |
| oltp_point_select | 0.16 | 0.54 | 3.4 |
| oltp_read_only | 3.13 | 9.91 | 3.2 |
| select_random_points | 0.32 | 0.83 | 2.6 |
| select_random_ranges | 0.37 | 1.27 | 3.4 |
| table_scan | 33.12 | 66.84 | 2.0 |
| types_table_scan | 74.46 | 204.11 | 2.7 |
| reads_mean_multiplier | 2.7 |
| Write Tests | MySQL | Dolt | Multiple |
|---|---|---|---|
| bulk_insert | 0.001 | 0.001 | 1.0 |
| oltp_delete_insert | 3.36 | 10.65 | 3.2 |
| oltp_insert | 1.55 | 3.07 | 2.0 |
| oltp_read_write | 5.47 | 18.61 | 3.4 |
| oltp_update_index | 1.61 | 5.0 | 3.1 |
| oltp_update_non_index | 1.55 | 5.18 | 3.3 |
| oltp_write_only | 2.52 | 8.74 | 3.5 |
| types_delete_insert | 3.55 | 10.84 | 3.1 |
| writes_mean_multiplier | 2.8 |
| Overall Mean Multiple | 2.7 |
|---|