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

plans set via encoded_plan REST parameter may return wrong results

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 4.6.2, 5.0.0
    • 4.5.1, 4.6.0, 5.0.0
    • query
    • None
    • Untriaged
    • Unknown

    Description

      This is related to CBSE-3291 - from which I have simplified the testcase considerably:

      • have beer-sample
      • create an index on `beer-sample`(name, country, code) where (type="brewery")
      • prepare s1 from SELECT name, IFMISSINGORNULL(country,999), IFMISSINGORNULL(code,999) FROM `beer-sample` WHERE type = "brewery" AND name IS NOT MISSING;
      • copy the encoded_plan
      • bring down and restart the n1ql service
      • pass a request to the engine using s1 as prepared and the encoded_plan copied earlier as the, well, encoded_plan.

      The result set will be empty rather than having 1412 entries

      Attachments

        Issue Links

          blocks

          Task - A task that needs to be done. MB-22188 4.6.2 Minor Release

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MB-23073 with index2 api enabled encoded_plan doesn't work properly

          • Major - Major loss of function.
          • Closed
          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            People

              ajay.bhullar Ajay Bhullar
              marco.greco Marco Greco (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              10 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                PagerDuty