microsoft / microsoft/vscode-mssql

[Bug]: Invalid String Length

Open
#22,838 0 comments 0 reactions 0 assignees View on GitHub
Bug Triage: Needed User-filed
Dominant language
TypeScript
Stars
1.9k
Forks
610
Avg merge
2d 3h
Merged PRs (30d)
97

Description

### Description

I run a query a in SQL notebook that simply join two tables in a cell and as a return i get "Error: Invalid string length". The same query run in a sql file in vs code without any issue.
The query returns 193,010 rows. If in the cell i put select top 100 it works
Version of the extension is
1.45.1

### Steps to Reproduce

1. Connect to the database
2. Run a select statement with a large result set (e.g with the same order of magnitude of the test case above)
3. Verify the Error returned by the system

### Affected Area

- [ ] Connection dialog (SQL Server | Azure browse/Fabric browse)
- [ ] Query editor
- [x] Query results panel
- [ ] Object Explorer
- [ ] GitHub Copilot integration
- [ ] Preview/Edit data
- [ ] Table Designer
- [ ] Schema Designer
- [ ] Schema Compare
- [ ] Local SQL Server Container provisioning
- [ ] SQL database in Fabric provisioning
- [ ] DACPAC/BACPAC export/import
- [ ] SQL Database projects
- [ ] Query Plan Visualizer
- [x] Other (please describe below)

### If you selected "Other", please describe the affected area

SQL Notebook

### Environment Information

vs code 1.135.0
mssql 1.45.1
windows 11

### Confirmation

- [x] I have searched existing issues and couldn't find a match
- [ ] I want to work on this issue

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by reproducing the failure in a SQL Notebook with a result set around 193,010 rows, then compare it with the same query in a SQL file in VS Code. Inspect the SQL Notebook and query results panel behavior for large results; done means the result loads without "Invalid string length" while the existing top-100 case still works.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql, typescript
Domain
databases, tooling
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Active
Clarity
Mostly clear
Newbie friendliness
52/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.