Merged PRs

dolt

• 11804: Enable fine-grained merging for adaptive JSON Recognize the JsonAdaptiveEnc storage encoding in the prolly-row JSON merge path, enabling the existing structural merger for Doltgres JSON storage. Part of [#2018]
• 11802: Fix legacy table name unmarshalling receiver
• 11796: go/store/nbs: journal_writer.go: Fix a rare race where the journal_writer entered a weird state because its caller context Canceled as it was bootstraping.
• 11791: Warn about session-only checkout in noninteractive SQL Warns when a lone dolt_checkout() call in noninteractive SQL changes only the SQL session's branch, leaving the CLI branch unchanged. Fixes https://github.com/dolthub/dolt/issues/6876
• 11790: Add virtual name indexes for tags and branches Adds virtual name indexes with cached ref lookups for dolt_tags and dolt_branches. Fixes https://github.com/dolthub/dolt/issues/10365 Companion PR: https://github.com/dolthub/doltgresql/pull/3342
• 11788: Persist sql_mode as string and reload on server startup Fix dolthub/dolt#11776

doltgresql

• 3377: Fix DROP ROLE authorization cleanup Remove privilege and membership references when a role is dropped, including roles as grantees, grantors, members, groups, and membership grantors. Sanitize orphaned role references while loading authorization data and persist the sanitized state on cluster standbys, protecting installations upgraded from affected releases. Add SQL, persistence, and legacy-serialization regressions.
• 3367: Merge independent JSON document changes Add end-to-end coverage for independent json and jsonb document updates across branches, including the reported jsonb concatenation case. The exact Dolt dependency enables structural merging for the adaptive JSON encoding. Tracks [#2018] Depends on: Dolt [#11804]

Closed Issues

• 2018: JSON merge support
• 8855: Support cosine vector distance function
• 8658: Create VECTOR type.
• 11416: Dolt JSON_EXTRACT does not preserve large JSON integer values.
• 8477: dolt sql \commit uses static time stamp
• 8325: panic during dolt dumpif db contains a (non-empty) table with virtual columns
• 8193: inserts with specified fields should error on empty insert values
• 7402: dolt cherry-pick --abort reverts ignored tables.
• 11771: EXISTS with a join: a correlated reference in the ON clause is dropped from the plan, and the query returns wrong rows
• 7022: Dolt's reset --soft behavior doesn't match Git's
• 6300: Prepared statements don't work with as of
• 6124: dolt diff after change primary key and adding a column gets error
• 5821: Column in SELECT list is allowed when it is not present in the GROUP BY clause
• 1894: Statement boundaries do not work across tables
• 11399: Dolt raises an internal field-index error for sibling SUM/AVG windows
• 11396: Dolt RANGE BETWEEN 1 PRECEDING AND CURRENT ROW over BIGINT UNSIGNED loses the current row at the lower boundary.
• 11545: Dolt swallows a child-expression evaluation error in SUM
• 11460: Dolt forms incorrect RANGE boundaries for a correlated computed order key
• 11425: Dolt reports an internal row-index bug for invalid NTILE(column).
• 10365: dolt_tags system table missing index on tag_name - causes O(n) lookup
• 6876: Warn users about running dolt sql -q "call dolt_checkout(...);"
• 11391: Dolt computes population statistical aggregates incorrectly for INT input.
• 11776: SET PERSIST sql_mode does not survive a sql-server restart ("value N was not found in the set")