Skip to content

[Bug] SQL Server error 3981 on minimal COMMIT TRANSACTION #44

Closed

Description

@qazs10015

Summary

Executing a minimal SQL Server transaction with COMMIT TRANSACTION
fails in Tabularis with SQL Server error 3981.

The same SQL works correctly in DBeaver using JDBC.

Steps to Reproduce

  1. Connect to Microsoft SQL Server using the SQL Server Plugin.
  2. Open a SQL Console.
  3. Execute the following SQL as a single batch:
BEGIN TRANSACTION;
COMMIT TRANSACTION;
Image

Activity

  1. debba commented on Oct 25, 2026

    @debba
    Contributor

    Verified through the real plugin JSON-RPC boundary against SQL Server: both BEGIN TRANSACTION; COMMIT TRANSACTION; and a transaction that inserts a row, commits and reads it back succeed with the beta.4 candidate (mssql-tds 0.2.0). The transaction count returns to zero.

    PR #54 adds a permanent live regression test and prepares v1.0.0-beta.4. All 34 live database tests pass locally; the release is waiting for the remaining build/CI gates.

  2. debba commented on Oct 25, 2026

    @debba
    Contributor

    Fixed in v1.0.0-beta.4.

    We verified the exact BEGIN TRANSACTION; COMMIT TRANSACTION; batch from this report, plus a transaction that inserts a row and commits successfully. Both are now covered by a live SQL Server regression test, and the published macOS ARM64 binary passes it too.

    Please update the SQL Server plugin to v1.0.0-beta.4 and try again. If error 3981 still occurs with this version, please let us know your SQL Server version and the batch that triggers it so we can investigate.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions