Merged PRs

dolt

• 12025: Fixed foreign keys referencing a renamed index This fixes the issue presented in:
• https://github.com/dolthub/doltgresql/issues/3517 This moves the index renaming logic so that it also covers ALTER INDEX instead of only RENAME INDEX.
• 12024: Quoted dolt_blame view identifiers with the engine's schema formatter This moves quoting for the dolt_blame_* tables to use the quoting function so that Doltgres uses its quotes. Previously we were hardcoding MySQL quotes, which caused parsing errors on Doltgres.
• 12023: docs: document the NBS storage lock contract Closes [#11262] go/store/nbs/README.md described NBS's on-disk layout but never mentioned the advisory file lock, so operators had nothing to read when a restart raced a running server. The new "Storage locking" section documents the lock's path (<database dir>/.dolt/noms/LOCK), that it goes through github.com/dolthub/file-locks (flock(2) on unix, LockFileEx on Windows), and that it is advisory. It covers the lifetime (newJournalLock acquires, NomsBlockStore.Close releases; there is no maximum hold time), the 100 ms lockFileTimeout and what happens after it (a silent read-only open by default, ErrDatabaseLocked with fail_on_journal_lock_timeout, a single non-blocking attempt with skip_journal_lock_timeout), that a kill -9 cannot leave a stale lock because the kernel releases flocks, that the LOCK file itself always remains and its presence says nothing about lock state, and that deleting the LOCK file while a process holds the lock silently breaks mutual exclusion. Everything stated here was read out of go/store/nbs/file_manifest.go, go/store/nbs/journal_manifest.go and the github.com/dolthub/file-locks API (lockFileTimeout, ErrDatabaseLocked, the fail_on_journal_lock_timeout / skip_journal_lock_timeout options). The caveat that the guarantees are only as good as the mount over NFS/SMB is stated as such rather than as a tested claim. Documentation only - no Go code changed.

  This pull request was prepared with the assistance of an AI coding agent and has not yet been reviewed by a human.

• 12018: Allow schema overrides with ignored nonlocal tables Nonlocal tables now retain their own schema when absent from the schema-override commit. Existing overrides still apply, and ordinary local lookups remain strict. Resolve nonlocal targets through user-table lookup and keep conflict backing tables on the same root, preventing conflict updates from being redirected to another branch. Adds focused regression coverage for ignored tables, cross-branch aliases, committed targets, and conflict updates. Validated normal/prepared nonlocal and rebase engine suites, plus schema-override suites with standard and adaptive encoding. Fixes [#11997]

go-mysql-server

• 3971: Delegate IN element evaluation to comparison expressions and apply coercibility to HashInTuple IN predicates respect character set and collation comparison rules (such as accent-insensitivity in utf8mb4_unicode_ci and utf8mb4_0900_ai_ci) for both sequential tuple evaluations and in-memory hash lookups. Fix [#11907]
• 3947: Execute duplicate-key update triggers Executes duplicate-key update triggers, with import regression coverage in https://github.com/dolthub/dolt/pull/11980 and DoltgreSQL compatibility changes in https://github.com/dolthub/doltgresql/pull/3469. Fixes https://github.com/dolthub/dolt/issues/5925
• 3936: Convert ANY_VALUE from an aggregate to a scalar function Unaggregated queries containing ANY_VALUE no longer synthesize a whole-table GroupBy node or collapse rows, and windows invocations like ANY_VALUE(a) OVER () are properly rejected as a syntax error.
• Add function.AnyValue as a scalar sql.FunctionExpression to avoid artificial GroupBy node and collapsing rows.
• Remove aggregate and window patches now that there's no aggregate function nesting errors.
• Exempt ANY_VALUE arguments from ONLY_FULL_GROUP_BY validation in validateGroupBy. Fix [#11911] Fix [#3944]

Closed Issues

• 11262: Document the noms LOCK contract (<data_dir>/<db>/.dolt/noms/LOCK): acquire timeout, lifetime/staleness, external-waiter flock safety
• 11739: conjoin opens unbounded concurrent connections — exceeds sshd MaxStartups on git+ssh remotes, so conjoin never completes
• 11997: unable to find global table at overridden schema root
• 3944: ErrIndexOutOfBounds evaluating correlated scalar subquery in joined GROUP BY