Merged PRs
dolt
- 6492: Make gen-zsh command write to stdout
- 6487: feat: adding zsh plugin
This isn't perfect, but it's a starting point. What would be better:- Create a separate repo for just this script (
dolthub/zsh
) for easier installation - Change gen-zsh to output the script to stdout like
gh
,op
, and other popular tools
You can use this via afor
loop in zinit like:
zinit wait lucid for \ 'https://github.com/iloveitaly/dolt/blob/zsh-plugin/dolt.plugin.zsh'
- Create a separate repo for just this script (
go-mysql-server
- 1935: Allow timestamps when encoding json
As reported on discord, Nautobot, through DJango, puts time stamp data into a json object. This fails because:
This change enables the encoding of a time stamp into a string.db> select JSON_OBJECT("a", Now()); unsupported type: time.Time
- 1933: Fixed case sensitivity bugs in various statements
- 1928: Generated stored columns prototype
Looking for feedback. The approach is a little bit wonky: it uses the same code paths as column defaults since they behave so similarly, but this has some weird consequences:- For generated columns, we fill in the column.DefaultValue field with the Generated expression
- In various places, we now have to consider whether to use either column.DefaultValue, or column.Generated
Overall I think I'm favorable on this approach, but keeping the two values more separate might be better for maintainability, not sure. Thoughts?
Closed Issues
- 6489: json_table prepared errors
Latency
Read Tests | MySQL | Dolt | Multiple |
---|---|---|---|
covering_index_scan | 2.11 | 3.02 | 1.4 |
groupby_scan | 12.98 | 18.28 | 1.4 |
index_join | 1.27 | 4.82 | 3.8 |
index_join_scan | 1.21 | 2.3 | 1.9 |
index_scan | 33.12 | 57.87 | 1.7 |
oltp_point_select | 0.14 | 0.48 | 3.4 |
oltp_read_only | 2.71 | 8.28 | 3.1 |
select_random_points | 0.3 | 0.83 | 2.8 |
select_random_ranges | 0.37 | 1.21 | 3.3 |
table_scan | 33.12 | 57.87 | 1.7 |
types_table_scan | 74.46 | 167.44 | 2.2 |
reads_mean_multiplier | 2.4 |
Write Tests | MySQL | Dolt | Multiple |
---|---|---|---|
bulk_insert | 0.001 | 0.001 | 1.0 |
oltp_delete_insert | 4.65 | 5.88 | 1.3 |
oltp_insert | 2.22 | 2.91 | 1.3 |
oltp_read_write | 5.99 | 15.83 | 2.6 |
oltp_update_index | 2.26 | 2.97 | 1.3 |
oltp_update_non_index | 2.52 | 2.97 | 1.2 |
oltp_write_only | 3.36 | 7.7 | 2.3 |
types_delete_insert | 4.91 | 6.55 | 1.3 |
writes_mean_multiplier | 1.5 |
Overall Mean Multiple | 2.1 |
---|