Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-30633

Query highlighting in Query Workbench (usability)

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Unresolved
    • Major
    • None
    • 5.5.0
    • UI

    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:

      1. Open Query Workbench.
      2. 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.
      3. Highlight one of the queries (mouse click + drag, or shift+keyboard arrow)
      4. 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.

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            Unassigned Unassigned
            matthew.groves Matthew Groves
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty