node.js - N1ql -> IN operator does not work with other conditions -
the next query works fine when in operator used select meta().id bucket_name description in ['item1','item2']
but when fire query gives me blank result select meta().id bucket_name id = 123 , description in ['item1','item2']
am doing wrong or else has faced same problem?
i think have take "in" status parenthesis create work:
select meta().id bucket_name id = 123 , (description in ['item1','item2'])
it has precedence level of operators evaluation n1ql processor
if run explain keyword show how links conditions against each other.
e.g.
explain select meta().id bucket_name id = 123 , (description in ['item1','item2'])
vs
explain select meta().id bucket_name id = 123 , description in ['item1','item2']
node.js couchbase n1ql
No comments:
Post a Comment