New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Large query never ends for second run #18529

Open

Szunti opened this issue Dec 19, 2024 · 0 comments

Szunti commented Dec 19, 2024

MSSQL Extension Version:
1.27.0
VSCode Version:
1.96.1
OS Version:
Windows 10.0.19045

Steps to Reproduce:

I have AdventureWorks 2019 OLTP restored into an SQL Server Express 2019
When I first run the following SQL, clicking on the play button in the tabbar it starts normally and ends after a couple seconds.

USE AdventureWorks2019

SELECT *
FROM [Sales].[SalesOrderHeader] o
INNER JOIN [Sales].[SalesOrderDetail] od ON o.SalesOrderID = od.SalesOrderID

Now if I click on the play button again the stop button doesn't appear and it runs indefinitely while constantly using up all the memory I have.

Not server or database specific, it originally happened on Sql Server 2016 with another query with thousands of rows.

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