Details
Description
Looks like https://github.com/couchbase/query/blob/master/plan/op_registry.go
has missing OrderedIntersectScan plan operator
https://forums.couchbase.com/t/errors-code-4070-with-message-unable-to-decode-prepared-statement-cause-unrecognizable-prepared-statement-cause-json-unmarshalling-error-no-operator-for-name-distinctscan-when-query-data-by-rest-api-of-prepared-statement/9519/4
ClientContextId: Message: Error: 4070 Unable to decode prepared statement
cause: Unrecognizable prepared statement
cause: JSON unmarshalling error: No operator for name OrderedIntersectScan
The strange thing is sometimes the query returns result, sometimes it gives me this error.
The query is formed like this:
SELECT autocompleteInfo.* FROM products
WHERE 1 = 1 AND type <> 'shop'
AND stats.rankingPosition is not missing
AND ANY v IN searchKeyA SATISFIES v = $1 END
[AND ANY v IN searchKeyA SATISFIES v = $2 END ...]
ORDER BY stats.rankingPosition
LIMIT 7;
I’m running 4.6.3 EE on server.