Merged PRs
dolt
- 4555: update Dockerfile on release
- 4554: go/doltcore/schema: Remove schema.CollCollection.GetAtIndex() in favor of GetByIndex
- 4550: get next port number if random port is in use
fixed in bats testing:- if PORT in use, get the next unused PORT number when starting a sql-server
- kill a process only if it's still running when stopping a sql-server
- 4542: dolt support for
MULTIPOLYGON
Fix for: #3638 - 4538: add list of
dolt configvariables to command description
Supported config variables are added to long description ofdolt config, which can be shown with--helpflag.
go-mysql-server
- 1336: can't alter blob, json, and geometry columns when other defaults are defined
fix for: #4543
Note: the syntax here is actually invalid in MySQL? - 1334: multipolygon support
- 1333: prevent creating views with same name as existing table
also fix for: #4549 - 1330: add support for
MultiPolygonpt. 3
Part 7 of fix for: #3638
TODO: rebase to main, left as a merge tojames/mpoly2for better readability
Changes:- these functions now work with
MultiPolygon ST_ASGEOJSONST_GEOMFROMGEOJSON- lots of tests
- these functions now work with
- 1327: add support for
MultiPolygonpt. 2
Part 6 of fix for: #3638
TODO: rebase to main, left as a merge tojames/mpolyfor better readability
Changes:- these functions now work with
MultiPolygon ST_ASWKTST_GEOMFROMTEXT- added engine tests
- these functions now work with
- 1324: add support for
MultiPolygonpt. 1
Part 5 of fix for: #3638
TODO: rebase to main, left as a merge tojames/mline3for better readability
Changes:- contains small fixes to
multilinestringcomments and allocation length - these functions now work with
MultiPolygon MULTIPOLYGONST_ASWKBST_GEOMFROMWKBST_MPOLYFROMWKBST_MULTIPOLYGEOMFROMWKB- added engine tests
- contains small fixes to
- 1321: add support for
MultiLineStringpt. 1
Part 2 of fix for: #3638
Changes:- small copy-pasta comment fixes
- adding multilinestring type and structs
MultiLineStringsupport for these sql functionsST_MULTILINESTRINGFROMWKBST_MULTILINESTRINGFROMTEXTST_MLINESTRINGFROMWKBST_MLINESTRINGFROMTEXTST_GEOMFROMWKBST_ASWKBST_ASTEXT
Closed Issues
- 4543:
alter table t alter column set default c1 ('[]')fails withTEXT, BLOB, GEOMETRY, and JSON types may only have expression default values - 4549: views with same name as table, causes inf recursion
- 4430: Feature request: add a progress bar to
dolt sql < file.sqlthat shows the progress of a SQL load
Latency
| Read Tests | MySQL | Dolt | Multiple |
|---|---|---|---|
| covering_index_scan | 1.93 | 2.71 | 1.4 |
| groupby_scan | 12.3 | 17.32 | 1.4 |
| index_join | 1.18 | 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.48 | 3.2 |
| oltp_read_only | 2.97 | 8.74 | 2.9 |
| select_random_points | 0.3 | 0.75 | 2.5 |
| select_random_ranges | 0.35 | 1.14 | 3.3 |
| table_scan | 30.81 | 62.19 | 2.0 |
| 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.55 | 11.45 | 3.2 |
| oltp_insert | 1.58 | 2.81 | 1.8 |
| oltp_read_write | 5.28 | 17.32 | 3.3 |
| oltp_update_index | 1.61 | 5.18 | 3.2 |
| oltp_update_non_index | 1.52 | 5.37 | 3.5 |
| oltp_write_only | 2.39 | 8.43 | 3.5 |
| types_delete_insert | 3.43 | 12.52 | 3.7 |
| writes_mean_multiplier | 2.9 |
| Overall Mean Multiple | 2.7 |
|---|