Merged PRs
dolt
- 12587: Fix index lookups on temporary tables
- Fixes #12580: a contradictory WHERE on an indexed temporary table panicked and dropped the connection. Temporary tables now hand out one partition per index range, so an empty range set yields an empty result.
- Disjunctions on an indexed temporary table column (
x = 1 OR x = 2) no longer fail with "expected a single index range". - Index lookups on temporary tables large enough to have several scan partitions no longer return duplicate rows.
- Move engine tests into their own file (last commit).
- 12575: Pass a context to the schema formatter when generating column definitions
Passes a context to the schema formatter when generating column definitions, so that it can show expressions under the session's search path.
Companion PRs: dolthub/go-mysql-server#4186, dolthub/doltgresql#3909 - 12574: Bulk dependabot bumps
- Bump github.com/klauspost/compress 1.17.8 -> 1.18.7 in go-mysql client tests (#12158)
- Bump github.com/go-jose/go-jose/v4 4.1.4 -> 4.1.6 (#12228)
- Bump MySqlConnector 2.4.0 -> 2.6.1 in dotnet client tests (#12281)
- Bump org.mariadb.jdbc:mariadb-java-client 3.5.9 -> 3.5.11 in java client tests (#12299)
- Bump go.opentelemetry.io/otel/trace 1.44.0 -> 1.47.0 (#12491)
- 12567: go.mod: Bump eventsapi_schema. Pick up idempotency_level annotation.
- 12563: Read archive index with a single ranged read
Partial fix for #12558: opening an archive on a blobstore remote issued four ranged GETs for its index, one per contiguous section. It now reads the whole index once. Cloning an S3 remote with 157 small archives drops from 1,415 to 944 GETs. - 12559: binlogreplication: create Dolt commits before advancing gtid_executed
Fixes the intermittentTestDoltCommitsfailure (expected 5 commits, got 4). The binlog replica advanced@@gtid_executedand saved its position before runningdolt_commitfor the transaction, so anything waiting ongtid_executedcould see the replica as caught up before the last Dolt commit existed. The replica now creates the Dolt commits first, then records the GTID. - 12555: Make dolt_tag changes visible to dolt_tags in the same transaction
Fixes dolt_tags not showing tags created or deleted by dolt_tag earlier in the same transaction.
Fixes #12553 - 12554: bats: fix remotesrv tests still using port 50051
Fixes lambdabats failures on main inremotesrv: read only server rejects writesand the twoshallow-clone: fsck passestests. They still used port 50051 after remotesrv ports were made per-test in #12053. - 12552: remotesrv: return forward-slash download URL paths on Windows
Fixes #12519: on Windows, remotesrv download URLs contained backslashes fromfilepath.Rel, which the file handler rejects with 400 since the repo path validation was added. Store and oldgen prefixes are now converted to slash form. Based on #12550 by @jay23606. - 12543: /go/{cmd,libraries}: ensure cleanup runs whenever git remote is used
Fixes #12328, ensures the cleanup actually runs whenever a Gitr remote is used, previously did not run duringdolt sql-serverinvocations. - 12542: Fix stale docs links in the README
- Fix the dead Dolt commits docs link in the getting-started walkthrough (from #12539 by @farisbasha, commit kept as authored).
- Point the Gas Town link at its current repo, github.com/gastownhall/gastown.
- 12541: Refuse over-long branch and tag names instead of panicking or wrapping
Branch and tag names over ~32K bytes panicked with "impossible node", and names over 64K silently wrapped the 16-bit node offsets. Branch and tag names are now limited to 1024 bytes and refused cleanly before anything is written, AddressMap rejects keys over 16 KiB with an error, and invalid-name panics in branch/tag creation are now errors.
Fixes: dolthub/doltgresql#3895 - 12534: Add a row merge policy hook for transaction commits
Adds a hook that decides each row two concurrent transaction commits both changed.
Companion PR: dolthub/doltgresql#3887 - 12526: Reset table writers after materializing pending edits, not during
Rebuilding a table writer with a partial index could read the working set while pending edits were still being saved, which panicked. Writers are now rebuilt after the save finishes.
Fixes: dolthub/doltgresql#3877 - 12481: Arm GC cancellation wakeups only when waiting, using context.AfterFunc in ValueStore
Arm GC cancellation wakeups only when waiting, using context.AfterFunc in ValueStore. - 12472: Remove use of channels from prollyKeylessIndexIter
When iterating over indexes for keyless tables, we used to goroutines, where one reads from storage and sends the results over a channel. This was presumably a performance optimization to avoid blocking plan execution on IO, but:- None of the other index types do this
- It complicates iteration logic
- Removing this shows no significant performance impact, and possible performance gains.
- 12162: Bump github.com/klauspost/compress from 1.18.0 to 1.18.7 in /go
Bumps github.com/klauspost/compress from 1.18.0 to 1.18.7.Release notes
Sourced from github.com/klauspost/compress's releases.
v1.18.7
- Fix s2.NewDict OOB read.
Security release without other changes.
Full Changelog: klauspost/compress@v1.18.6...v1.18.7
v1.18.6
What's Changed
- s2: Fix amd64 stack frame corruption by
@klauspostin klauspost/compress#1145 - gzhttp: Canonicalize ETag header by
@justinmayhewin klauspost/compress#1139 - perf: pool hash tables in Go encode paths to reduce allocations by
@huynhanx03in klauspost/compress#1143
New Contributors
@justinmayhewmade their first contribution in klauspost/compress#1139@huynhanx03made their first contribution in klauspost/compress#1143@thaJeztahmade their first contribution in klauspost/compress#1144
Full Changelog: klauspost/compress@v1.18.5...v1.18.6
v1.18.5
What's Changed
- zstd: Fix crash when changing encoder dictionary with same ID by
@klauspostin klauspost/compress#1135 - zstd: Default to full zero frames by
@klauspostin klauspost/compress#1134 - flate: Clean up histogram order by
@klauspostin klauspost/compress#1133
Full Changelog: klauspost/compress@v1.18.4...v1.18.5
v1.18.4
What's Changed
- gzhttp: Add zstandard to server handler wrapper by
@klauspostin klauspost/compress#1121 - zstd: Add ResetWithOptions to encoder/decoder by
@klauspostin klauspost/compress#1122 - gzhttp: preserve qvalue when extra parameters follow in Accept-Encoding by
@analyticallyin klauspost/compress#1116
New Contributors
@analyticallymade their first contribution in klauspost/compress#1116@ethaizonemade their first contribution in klauspost/compress#1124@zwassmade their first contribution in klauspost/compress#1125
Full Changelog: klauspost/compress@v1.18.2...v1.18.4
v1.18.3
Downstream CVE-2025-61728
See golang/go#77102
Full Changelog: klauspost/compress@v1.18.2...v1.18.3
... (truncated)
Commits
8668e35Merge commit from forkac2f5e8docs: use unix line-endings for markdown files (#1144)620d7b5s2: Fix amd64 stack frame corruption (#1145)1b63f2fbuild(deps): bump the github-actions group with 2 updates (#1141)3d86b89s2: pool hash tables in Go encode paths to reduce allocations (#1143)15967degzhttp: Canonicalize ETag header (#1139)c5e0077zstd: Fix encoder changing dictionary with same ID (#1135)fd3f23ezstd: Default to full zero frames (#1134)8233c58flate: Clean up histogram order (#1133)bcf0d12build(deps): bump the github-actions group with 3 updates (#1132)- Additional commits viewable in compare view
- 12053: Bump mariadb from 3.5.3 to 3.5.4 in /integration-tests/mysql-client-tests/node
Bumps mariadb from 3.5.3 to 3.5.4.Release notes
Sourced from mariadb's releases.
MariaDB Connector/Node.js 3.5.4
3.5.4 (Jul 2026)
Notable changes
- CONJS-355: Avoid flat-cloning the connection options for every command, relying on a prototype-chain merge instead (#353 thanks to erulabs)
- CONJS-357: Add JavaScript SAST (CodeQL + eslint-plugin-security) to CI
- CONJS-365: Enable standard TLS certificate identity validation under Deno
- CONJS-366: New option
maxAllowedColumns(default 65535) bounding the column count announced by the server, a rogue server being otherwise able to have the client allocate metadata for a result-set that will never complete (report by fg0x0)
Issues Fixed
- CONJS-329: An exception thrown by a callback was reported to that same callback as a database error, instead of propagating like it does from any other node-style callback (report by Assen Totin)
- CONJS-356: Corrected ed25519 authentication with zero-configuration SSL
- CONJS-358: Refuse multi-part packet (> 16MB) reassembly before authentication completes, a rogue server being otherwise able to exhaust client memory before any credential is even validated
- CONJS-359: Corrected the default
maxAllowedPacketvalue when the option is not set - CONJS-360:
batch()ignored theinsertIdAsNumber/supportBigNumbers/bigNumberStringsoptions for insertId - CONJS-361: The connection stopped sending commands after a command ending on the last packet of a network chunk: a prepared statement was never executed, without error nor timeout (report by Assen Totin)
- CONJS-362: Limit the parsec authentication PBKDF2 iteration factor and move the key derivation off the event loop, a rogue server being otherwise able to freeze the whole process for minutes (report by fg0x0)
- CONJS-363: typeCast accessors returned corrupted values with prepared statements
- CONJS-364:
Types/TypeNumbersenums threw at runtime (#347, contribution by BrianDouglasIE) - CONJS-367: Uninitialized process memory leaked to server via malformed GeoJSON Polygon parameter (report by fg0x0)
- CONJS-368: Fixed SQL injection in text protocol when session uses NO_BACKSLASH_ESCAPES (report by fg0x0)
- CONJS-369: Fixed SQL injection through object keys in SET expansion when using
permitSetMultiParamEntries(report by fg0x0)
Changelog
Sourced from mariadb's changelog.
3.5.4 (Jul 2026)
Notable changes
- CONJS-355: Avoid flat-cloning the connection options for every command, relying on a prototype-chain merge instead (#353 thanks to erulabs)
- CONJS-357: Add JavaScript SAST (CodeQL + eslint-plugin-security) to CI
- CONJS-365: Enable standard TLS certificate identity validation under Deno
- CONJS-366: New option
maxAllowedColumns(default 65535) bounding the column count announced by the server, a rogue server being otherwise able to have the client allocate metadata for a result-set that will never complete (report by fg0x0)
Issues Fixed
- CONJS-329: An exception thrown by a callback was reported to that same callback as a database error, instead of propagating like it does from any other node-style callback (report by Assen Totin)
- CONJS-356: Corrected ed25519 authentication with zero-configuration SSL
- CONJS-358: Refuse multi-part packet (> 16MB) reassembly before authentication completes, a rogue server being otherwise able to exhaust client memory before any credential is even validated
- CONJS-359: Corrected the default
maxAllowedPacketvalue when the option is not set - CONJS-360:
batch()ignored theinsertIdAsNumber/supportBigNumbers/bigNumberStringsoptions for insertId - CONJS-361: The connection stopped sending commands after a command ending on the last packet of a network chunk: a prepared statement was never executed, without error nor timeout (report by Assen Totin)
- CONJS-362: Limit the parsec authentication PBKDF2 iteration factor and move the key derivation off the event loop, a rogue server being otherwise able to freeze the whole process for minutes (report by fg0x0)
- CONJS-363: typeCast accessors returned corrupted values with prepared statements
- CONJS-364:
Types/TypeNumbersenums threw at runtime (#347, contribution by BrianDouglasIE) - CONJS-367: Uninitialized process memory leaked to server via malformed GeoJSON Polygon parameter (report by fg0x0)
- CONJS-368: Fixed SQL injection in text protocol when session uses NO_BACKSLASH_ESCAPES (report by fg0x0)
- CONJS-369: Fixed SQL injection through object keys in SET expansion when using
permitSetMultiParamEntries(report by fg0x0)
3.4.7 (Jul 2026)
Notable changes
- CONJS-357: Add JavaScript SAST (CodeQL + eslint-plugin-security) to CI
Issues Fixed
- CONJS-358: Refuse multi-part packet (> 16MB) reassembly before authentication completes, a rogue server being otherwise able to exhaust client memory before any credential is even validated
- CONJS-363: typeCast accessors returned corrupted values with prepared statements
- CONJS-367: Uninitialized process memory leaked to server via malformed GeoJSON Polygon parameter (report by fg0x0)
- CONJS-368: Fixed SQL injection in text protocol when session uses NO_BACKSLASH_ESCAPES (report by fg0x0)
- CONJS-369: Fixed SQL injection through object keys in SET expansion when using
permitSetMultiParamEntries(report by fg0x0) - Escape the server-supplied filename before building the LOCAL INFILE validation regular expression
3.3.4 (Jul 2026)
Notable changes
- CONJS-357: Add JavaScript SAST (CodeQL + eslint-plugin-security) to CI
Issues Fixed
- CONJS-358: Refuse multi-part packet (> 16MB) reassembly before authentication completes, a rogue server being otherwise able to exhaust client memory before any credential is even validated
- CONJS-363: typeCast accessors returned corrupted values with prepared statements
- CONJS-367: Uninitialized process memory leaked to server via malformed GeoJSON Polygon parameter (report by fg0x0)
- CONJS-368: Fixed SQL injection in text protocol when session uses NO_BACKSLASH_ESCAPES (report by fg0x0)
... (truncated)
Commits
ff43a2c[misc] type definitions: StreamCallback declared as a value it never exports2044071Merge pull request #356 from GiHoon1123/fix-sqlerror-instanceoff7009c4[misc] fix SqlError losing its constructor shape via namespace import1d9ae05[misc] command queue: never discard a command that has not starteda666b5e[misc] test correction8efc399bump 3.5.4 versionf050ee7[misc] callback API: give callbacks to the command layer instead of a promise1e79cee[misc] test addition3fdaf48[CONJS-329] Exception thrown by a callback reported as a database errora0671c2[CONJS-361] Connection stops sending commands after a command ends on the las...- Additional commits viewable in compare view
[](https://docs.github.com/en/github/managing-security-vulnerabilities/about-dependabot-security-updates#about-compatibility-scores) Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting `@dependabot rebase`. [//]: # (dependabot-automerge-start) [//]: # (dependabot-automerge-end) ---Dependabot commands and options
You can trigger Dependabot actions by commenting on this PR: - `@dependabot rebase` will rebase this PR - `@dependabot recreate` will recreate this PR, overwriting any edits that have been made to it - `@dependabot show ignore conditions` will show all of the ignore conditions of the specified dependency - `@dependabot ignore this major version` will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this minor version` will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this dependency` will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself) You can disable automated security fix PRs for this repo from the [Security Alerts page](https://github.com/dolthub/dolt/network/alerts).
go-mysql-server
- 4202: Prevent invalid intervals for Events
Adds a 1,000,000,000 limit on any unit for intervals for events.
Partially addresses: #12582
Depends on: dolthub/vitess#513
Related Issues: #12593 - 4199: Return an error instead of panicking on NULL event schedule values
- #12581:
CREATE EVENT/ALTER EVENT ... ON SCHEDULE EVERY NULL <unit>panicked with a nil pointer dereference. NULL schedule values now return the same errors as MySQL 8.4:Incorrect INTERVAL/AT/STARTS value: 'NULL'(1525), andENDS is either invalid or before STARTS(1543) for a NULLENDS. EVERYintervals that are not positive (EVERY 0 DAY,EVERY 0.4 SECOND) were accepted; they now returnINTERVAL is either not positive or too big(1542), as MySQL does.- Replaces the hardcoded MySQL error codes in
CastSQLErrorandHandleConvertWarningwith constants added in dolthub/vitess#512.
- #12581:
- 4195: Resolve expressions of an aliased insert against the alias
Resolves the duplicate-key and returning expressions of an insert with a table alias against the alias.
Companion PRs: dolthub/vitess#511, dolthub/doltgresql#3921 - 4194: Close OK and empty result iterators when reading them fails
Fixes #12568 - 4188: remove more unnecessary decimal rounding
related: dolthub/go-mysql-server#4160 - 4186: Don't resolve unqualified function names in the schema of the statement's table
Passes only a function call's own schema qualifier to the function provider, adds an override that permits check constraints to call nondeterministic functions, and shows persisted expressions through the schema formatter.
Companion PRs: #12575, dolthub/doltgresql#3909 - 4185: Merge join lookahead no longer matches rows with NULL join keys
Merge join's lookahead treated a row with a NULL join key as a match whenever the comparer returned 0 withErrNilOperand. This shows up in reversed merge joins (ORDER BY ... DESC), where NULLs come last: left joins return spurious unmatched rows and inner joins drop matches. Doltgres hits it on every merge join, since Postgres orders NULLs last (dolthub/doltgresql#3879). - 4184: Do not panic on a NULL histogram bound when estimating joins
- Join estimation panicked when a histogram bound was NULL, which a nullable join column produces after ANALYZE. A NULL bound now adds nothing to the euclidean distance. Takes over #4150.
- With NULL bounds a bucket can have zero width, so bucket alignment divided by zero and produced garbage row counts, or dropped a bucket. Cuts now fall back to an even split and stay within the bucket.
- 4179: Fix panic with control flow inside stored procedure handlers
- Fixes #12215: an IF/ELSE (or CASE/loop) inside a
DECLARE ... HANDLERbody panicked with index out of range, because handler statements ran as a flat list with no program counter. Handler bodies now use a counter so jumps work. - Requires dolthub/doltgresql#3898, which skips the new test in Doltgres since it uses MySQL-only handler syntax.
- Fixes #12215: an IF/ELSE (or CASE/loop) inside a
- 4177: Ignore trailing spaces in
PAD SPACEcollations forGROUP BY,DISTINCT, and comparisons
TEXTandVARCHARcolumns withPAD SPACEcollations (such asutf8mb4_general_ci) now ignore trailing spaces inGROUP BY,DISTINCT,COUNT(DISTINCT), and string comparisons, so values like'a'and'a 'fall into the same equivalence class.
Multi-columnGROUP BY,DISTINCT, andCOUNT(DISTINCT)queries also hash collation-equal strings with different byte lengths (such as accented vs. unaccented characters underutf8mb4_0900_ai_ci) identically while preserving column boundaries for binary and_binstrings.
Fixes #12503 - 4176: Reuse the ValueRow allocation within ProjectIter
ProjectIter.NextValueRow has two ValueRows: one with the child schema that gets passed to it's child's WriteNextValueRow, and one with the projection schema that gets returned. The returned ValueRow is newly allocated each time, but the ValueRow that is passed to its child can be reused.
In fact, it should be reused, because we are treating the ValueRow as a set of registers that are allocated once for the entire query. The iterators for keyless tables assume that the row will retain written values from one WriteNextValueRow call to the next.
This PR adds additional query tests that fail on Dolt if this invariant is accidentally broken. - 4175: Log authenticated user and client IP on new SQL connections
Emit the existinginfo-levelNewConnectionevent after authentication and session registration. Include the authenticated SQL username and the TCP peer IP alongside the connection ID and multi-statement setting.
NewConnectionnow counts authenticated sessions. Rejected credentials continue to produce the existing authentication warning. - 4167: Migrate to using ValueRowWriter for OFFSET, LIMIT, and unoptimized ORDER BY queries.
As part of the ongoing adoption of the ValueRowWriter interface, this adds support for some low-hanging fruit queries. - 4165: Project count lookup results directly to prevent alias self-references
ProjectCOUNT(*)lookup results directly, preserving the output name supplied byTableCountLookup. This avoids giving an alias the same column ID as its child field, which would cause unbounded expansion.
Theenginetestscript runners accept optional checks on analyzer output. Aggregation scripts use them to reject self-referencing aliases after each rule. Validation remains disabled by default to avoid distorting benchmark measurements.
Fixes #12500 - 4154: Compute virtual columns of the existing row for ON DUPLICATE KEY UPDATE
Fixes ON DUPLICATE KEY UPDATE reading the wrong columns of the existing row on tables with virtual columns or expression indexes.
Fixes dolthub/doltgresql#3789
Companion PR: dolthub/doltgresql#3848
vitess
- 513: allow expressions for
EVERYclause inCREATE EVENT
Any valid expression can be used in theEVERYclause for theCREATE EVENTsyntax. - 512: Add MySQL error codes used by go-mysql-server
- Adds constants for error codes go-mysql-server currently hardcodes: 1526, 1542, 1543, 1553, 1792 and the 4096 warning.
- 511: Add a table alias to Insert
Adds a table alias to Insert for PostgreSQL's INSERT INTO table AS alias.
Companion PRs: dolthub/go-mysql-server#4195, dolthub/doltgresql#3921 - 508: Add Filter to aggregate expression nodes
Adds aFilterfield for aggregateFILTER (WHERE ...)clauses toFuncExpr,GroupConcatExprandOrderedInjectedExpr.
Companion PRs: dolthub/go-mysql-server#4163, dolthub/doltgresql#3872
Closed Issues
- 12580: Query on a temporary table with an index and a contradictory WHERE (x = 1 AND x = 2) panics in index_reader.go ("index out of range [0] with length 0") and drops the client connection
- 12500: Filter on a derived table with a bare COUNT(*) crashes the sql-server (stack overflow in exprsToTableFilters)
- 10334: How to use dolt with a proxy
- 12568: A session's first read after its own failed duplicate-key INSERT returns the snapshot from before another session's commit (autocommit)
- 12038: Pushing a projection into a TableIdNode causes a divergence in the behavior of the Schema() and Columns() methods on the node
- 12519:
remotesapireturns backslash download URLs on Windows that fail with HTTP 400 - 12503: GROUP BY, DISTINCT, and COUNT(DISTINCT) disagree under explicit utf8mb4 collations
- 12553: dolt_tags returns empty set when searching for newly created tag
- 12083: DOLT_GC('--full') panics:
gcAddChunk called while no GC is ongoingwhen concurrent sessions are present - 11787: Feature request : Add support for REPLICATE_WILD_DO_TABLE, REPLICATE_WILD_IGNORE_TABLE and a way to persist values between reboots.
- 12328: sql-server with a git remote: nbs-spool-* temp files are never cleaned after an unclean stop, and the live set holds a full copy of the remote
- 12501: Unexpected ANTI JOIN Result
- 12215: Stored Procedure with IF/ELSE block in EXIT HANDLER Panics
- 1497: memory database with binary column cannot be updated