Skip to content

[Bug]: Query results do not always render row contents #22244

@strandloper

Description

@strandloper

Description

When I execute SELECT queries I expect the returned rows to be rendered in the results pane so I can examine them. But sometimes they are not. As the screenshot shows, in this example, the query returned two rows and the empty rows are drawn but not populated with the content.

Image

If I re-execute the query the result may be the same or the results may render correctly. Repeated re-execution sometimes shows the results correctly and sometimes not. There seems to be no pattern to it. In the latest case, I have four SELECT statements in the query returning results, and only one of them is doing this. The others seem to render correctly every time.

I have seen this problem occur randomly since I began using the MSSQL extension so it has not been newly introduced.

Steps to Reproduce

  1. Connect to a database
  2. Execute a query with one or more SELECT statements.
  3. Observe that row contents may not be rendered, seemingly at random.

Affected Area

  • Connection dialog (SQL Server | Azure browse/Fabric browse)
  • Query editor
  • 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
  • Other (please describe below)

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

No response

Environment Information

• VS Code Version: 1.120.0
• MSSQL Extension Version: 1.42.2
• Operating System: Windows 11
• Connection Type (SQL database in Fabric, Azure SQL SQL Server, etc.): SQL Server

Confirmation

  • I have searched existing issues and couldn't find a match
  • I want to work on this issue

Metadata

Metadata

Assignees

No one assigned

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions