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

FTS index is not chosen when query has OR predicate

    XMLWordPrintable

Details

    • Untriaged
    • Unknown

    Description

      Reported by Keshav Murthy

      Create FTS dynamic index with keyword analyzer
      EXPLAIN select name from `travel-sample` AS t use index (using fts) where search(t, "garden") OR type = 'hotel';

      Attachments

        For Gerrit Dashboard: MB-38813
        # Subject Branch Project Status CR V

        Activity

          People

            girish.benakappa Girish Benakappa
            Sitaram.Vemulapalli Sitaram Vemulapalli
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty