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

Analytics workbench : Using == results in CompilationException where as the same works on N1QL

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Duplicate
    • 6.0.0
    • 6.0.0
    • analytics
    • Enterprise Edition 6.0.0 build 1330 ‧ IPv4
    • Untriaged
    • Centos 64-bit
    • Unknown

    Description

      A where condition with == works on N1QL workbench where as fails on Analytics with error "msg": "Syntax error.  default is my dataset name

      select * from default where age == 25 limit 1
      

      Exception in logs:

      2018-07-19T12:58:37.135Z WARN CBAS.apache.asterix [Executor-3:ClusterController] ASX1001: Syntax error: In line 1 >>select * from default where age == 25 limit 1;<< Encountered "=" at column 33.
      org.apache.asterix.common.exceptions.CompilationException: ASX1001: Syntax error: In line 1 >>select * from default where age == 25 limit 1;<< Encountered "=" at column 33.
      at com.couchbase.analytics.lang.parser.CBSQLPPParser.parse(CBSQLPPParser.java:292) ~[cbas-connector.jar:6.0.0-1330]
      at org.apache.asterix.app.message.ExecuteStatementRequestMessage.handle(ExecuteStatementRequestMessage.java:119) [asterix-app.jar:6.0.0-1330]
      at org.apache.asterix.messaging.CCMessageBroker.receivedMessage(CCMessageBroker.java:66) [asterix-app.jar:6.0.0-1330]
      at org.apache.hyracks.control.cc.work.ApplicationMessageWork$1.run(ApplicationMessageWork.java:59) [hyracks-control-cc.jar:6.0.0-1330]
      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_162]
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_162]
      at java.lang.Thread.run(Thread.java:748) [?:1.8.0_162]
      

      My assumption is the behaviour must be same as N1QL.

      Attachments

        Issue Links

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

          Activity

            People

              tanzeem.ahmed Tanzeem Ahmed (Inactive)
              tanzeem.ahmed Tanzeem Ahmed (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