Friday 15 June 2012

node.js - N1ql -> IN operator does not work with other conditions -



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