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.
- 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
The highlighted query (only) to execute and show results.
Error message: "you cannot issue more than one query at once. Please remove all text after the semicolon closing the first query"
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.