SQLITE_MISUSE on comments after command in the same line

[yilmazdurmaz]

Describe the bug

I added some more queries to my running-fine file and suddenly SQLITE_MISUSE: not an error started to come out.

It took me some time to find the cause: trying to document the lines in-line and this happens.

I confirmed the behavior by selecting the lines only up to the comment and it runs fine.

To Reproduce Steps to reproduce the behavior:

1. try running this line: SELECT * FROM some_table;
2. try running this line: SELECT * FROM some_table; -- comment

Expected behavior Comments are natural part of queries. they should be just omitted when running, not cause issues like this.

Screenshots

Desktop (please complete the following information):

• SQLTools Version: latest to date
• VS Code Version: latest to date
• OS: W10 21H2 latest to date
• Driver:
  • [ ] PostgreSQL/Redshift
  • [ ] MySQL/MariaDB
  • [ ] MSSQL/Azure
  • [x ] SQLite
  • [ ] Other? Which...
• Database version: latest to date (whatever auto-installed by the extension by node 18.9.0)

Additional context Add any other context about the problem here.