Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-26012

Prepare statements not able to decode OrderedIntersectScan

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 4.6.4, 5.0.0, 5.1.0, 5.5.0
    • 4.6.4, 4.6.3, 5.0.0
    • query
    • None
    • Untriaged
    • Unknown

    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

        Activity

          People

            Prerna.Manaktala Prerna Manaktala (Inactive)
            Sitaram.Vemulapalli Sitaram Vemulapalli
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty