Problem running multiple queries in one editor

[gjsjohnmurray]

If I have these two queries in one editor and click on "Run active connection", I get a multiple query result window with two tabs, both show "Query returned 0 rows", while I would expect to see one row coming back from the second query. If I add a third line, just a commented empty line ("--"), then I get three tabs, the two first say query returned 0 rows, and the third one returns the one row I am expecting from my select query.

I would expect the results from the select query would come back in the second tab.

Originally posted by @ofajardo in https://github.com/mtxr/vscode-sqltools/issues/877#issuecomment-945587138