openCypher
openCypher copied to clipboard
Validating ``WHERE (value in property)``
Hi, I have a question about the following query:
CREATE (a{z:1}), (b{z:'a'}), (c{z:[1,2]}), (d)
MATCH (a) WHERE (1 in a.z) RETURN a
a.z is not a list, then I'm not sure what of the following options is the expected result:
- Type mismatch error, because IN expects a list as argument.
- Process each a.z individually, and if a.z is a list returns
1 in a.z, else return1 = a.zFor the example above, the result would be:TRUE,FALSE,TRUE,NULL
Thanks in advance