Lataa Dolt 1.81.1

Merged PRs
dolt
- 10347: fixed output bug for foreign key constraints
go-mysql-server
- 3389: remove convertLeftAndRight
This PR removes c.convertLeftAndRight, which avoids calls to c.Left().Type() and c.Right().Type().
Not entirely sure why receiver methods would impact performance this much, but benchmarks say so.
Benchmarks: #10342 (comment)
- 3384: Look at every join node parent when computing outer scopes.
Previously, when building scopes for subqueries that appear inside joins, we would only track a single parent join node. If the subquery had multiple join parents, we would only be able to resolve references to the innermost subquery. This inhibits the optimizations we can perform.
This PR uses a custom tree walker to track a list of parent join nodes, and includes an example of a query that was not previously possible to optimize.
- 3370: Wrap errgroup.Group.Go() calls for consistent panic recovery
Each spawned goroutine needs a panic recovery handler to prevent an unexpected panic from crashing the entire Go process. This change introduces a helper function that wraps goroutine creation through errgroup.Group and installs a panic recovery handler and updates existing code to use it.
vitess
- 448: Move SERIAL type out of numeric type definitions so that unsigned value is not overwritten
fixes #10345
MySQL docs
- 446: Added DISTINCT ON expressions
Related PRs:
- dolthub/go-mysql-server#3369
- dolthub/doltgresql#2181
Closed Issues
- 10345: SERIAL type alias creates signed BIGINT instead of unsigned
- 10329: Foreign key constraint doesn't enforce index requirement on receiving table