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

FlexIndex: multitypemapping: FTS index not sargable if predicate field is not indexed in all typemapping in index

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Major
    • None
    • Cheshire-Cat
    • fts
    • Untriaged
    • 1
    • Unknown

    Description

      Build: 7.0.0-2005

      Steps to reproduce:
      have a type mapped index with 2 type mapping : emp and wiki
      have "name" fileld indexed only in emp type mapping
      for below flex query, fts index is not Sargable

      select meta().id from default USE INDEX (USING FTS, USING GSI) where type = "emp" or type = "wiki" and name = "Kory Palmer"

      if we have parentheses around "type" predicate like below, FTS index is sargable

      select meta().id from default USE INDEX (USING FTS, USING GSI) where (type = "emp" or type = "wiki") and name = "Kory Palmer"

      Attachments

        Issue Links

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

          Activity

            People

              abhinav Abhi Dangeti
              girish.benakappa Girish Benakappa
              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