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

Query commenting in Query Workbench (usability)

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Unresolved
    • Minor
    • None
    • None
    • UI

    Description

      Summary: Commenting in the query workbench causes the syntax highlighting to change, but a query with comments in it will cause an error.

      Repro:

      1. Open Query Builder
      2. Enter a valid query and some comments. (example:
        1. – this is a comment
        2. SELECT * FROM `travel-sample` LIMIT 10;
      3. Click execute

      Expected:

      The comment to be ignored and the un-commented query to execute.

      Actual:

      Error message: syntax error

      Notes:

      In the 5.5 release, using "–" for commenting doesn't seem to affect the syntax highlighting anymore. Still, "–" or "#" is widely expected by SQL users to function as a comment, as I have observed giving a N1QL demo to 200-300 people at recent conferences.

      Attachments

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

        Activity

          People

            keshav Keshav Murthy
            matthew.groves Matthew Groves
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty