Skip to content

2.7.6

Latest

Choose a tag to compare

@github-actions github-actions released this 21 Nov 03:47

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 intermittent TestDoltCommits failure (expected 5 commits, got 4). The binlog replica advanced @@gtid_executed and saved its position before running dolt_commit for the transaction, so anything waiting on gtid_executed could 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 in remotesrv: read only server rejects writes and the two shallow-clone: fsck passes tests. 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 from filepath.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 during dolt sql-server invocations.
  • 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

    New Contributors

    Full Changelog: klauspost/compress@v1.18.5...v1.18.6

    v1.18.5

    What's Changed

    Full Changelog: klauspost/compress@v1.18.4...v1.18.5

    v1.18.4

    What's Changed

    New Contributors

    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

  • 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)

    Full Changelog

    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 maxAllowedPacket value when the option is not set
    • CONJS-360: batch() ignored the insertIdAsNumber / supportBigNumbers / bigNumberStrings options 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 / TypeNumbers enums 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)

    Full Changelog

    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 maxAllowedPacket value when the option is not set
    • CONJS-360: batch() ignored the insertIdAsNumber / supportBigNumbers / bigNumberStrings options 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 / TypeNumbers enums 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)

    Full Changelog

    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)

    Full Changelog

    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 exports
    • 2044071 Merge pull request #356 from GiHoon1123/fix-sqlerror-instanceof
    • f7009c4 [misc] fix SqlError losing its constructor shape via namespace import
    • 1d9ae05 [misc] command queue: never discard a command that has not started
    • a666b5e [misc] test correction
    • 8efc399 bump 3.5.4 version
    • f050ee7 [misc] callback API: give callbacks to the command layer instead of a promise
    • 1e79cee [misc] test addition
    • 3fdaf48 [CONJS-329] Exception thrown by a callback reported as a database error
    • a0671c2 [CONJS-361] Connection stops sending commands after a command ends on the las...
    • Additional commits viewable in compare view

    [![Dependabot compatibility score](https://dependabot-badges.githubapp.com/badges/compatibility_score?dependency-name=mariadb&package-manager=npm_and_yarn&previous-version=3.5.3&new-version=3.5.4)](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), and ENDS is either invalid or before STARTS (1543) for a NULL ENDS.
    • EVERY intervals that are not positive (EVERY 0 DAY, EVERY 0.4 SECOND) were accepted; they now return INTERVAL is either not positive or too big (1542), as MySQL does.
    • Replaces the hardcoded MySQL error codes in CastSQLError and HandleConvertWarning with constants added in dolthub/vitess#512.
  • 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 with ErrNilOperand. 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 ... HANDLER body 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.
  • 4177: Ignore trailing spaces in PAD SPACE collations for GROUP BY, DISTINCT, and comparisons
    TEXT and VARCHAR columns with PAD SPACE collations (such as utf8mb4_general_ci) now ignore trailing spaces in GROUP BY, DISTINCT, COUNT(DISTINCT), and string comparisons, so values like 'a' and 'a ' fall into the same equivalence class.
    Multi-column GROUP BY, DISTINCT, and COUNT(DISTINCT) queries also hash collation-equal strings with different byte lengths (such as accented vs. unaccented characters under utf8mb4_0900_ai_ci) identically while preserving column boundaries for binary and _bin strings.
    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 existing info-level NewConnection event after authentication and session registration. Include the authenticated SQL username and the TCP peer IP alongside the connection ID and multi-statement setting.
    NewConnection now 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
    Project COUNT(*) lookup results directly, preserving the output name supplied by TableCountLookup. This avoids giving an alias the same column ID as its child field, which would cause unbounded expansion.
    The enginetest script 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 EVERY clause in CREATE EVENT
    Any valid expression can be used in the EVERY clause for the CREATE EVENT syntax.
  • 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 a Filter field for aggregate FILTER (WHERE ...) clauses to FuncExpr, GroupConcatExpr and OrderedInjectedExpr.
    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: remotesapi returns 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 ongoing when 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