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.
Attachments
For Gerrit Dashboard: MB-26012 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
83309,2 | MB-26012. Add OrderedIntersectScan operator | master | query | Status: MERGED | +2 | +1 |
83316,2 | MB-26012. Add OrderedIntersectScan operator | spock | query | Status: MERGED | +2 | +1 |
83321,2 | MB-26012. Add OrderedIntersectScan operator | watson | query | Status: MERGED | +2 | +1 |
83403,2 | MB-26012 - Update sha for query 5.0.0 | master | manifest | Status: MERGED | +2 | +1 |