Merged PRs
dolt
go-mysql-server
- 2161: SHOW PLUGINS
fixes: #7049
depends on: dolthub/vitess#291 - 2160: fix
Inf
andNaN
for trigonometric functions
fixes #7046 - 2158: have
DayName()
returnNULL
on badDATETIME
conversions
fixes #7039 - 2157: don't round floats when converting to bool
fixes #7038 - 2155: Allow
BLOB
/JSON
/TEXT
columns to have literal default values (MariaDB compatibility)
Technically, MySQL does NOT allowBLOB
/JSON
/TEXT
columns to have a literal default value, and requires them to be specified as an expression (i.e. wrapped in parens). We diverge from this behavior and allow it, for compatibility with MariaDB.
While testing with a binary literal, I noticed thatSQLVal
was converting that value to "BLOB
" instead of the actual binary content, so I fixed that one, too.
Related to: #7033
Dolt CI Checks: #7036 - 2152: Update RangeTree MaxUpperBound when removing nodes
Verification code from in the last RangeTree related PR caught some bad ranges in the sqllogictests.
The cause was not properly updating the MaxUpperBound in nodes for the rangetree when performing a remove operation, which led to missing connections when pruning ranges.
This also prints MaxUpperBound in the String/DebugString methods for easier debugging.
vitess
- 289: add partial support for ':=' assignment operator
This PR adds support for set expressions and assignment expressions.
Does not include support for select expressions, as it's deprecated on MySQL