I have a n1ql command that I run, and about half the time it gives me an error, and the other half it gives me the expected results. Nothing about this statement changes, and I find that odd. The data is also consistent from run to run. Perhaps, someone can tell me why it’s doing that, and if maybe I have the wrong statement.
SELECT p FROM Page_Bucket p JOIN Company_Bucket c ON KEYS p.companyId WHERE ARRAY_CONTAINS(c.aryDomains, “test”);
the error is:
SyntaxError: Unexpected end of input
at parse (native)