Skip to content

Queries with larger than 4040 characters will break the connection to mssql db server using official mtxr mssql driver #1497

@SadeghPouriyanZadeh

Description

@SadeghPouriyanZadeh

Describe the bug
When I use SQLTools and mssql driver extensions in vscode and make a connection to our companies mssql database and fetch a query with characters longer than 4040, i get a ECONNRESET error immediately. I know that it's a bug because when i use Microsoft official mssql extension and run the same querry, i get the results. I even created a dummy query so that only the characters would be long and no functionality would be done, and i get the same error again.

To Reproduce
Steps to reproduce the behavior:

  1. write a query longer than 4040 characters.
  2. run it using Ctrl + E twice.
  3. See error

Expected behavior
I want to run long queries and I fetch the result correctly as I can get using Microsoft official mssql extension in vscode.

Screenshots
i get this error:

Image

Desktop (please complete the following information):

  • SQLTools Version 0.28.4
  • VS Code Version: 1.101.2
  • OS: Linux Mint 22.1 x86_64
  • Driver:
    • MSSQL/Azure
  • Database version: MSSQL 15.0.4430.1

Metadata

Metadata

Assignees

No one assigned

    Labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions