Uploaded image for project: 'Couchbase Documentation'
  1. Couchbase Documentation
  2. DOC-4542

Issues on limitations when using IN clause on index creation

    XMLWordPrintable

Details

    • 1

    Description

      Please add to CREATE INDEX docs the following limitations:

      • When using clause IN, queries must use the same IN terms in the same order than Index.

      The following index:

      CREATE INDEX indexIn on bucket(field1) WHERE field1 IN ["A","B","C"];
      

      Will only works if the query has the exact in clause or single equal value:

      SELECT * from bucket WHERE field1 IN ["A","B","C"];
      SELECT * from bucket WHERE field = "A"; -- OR B OR C
      

      Attachments

        Issue Links

          Activity

            People

              simon.dew Simon Dew
              Raymundo.Flores Raymundo Flores (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                PagerDuty