dolt version history

- Fixed database transaction issues with concurrent session creation and lazy loading - Improved JWT authentication by validating Subject claims against expected user claims - Fixed deadlock in concurrent database cloning between remote API servers - Added new engine initialization interface for integrators

- Fixed merge issues related to adaptive encoding and improved error handling during merges. - Added a global credential helper for remotesapi and fixed `DOLT_LOG` system table on shallow clones. - Optimized CASE statements and HashLookups, and fixed JSON_LENGTH and member-access lookups to match MySQL behavior. - Improved handling of client activity detection in Vitess and reverted previous async read EOF changes.

# Merged PRs ## dolt * [11238](https://github.com/dolthub/dolt/pull/11238): go: sqle/clusterdb: Fix spurious error logs. Interact with quiescable events database protocol. This also enables quiesced event reloads even when cluster replication is enabled. * [11237](https://github.com/dolthub/dolt/pull/11237): go: store/pull,remotestorage: Add optional logging to `dolt pull/fetch/push`. If you set `PUSH_LOG=true` when running `dolt pull`, `dolt fetch` or `dolt push`, some extra logging output will appear in `.dolt/temptf/push-*.log`. ## go-mysql-server * [3594](https://github.com/dolthub/go-mysql-server/pull/3594): allow using star expr after sql value for Doltgres # Closed Issues

# Merged PRs ## dolt * [11217](https://github.com/dolthub/dolt/pull/11217): remove the dolt archive command The `dolt archive` command was a precursor to GC support using archives. It offered the ability to test and roll back is problems arose. Now that archives are the default and have been for awhile, this command seems unnecessary. * [11215](https://github.com/dolthub/dolt/pull/11215): fix silent data loss for large JSON values with control characters Large JSON values containing control characters were silently dropped on read. The stored text was re-parsed strictly, and an over-eager unescape step corrupted any non-HTML `\uXXXX` escape. - preserve non-HTML unicode escapes in `unescapeHTMLCodepoints` - guard against truncated escapes Fix dolthub/dolt#11210 Depends on dolthub/go-mysql-server#3589 Close #11218 * [11214](https://github.com/dolthub/dolt/pull/11214): go,integration-tests: Enable session aware safepoint controller by default. Fixes a regression in the session-aware controller where fast-complete no-op GC was not working as intended. * [11192](https://github.com/dolthub/dolt/pull/11192): reject column reference args in dolt_diff with a clear error

# Merged PRs ## dolt * [11200](https://github.com/dolthub/dolt/pull/11200): fix: Improve remote interactions against file remotes from within long-lived processes. Dolt currently has a singleton cache which can cache file remotes across calls to things like `dolt_clone` and `dolt_fetch`. This change ensures that Dolt Rebases the store when it is interacting with the remote so that it always sees the latest novelty. * [11198](https://github.com/dolthub/dolt/pull/11198): go/utils/publishrelease/buildindocker.sh: Bump CC toolchain. gcc 16.1.0, musl 1.2.6, binutils 2.46.0, mimalloc 3.3.2. * [11197](https://github.com/dolthub/dolt/pull/11197): bug fix for blame view Recent change made results start including working set changes, which we don't want * [11135](https://github.com/dolthub/dolt/pull/11135): fix: make findCommonCommit deterministic for criss-cross merges * [10976](https://github.com/dolthub/dolt/pull/10976): fix(sql): use LEFT JOIN in blame view to handle schema-only reverts ## go-mysql-server * [3587](https://github.com/dolthub/go-mysql-server/pull/3587): go.mod: Bump github.com/lestrrat-go/strftime to v1.2.0. Fixes a lock leak which can deadlock querie

# Merged PRs ## dolt * [11179](https://github.com/dolthub/dolt/pull/11179): Set version string in initial server response MySQL servers return a version string in the initial connection response. Some clients read this and expect certain versions of MySQL or MariaDB. We return `8.0.31` by default, since that corresponds with the MySQL version we advertise feature parity with. Currently, we use the `@@version` system variable as the source of truth for the version string, and this can be configued via a server config file. But we extract the config for the listener before we initialize system variables. Previously this meant that the version string on connection defaulted to the value specified in our vitess dependency, which was hardcoded to `8.0.31`. This PR changes the behavior to extract a string from the config if it exists. We need to use a client integration test for this, since the Go SQL driver ignores the version in the connection info and does not provide a way to view it. * [11153](https://github.com/dolthub/dolt/pull/11153): Bug fix: Doltgres `JSONB` use with `dolt_patch()` Fixes https://github.com/dolthub/doltgresql/issues/2732 # Closed Issues * [11166](

# Merged PRs ## dolt * [11185](https://github.com/dolthub/dolt/pull/11185): go/store/nbs: boostrapJournal: Improve journal bootstraping resiliency in the face of errors in journal.idx. journal.idx is an optimization to make opening the database faster. Errors in reading it should never cause opening the database to fail. Make it so that we gracefully handle data and I/O errors in accessing journal.idx so that database opening proceeds as expected. There is still one fatal error associated with journal.idx: when we are in read-write mode, we must be able to open journal.idx for writing. * [11184](https://github.com/dolthub/dolt/pull/11184): bug fix for merging tables with vector indexes Fixes: https://github.com/dolthub/dolt/issues/11180 Related Doltgres update to skip the unsupported `VECTOR` index test: https://github.com/dolthub/doltgresql/pull/2827 ## go-mysql-server * [3578](https://github.com/dolthub/go-mysql-server/pull/3578): fix: retain table comment when primary key is a separate clause `CREATE TABLE ... COMMENT='c'` dropped the comment when `PRIMARY KEY` was given as a separate clause. - Add a `comment` parameter to `IndexedTableCreator.CreateIndexedTable`

