Details

    • Technical task
    • Resolution: Fixed
    • Major
    • None
    • None
    • None
    • None
    • DOC-2022-S14, DOC-2022-S15

    Description

      Pls add this detail about 8K to the IN/WITHIN documentation.
      https://developer.couchbase.com/documentation/server/4.5/n1ql/n1ql-language-reference/collectionops.html
       
      thanks,
      -Prasad
       
      Hi Ketaki,
       
      IN is perfect for this. Up to 8192 values currently.
       
      Gerald
       
      From: Ketaki Gangal <Ketaki@couchbase.com>
      Date: Monday, January 16, 2017 at 10:40 AM
      To: Query <query@couchbase.com>
      Subject: Question about larger number of 'IN' values
       
      Hello Query team,  
      A customer is interested in having say 200 ( dynamic values, i.e. they don’t know these values ahead of time) in the IN clause of a query.
       
      Question
      Is something like ‘select a,b,c from table where a in [val1, val2, … , val200] efficient from a query perspective?
       
      Can we do something more suitable for this use-case, i.e. replace IN with any other approach.
       
      thanks!
      Ketaki

      Attachments

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

        Activity

          People

            simon.dew Simon Dew
            Prasad.Varakur Prasad Varakur
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty