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