Tämä on vanhempi versio. Uusin versio on 2.6.2. Dolt 2.6.2 · Julkaistu:
Asennustiedostot 1.50.7
| Arkkitehtuuri | Tyyppi | Laajuus | Tiedostokoko | Lataus | SHA256 |
|---|---|---|---|---|---|
| 64-bittinen | MSI · en-US | Kaikki käyttäjät | — | github.com | VirusTotal |
Linkki ja SHA256-tiiviste ovat peräisin Windows Package Managerin yhteisön manifestista. Vertaa ladatun tiedoston tiivistettä ennen kuin suoritat sen.
Muutosloki
Merged PRs
dolt
go-mysql-server
- 2898: [memo] variable to disable merge join
Use SET @@GLOBAL.disable_merge_join = 1 to prevent join planning from every selecting a merge join. There will always be HASH_JOIN and INNER_JOIN alternatives.
- 2896: support for INSERT .. RETURNING, a postgres extension
- 2895: Bug fix: resolve column default expressions for ALTER COLUMN nodes
When building plan nodes to handle altering a column's nullability or type, without respecifying the full column definition, the built node should ensure any column default expressions are resolved.
This originally showed up as a panic in Doltgres, because Doltgres' TypeSanitzer found the UnresolvedColumnDefault instance and tried to invoke operations on it.
Note that it's not currently possible to trigger this issue with Dolt or GMS because MySQL has a more limited syntax than Postgres for altering a column without respecfiying its full column definition, and Dolt/GMS does not support that syntax currently (e.g. ALTER TABLE t ALTER COLUMN SET VISIBLE).
Closed Issues
Performance
─────────────────────┬─────┬──────┬────────
Read Tests │MySQL│Dolt │Multiple
─────────────────────┼─────┼──────┼────────
covering_index_scan │1.89 │0.67 │0.35
─────────────────────┼─────┼──────┼────────
groupby_scan │13.7 │17.95 │1.31
─────────────────────┼─────┼──────┼────────
index_join │1.5 │2.43 │1.62
─────────────────────┼─────┼──────┼────────
index_join_scan │1.44 │1.42 │0.99
─────────────────────┼─────┼──────┼────────
index_scan │34.95│29.72 │0.85
─────────────────────┼─────┼──────┼────────
oltp_point_select │0.18 │0.26 │1.44
─────────────────────┼─────┼──────┼────────
oltp_read_only │3.49 │5.28 │1.51
─────────────────────┼─────┼──────┼────────
select_random_points │0.34 │0.6 │1.76
─────────────────────┼─────┼──────┼────────
select_random_ranges │0.37 │0.63 │1.7
─────────────────────┼─────┼──────┼────────
table_scan │34.95│31.37 │0.9
─────────────────────┼─────┼──────┼────────
types_table_scan │75.82│114.72│1.51
─────────────────────┼─────┼──────┼────────
reads_mean_multiplier│ │ │1.27
─────────────────────┴─────┴──────┴────────
──────────────────────┬─────┬─────┬────────
Write Tests │MySQL│Dolt │Multiple
──────────────────────┼─────┼─────┼────────
oltp_delete_insert │8.9 │6.32 │0.71
──────────────────────┼─────┼─────┼────────
oltp_insert │4.1 │3.13 │0.76
──────────────────────┼─────┼─────┼────────
oltp_read_write │9.06 │11.45│1.26
──────────────────────┼─────┼─────┼────────
oltp_update_index │4.18 │3.19 │0.76
──────────────────────┼─────┼─────┼────────
oltp_update_non_index │4.18 │3.07 │0.73
──────────────────────┼─────┼─────┼────────
oltp_write_only │5.77 │6.32 │1.1
──────────────────────┼─────┼─────┼────────
types_delete_insert │8.43 │6.67 │0.79
──────────────────────┼─────┼─────┼────────
writes_mean_multiplier│ │ │0.87
──────────────────────┴─────┴─────┴────────
───────────────────┬─────┬─────┬────────
TPC-C TPS Tests │MySQL│Dolt │Multiple
───────────────────┼─────┼─────┼────────
tpcc-scale-factor-1│96.45│40.01│2.41
───────────────────┼─────┼─────┼────────
tpcc_tps_multiplier│ │ │2.41
───────────────────┴─────┴─────┴────────
─────────────────────┬────
Overall Mean Multiple│1.52
─────────────────────┴────
