Details
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
- duplicates
-
MB-21353 [CX] == not supported by CBAS
-
- Closed
-