Merged PRs
dolt
go-mysql-server
- 1809: Add support for JSON
->and->>operators
MySQLcolumn->pathDocumentation
MySQLcolumn->>pathDocumentation
Fixes: #5662 - 1808: escape special characters in strings
- 1806: improve conversion from JsonDocument to string
Closed Issues
- 6063: Excessive Memory usage related to JSON column and multi table JOIN
- 6076: Dolt backup restore drops user
root, prevents access to other databases. - 5936: Add
dolt table import --append - 5662: JSON operator
->>not supported
Latency
| Read Tests | MySQL | Dolt | Multiple |
|---|---|---|---|
| covering_index_scan | 1.96 | 2.71 | 1.4 |
| groupby_scan | 12.3 | 17.01 | 1.4 |
| index_join | 1.18 | 4.1 | 3.5 |
| index_join_scan | 1.12 | 2.07 | 1.8 |
| index_scan | 30.26 | 55.82 | 1.8 |
| oltp_point_select | 0.14 | 0.48 | 3.4 |
| oltp_read_only | 2.86 | 8.13 | 2.8 |
| select_random_points | 0.29 | 0.77 | 2.7 |
| select_random_ranges | 0.35 | 1.08 | 3.1 |
| table_scan | 30.81 | 56.84 | 1.8 |
| types_table_scan | 69.29 | 161.51 | 2.3 |
| reads_mean_multiplier | 2.4 |
| Write Tests | MySQL | Dolt | Multiple |
|---|---|---|---|
| bulk_insert | 0.001 | 0.001 | 1.0 |
| oltp_delete_insert | 5.09 | 6.32 | 1.2 |
| oltp_insert | 2.48 | 3.13 | 1.3 |
| oltp_read_write | 6.32 | 15.55 | 2.5 |
| oltp_update_index | 2.43 | 3.13 | 1.3 |
| oltp_update_non_index | 2.61 | 3.02 | 1.2 |
| oltp_write_only | 3.55 | 7.84 | 2.2 |
| types_delete_insert | 5.0 | 6.91 | 1.4 |
| writes_mean_multiplier | 1.5 |
| Overall Mean Multiple | 2.0 |
|---|