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

[CX] == not supported by CBAS

    XMLWordPrintable

Details

    Description

      Query issued:
      SELECT name FROM default_shadow WHERE name == 'employee-4';

      Error reported:
      [2016-10-13 17:38:05,175] - [rest_client:786] ERROR - http://172.23.108.232:8095/analytics/service?scan_consistency=REQUEST_PLUS&creds=%5B%5D&statement=SELECT+name+FROM+default_shadow+WHERE+name+%3D%3D+%27employee-4%27%3B error 400 reason: unknown {
      "requestID": "3ed92134-a4dc-4512-8a66-3b54edd8ba58",
      "signature": "*",
      "errors": [

      { "code": "1", "msg": "Syntax error: In line 1 >>SELECT name FROM default_shadow WHERE name == 'employee-4';<< Encountered \"=\" at column 44. " }

      ],
      "status": "fatal",
      "metrics":

      { "elapsedTime": "1.483643ms", "executionTime": "0ns", "resultCount": "0", "resultSize": "0" }

      }
      ERROR

      Above query works well in n1ql.

      Attachments

        Issue Links

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

          Activity

            Prerna Manaktala, for now, can you use "=" instead of "=="?

            yingyi Yingyi Bu (Inactive) added a comment - Prerna Manaktala , for now, can you use "=" instead of "=="?

            Decided not to document this for DP1 - it's a really minor difference and non-standard SQL - it's unlikely that someone will encounter this.

            will.gardella Will Gardella (Inactive) added a comment - Decided not to document this for DP1 - it's a really minor difference and non-standard SQL - it's unlikely that someone will encounter this.

            Bulk closing invalid, duplicate and won't fix bugs

            raju Raju Suravarjjala added a comment - Bulk closing invalid, duplicate and won't fix bugs

            People

              till Till Westmann
              Prerna.Manaktala Prerna Manaktala (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty