microsoft / microsoft/vscode-mssql
[Bug]: Invalid String Length
- 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