# Merged PRs ## dolt * [11178](https://github.com/dolthub/dolt/pull/11178): Mark `dolt_diff_$TABLENAME` `to_commit` and `from_commit` indexes as non-unique The `dolt_diff_$TABLENAME` system table marked its `to_commit` and `from_commit` indexes as unique. A single commit changes many rows, so each commit hash maps to many diff rows and these indexes are not unique. Fix dolthub/dolt#11159 * [11177](https://github.com/dolthub/dolt/pull/11177): Bug fix: don't rebuild fulltext indexes unnecessarily When two sessions are making changes to a table with a `fulltext` index, the index was unnecessarily getting rebuilt, even when the indexed column wasn't changing in the updates. This change limits when the index is rebuilt to avoid unnecessary rebuilds. # Closed Issues * [11159](https://github.com/dolthub/dolt/issues/11159): `dolt_diff_$TABLENAME`: mark `to_commit` and `from_commit` indexes as non-unique # Performance | Read Tests | MySQL | Dolt | Multiple | |:-----------------------:|:------:|:------:|:--------:| | covering\_index\_scan | 17.32 | 2.3 | 0.13 | | groupby\_scan | 142.39 | 142.39 | 1.0 | | index\_join | 3.49

# Merged PRs ## dolt * [11176](https://github.com/dolthub/dolt/pull/11176): go/store/{val,prolly/tree}: Implement ValueContext for the places where we need a Context. dolthub/driver directly consumes these values and has the abilityt to pass the correct Context instance. * [11172](https://github.com/dolthub/dolt/pull/11172): bug fix for race condition in acquiring auto increment locks The global auto increment tracker had a race condition in Next(). In interleaved mode (the default), a necessary table-level lock was not being taken, leading to a non-atomic get-increment-set race between two concurrent sessions. This was due to the lock mode being stored in the struct itself and only set during some code paths. The fix sets the lock mode value at startup. The new test reliably reproduced the race condition before this patch. * [11170](https://github.com/dolthub/dolt/pull/11170): fix: persist table comment on indexed table creation Separate `PRIMARY KEY` clause routes creation through `CreateIndexedTable` which never sets schema comment. - Thread `comment` through `CreateIndexedTable` Fix dolthub/dolt#11163 Close dolthub/dolt#11175 * [11168](https://github.com/dolthu

# Merged PRs ## dolt * [11150](https://github.com/dolthub/dolt/pull/11150): fix(git-remote-cache): ensure remote cache compaction and pruning occurs via new `Teardown` lifecycle method Adds a new `Teardown` lifecycle method to `ChunkStore` (plus `DoltDB` and `DoltDatabaseProvider`) for Git remotes. `Teardown` drives the expensive end-of-process cleanup — `git gc` and deletion of per-session `UUID` refs — that previously fired implicitly inside `Close` and was therefore lost when the provider-level cache was removed. `Close` remains the cheap, deferrable per-operation hook; for the shared Git remote `NomsBlockStore` it is suppressed by a thin shim so caller defers don't tear down the shared instance. Also readds a provider-layer cache (Git remotes only) so a `DoltDB` is opened once per remote URL per process and reused across operations. At engine shutdown, the provider calls `Teardown` once, which drains both caches, runs the GC + ref cleanup, then force-closes each shared store. * [11148](https://github.com/dolthub/dolt/pull/11148): Fix `dolt status` to report `AUTO_INCREMENT` value changes `ALTER TABLE foo AUTO_CINREMENT = N` updated the table but `dolt status` c

# Merged PRs ## dolt * [11136](https://github.com/dolthub/dolt/pull/11136): Populate `dolt_workspace` schema with current table schema when deltas are nil fixes #11127 * [11111](https://github.com/dolthub/dolt/pull/11111): New `ProviderFactory` interface Introduces a new `ProviderFactory` interface that allows Doltgres to extend database behavior. Depends on: https://github.com/dolthub/go-mysql-server/pull/3563 ## go-mysql-server * [3563](https://github.com/dolthub/go-mysql-server/pull/3563): Introduce `SchemaObjectNameValidator` interface To support custom Postgresql logic for Doltgres, a new interface called `RelationNameValidator` is added. * [3562](https://github.com/dolthub/go-mysql-server/pull/3562): pass schema name when retreiving function # Closed Issues * [11127](https://github.com/dolthub/dolt/issues/11127): Deieting from dolt_workspace_TABLE fails (only) when no rows exist in it with missing column error * [10727](https://github.com/dolthub/dolt/issues/10727): dolt push fails with 'uncommitted changes' when remote has ignored tables in working set * [11131](https://github.com/dolthub/dolt/issues/11131): Dolt 2.0.8: adaptive out-of-line TEXT written via m