Description
Summary: After giving a N1QL demo using Query Workbench around 300 times, one of the behaviors I'm seeing is people writing multiple queries in the workbench, highlighting a query, and hitting execute to attempt to only execute a single query. The "Execute" button seems to ignore anything highlights.
Repro:
- Open Query Workbench.
- Write two queries in it (e.g. SELECT * FROM `travel-sample` where type = 'airline' LIMIT 10;
SELECT * FROM `travel-sample` where type = 'landmark' LIMIT 10; ) - this part is challenging since ; + enter runs 'execute', but it can be done. - Highlight one of the queries (mouse click + drag, or shift+keyboard arrow)
- Click the 'Execute' button
Expected:
The highlighted query (only) to execute and show results.
Actual:
Error message: "you cannot issue more than one query at once. Please remove all text after the semicolon closing the first query"
Notes:
See attached gif.
This is common behavior for other query workbench tools including (but not limited to) SQL Server Management Studio. So it is behavior that is expected by developers/DBAs and it is surprising and confusing when Couchbase's Query Workbench doesn't work the same way.