Unable to run individual queries from editor

[telekosmos]

Just updated vscode dbcode extension to 1.17.29 in vscode Version: 1.105.1, MacOS 15.3.1 (24D70). When selecting a database on a SQL file, I was able to run a query from the editor just by placing the cursor somewhere in the query and pressing CMD+Enter. Now, when doing that, all queries in the file are executed.

To reproduce:

• in database explorer, right-click in a database and select Create New SQL File (or click the button with same funcionality at right side)
• type any two simple queries
• press CMD+Enter
• All queries are run and results show at bottom panel

Expected behaviour (or previous one as I was seeing):

• just the query on focus (cursor in the query) is executed

Not sure if this is a bug or new behaviour/feat. Read the last ChangeLogs and didn't see anything.

Thanks for your job!

[mikeburgh]

Is this by chance sql server ? .29 updated it to use the go keyword as a statement boundary which matches sql server behavior, but it is different to the others which use ; I debated the change as it was different, guess I might have got it wrong and should treat both as boundaries…

If it's not sql server, does the statement highlighting highlight just the single statement or the whole file ?

[telekosmos]

It is sql server indeed and the go keyword after every query did the trick. For others who can fall here, it seems you have to use

select 1;
go

So the semicolon still necessary.
Did I miss the change in the changelog or it just was missing there?

Feel free to close the issue and thanks!

[mikeburgh]

The change yesterday was fixing the bug that go statements were being ignored (came up in Discord).. it was not in the change log.. but the change to statement parsing was back in 1.17.17.

I have just updated it again to treat both ; and go as boundaries.. while not technically correct in the eyes of SQL Server, it's more consistent with what people expect.. and SQL server still lets you execute:

declare @x INT
set @x = 1
select @x

as a valid single statement…

Will update it when I release the change.

[mikeburgh]

Fixed in 1.17.30 which has been released.