Merged PRs
dolt
- 4804: A smoke test for MikroORM
- 4800: Skip empty diffs caused by non-canonicalized tuples.
At one point, we started to trim null suffixes from tuples. In versions prior to this change, tuples could have a null field at the end of the tuple. Now we always truncate the tuple.
If old versions insert rows with null values as the last column, it produces a tuple that is longer than the tuple that would be inserted by the latest version. This leads to empty diffs. - 4799: Fix missing projection on indexed table
This error only applies toDoltIndexedTable, which as far as I can tell is limited to the history tables. - 4797: allow
notandis nullclauses with dolt diff table - 4795: Table func join tests
sibling PR here: dolthub/go-mysql-server#1405 - 4785: use prefix indexes for inline string columns
Trim the ranges for prolly index lookup to match prefix lengths.
Mark prefix indexes as supported, except for text/blob prefix indexes.
Also moves IndexPrefix tests to gms.
companion pr: dolthub/go-mysql-server#1406 - 4749: go/libraries/doltcore/sqle/cluster: Add JWT authentication for peer communication to cluster replicas.
go-mysql-server
- 1405: join table functions
tests here: #4795
The main correctness risk here is if any integrator table functions do not commute/associate during join reordering. We already manually handle JSON_TABLE, but there could be others. - 1404: revert parallel ita
sister PR here: #4776 - 1403: Add tests for column truncation of bad values with INSERT IGNORE
Associated Dolt PR:
dolthub/go-mysql-server#1403
Closed Issues
- 4810: Feature Request for dolt diff
- 4791: Strange Behavior with Dolt History Table
- 4739: Segfault when querying inconsistent windows
- 4802: Default change: Reset --hard
- 4780: Strange behavior with dolt diff table
- 4793: SQL statements with INNER JOIN
Latency
| Read Tests | MySQL | Dolt | Multiple |
|---|---|---|---|
| covering_index_scan | 1.93 | 2.66 | 1.4 |
| groupby_scan | 12.3 | 16.71 | 1.4 |
| index_join | 1.16 | 4.57 | 3.9 |
| index_join_scan | 1.12 | 3.89 | 3.5 |
| index_scan | 30.26 | 53.85 | 1.8 |
| oltp_point_select | 0.15 | 0.47 | 3.1 |
| oltp_read_only | 2.97 | 8.74 | 2.9 |
| select_random_points | 0.3 | 0.75 | 2.5 |
| select_random_ranges | 0.35 | 1.12 | 3.2 |
| table_scan | 30.81 | 63.32 | 2.1 |
| types_table_scan | 69.29 | 186.54 | 2.7 |
| reads_mean_multiplier | 2.6 |
| Write Tests | MySQL | Dolt | Multiple |
|---|---|---|---|
| bulk_insert | 0.001 | 0.001 | 1.0 |
| oltp_delete_insert | 3.3 | 10.84 | 3.3 |
| oltp_insert | 1.55 | 2.66 | 1.7 |
| oltp_read_write | 5.18 | 17.01 | 3.3 |
| oltp_update_index | 1.5 | 4.91 | 3.3 |
| oltp_update_non_index | 1.44 | 5.28 | 3.7 |
| oltp_write_only | 2.26 | 8.13 | 3.6 |
| types_delete_insert | 3.25 | 13.22 | 4.1 |
| writes_mean_multiplier | 3.0 |
| Overall Mean Multiple | 2.8 |
|---|