Backwards incompatible changes in this release:
The dolt_branches system table has changed. The table now has a ninth column to indicate that a branch is dirty. Some software may depend on the dolt_branches table having exactly eight columns, and will require updates to work with this latest version.
Per Dolt’s versioning policy, this is a minor version bump because these changes may impact existing applications. Please reach out to us on GitHub or Discord if you have questions or need help with any of these changes.
Merged PRs
dolt
- 8793: Add the
dirty column to the dolt_branches table
This change allows users, particularly on servers, to quickly determine which branches have a dirty working set.
go-mysql-server
- 2828: return error for ddl in create proc statements
This PR moves the logic for validateStoredProcedure analyzer rule into the planbuilder, allowing for proper error messages.
Related: #8762
- 2825: Bug fixes for serializing certain types in column default expressions
Fixed a couple bugs in column default normalization: 1) editing the expression tree in place so the change is invisible to debug logging, 2) normalizing some literals that should manage their own round-trip serialization
- 2824: implement
drop temporary table ... and display temporary in show create table statements
In-memory database doesn't support temporary tables, so tests are here: #8781
fixes: #7992
Closed Issues
Performance
| Read Tests |
MySQL |
Dolt |
Multiple |
| covering_index_scan |
1.93 |
0.64 |
0.33 |
| groupby_scan |
15.27 |
17.32 |
1.13 |
| index_join |
1.47 |
2.48 |
1.69 |
| index_join_scan |
1.42 |
1.44 |
1.01 |
| index_scan |
34.33 |
30.26 |
0.88 |
| oltp_point_select |
0.18 |
0.26 |
1.44 |
| oltp_read_only |
3.43 |
5.18 |
1.51 |
| select_random_points |
0.34 |
0.59 |
1.74 |
| select_random_ranges |
0.37 |
0.62 |
1.68 |
| table_scan |
34.33 |
32.53 |
0.95 |
| types_table_scan |
75.82 |
116.8 |
1.54 |
| reads_mean_multiplier |
|
|
1.26 |
| Write Tests |
MySQL |
Dolt |
Multiple |
| oltp_delete_insert |
8.9 |
6.21 |
0.7 |
| oltp_insert |
4.1 |
3.07 |
0.75 |
| oltp_read_write |
8.9 |
11.24 |
1.26 |
| oltp_update_index |
4.18 |
3.13 |
0.75 |
| oltp_update_non_index |
4.18 |
3.07 |
0.73 |
| oltp_write_only |
5.67 |
6.21 |
1.1 |
| types_delete_insert |
8.28 |
6.55 |
0.79 |
| writes_mean_multiplier |
|
|
0.87 |
| TPC-C TPS Tests |
MySQL |
Dolt |
Multiple |
| tpcc-scale-factor-1 |
96.53 |
39.63 |
2.44 |
| tpcc_tps_multiplier |
|
|
2.44 |
| Overall Mean Multiple |
1.52 |
