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

[CBAS] Query workbench hangs for an invalid query

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • CBAS DP
    • CBAS DP
    • analytics
    • None
    • Untriaged
    • Unknown

    Description

      CBAS Build : 265

      The Query workbench UI just hangs when the following invalid query is issued. The Cancel button on the UI doesn't work either. The only alternative is to refresh the page and get going.

      SELECT br.brewery_id, COUNT AS num_beers
      FROM beers br
      GROUP BY br.brewery_id
      HAVING num_beers > 30 and br.brewery_id not null;

      The same query when executed through REST API/cbq errors out as expected - "msg": "Syntax error: In line 1 >> SELECT br.brewery_id, COUNT AS num_beers FROM beers br GROUP BY br.brewery_id HAVING num_beers > 30 and br.brewery_id not null;<< Encountered \"not\" at column 123. "

      Attachments

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

        Activity

          People

            mihir.kamdar Mihir Kamdar (Inactive)
            mihir.kamdar Mihir Kamdar (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty