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

avoiding full scan on whole IN clause as query parameter.

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Fixed
    • Critical
    • 4.6.2, 5.0.0
    • 4.5.1, 4.6.0
    • query
    • None

    Description

      Currently we push to indexer if individual IN clause elements are query parameters.
      like select meta().id from default where id IN [ 10,11,$1,$2,13,14];

      If whole IN clause it self is query parameter not possible to push to indexer. Number of elements are not known at the prepare time only way to do is use whole IN clause as query parameter.
      like select meta().id from default where id IN $2

      Attachments

        Issue Links

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

          Activity

            People

              Prerna.Manaktala Prerna Manaktala (Inactive)
              Sitaram.Vemulapalli Sitaram Vemulapalli
              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