Merged PRs
dolt
- 8508: Update more system tables for doltgres
- 8505: Fix panics on schema changes
fixes: #8504
Use schema hash to detect when database statistics might be incompatible. Drops all statistics for schema update. This could be improved to a subset of statistics if we wanted in the future. - 8501: Bug fixes for replication
- Convert
@@server_id
to uint32 value when it gets loaded as a string from config.json - Send binary logfile name in server heartbeat events, now required in MySQL 8.4
- Convert
- 8499: scanner more safe whitespace skip
- 8497: Update the protobuf version from 22.0 to 28.3
Also update README to reflect the bazel 6.3.0 version - 8493: add bats test for
kill query <pid>
- 8482: Move dolt system tables to dolt schema for doltgres
go-mysql-server
- 2727: fix dropped error in createView
- 2726: remove
resolveDescribeQuery
rule
This rule just recurses into the analyzer, so we should just do it right at the beginning, so we should do it right away and avoid calling all other rules.
This would be better/cleaner in the planbuilder, but we would need to tell the analyzer to not analyze this node or skip it somehow.
It's possible to move this logic intoanalyzeWithSelector
.
It might be more difficult to move this aboveAnalyze
, as we'd have to put this logic in a variety of places. - 2723: server/handle.go: doQuery cleanup of some error handling.
- 2722: internal/sockstate: Restore connection checking on Linux.
GMS server handler is supposed to cancel running queries if the connection which issued them goes away. It does this by checking the connection state out-of-band anytime the query is running and canceling theh query if the connection goes away. The connection checking code is platform-specific and currently only works on Linux.
In commit 538696b2c943ac7f3cacf1b67a3a5ff40ae64a00 I introduced a bug where the connection checking code tries to inspect the socket state of an already closed file descriptor. This change fixes the behavior so that the file descriptor is left open until the necessary socket state is extracted. - 2720: move
wrapTriggerRollback
logic
This PR removes theplan.TriggerRollback
andplan.NoopTriggerRollback
node and applies thetriggerRollbackIter
directly.
When there are multiple nested triggers (aka triggers that call other triggers), we used to have multiple nested trigger rollbacks with different savepoints. It turns out that was unnecessary and a single savepoint at the top of the iter tree is enough; when there's an error, it propagates back to the top, rollingback all changes. - 2718: use sqlCtx in handler
Tests here: #8493 - 2717: push
Distinct
nodes belowSort
nodes
This PR optimized queries like:When there are many duplicate values in columnselect distinct i from t order by i;
i
, it is much more efficient to eliminate duplicates first, then sort the results.
There are somewhat unrelated optimizations left as TODOs.
Optimize query: #8488
vitess
- 373: Fixed printing bug in AliasedExpr node (was calling wrong print metho…
…d, which doesn't work with custom formatters) - 371: support quoted character set values
This PR adds syntax support for quoted character set values.
fix: #8455
Closed Issues
- 8504: Crash when refreshing statistics after a PK column change