Merged PRs

dolt

• 8910: Report auto increment changes in dolt diff and dolt_diff_summary()
  Potential fix for #8907
  Previously, diffs would only look at the schema hash when determining whether or not a table had a schema change. However, the auto increment counter, which is considered part of the schema, is not stored in the schema flatbuffer and thus does not affect the schema hash.
  This led to situations where a diff would detect that a table had changed (because the table hash changed), but it reported neither a data change or a schema change (because the data hash and schema hash were the same.) This was confusing.
  Now, dolt_diff_summary will correctly report a schema change when the auto increment counter has changed, and dolt diff will show the autoincrement value in the SHOW CREATE TABLE output.
• 8905: add pager support to sql shell
  Adds the \pager [on|off] capability to dolt sql.
  Fixes: #8883
  Currently no tests. Would require expect, and is probably beyond the investment in time for this feature.
• 8897: go: Bump to go 1.24. Fix some vet errors related to non-constant format strings.

go-mysql-server

• 2864: Allow SHOW CREATE to display auto increment for tables that store AutoIncrement but don't support writing it.
  This is the GMS side of an issue to properly display diffs when the autoincrement counter on a table changes.
  We add a new interface, AutoIncrementGetter for tables that store AutoIncrement info, even if they can't generate autoincremented ids (because they're immutable snapshots of a table with an autoincrement column)
• 2861: Added configurable options for how to quote identifiers in column defaults
• 2859: server: Add a ContextFactory parameter to the handler, giving integrators control over the *sql.Context creation.

vitess

• 399: go/mysql: conn.go: Fix read-after-recycle bug of the packet byte buffer in COM_{STMT_SEND_LONG_DATA,REGISTER_REPLICA,BINLOG_DUMP_GTID}.
  Back ports vitessio/vitess@24820d8
• 398: Add select expressions for the Postgres INSERT ... RETURNING support
  Postgres allows INSERT statements (and also UPDATE and DELETE) to specify a RETURNING clause with select expressions and will then evaluate those expressions against the affected rows and return the results. This change adds initial support for the RETURNING select expressions so that they can be represented in the AST. (PostgreSQL docs)

Closed Issues

• 8769: last_insert_id gives 0 when 0 is explicitly specified for an auto_increment primary key in an insertion
• 8883: Feature Request: Add pager support for dolt sql terminal output

Performance