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

Prepared queries containing a where clause fail on multiple requests.

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Major
    • 4.0.0
    • 4.0.0
    • query
    • Security Level: Public
    • None
    • Untriaged
    • Unknown

    Description

      When executing a prepared statement in the Go SDK, we first prepare it by prefixing PREPARE, then we follow through by actually executing the plan. We do this by passing a the prepared and encoded_plan fields. When executing a query which includes no where clause, this works as expected. Each ‘invocation’ of the same prepared plan executes correctly, however upon introducing a where clause to the query, the plan only executes once successfully, and all following executions return success but no results. This behaviour is confirmed to occur in our C/C++ SDK as well.

      Works:
      SELECT airportname FROM `travel-sample` ORDER BY airportname ASC LIMIT 20

      Fails:
      SELECT airportname FROM `travel-sample` WHERE type='airport' ORDER BY airport name ASC LIMIT 20

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            colm Colm Mchugh (Inactive)
            brett19 Brett Lawson
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty