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

FTS: N1FTY: for non-covering queries n1fty expects query should contain index_name or analyzer for NEG cases of match and match_phrase queries

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Major
    • backlog
    • 6.5.1, 6.6.0, Cheshire-Cat
    • fts
    • Untriaged
    • 1
    • Unknown

    Description

      In NEG cases if the index uses a non-standard analyzer, N1FTY expects, query should contain index_name or analyzer (for non-covering queries such as SELECT * etc.) for example

      SELECT * from keyspace WHERE SEARCH(keyspace, "-dept:Sales", {"index":"index_name"});
      		 
      SELECT *
      		 
      FROM keyspace
      		 
      WHERE SEARCH(keyspace, {"must_not": {"disjuncts":[{"field": "dept", "match": "Sales", "analyzer":"keyword"}]}});

       

      See more: Description of MB-39592.

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MB-49358 N1fty: N1ql search not honoring keyword text analyzer for neg cases

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MB-39592 [N1QL+FTS] Mandate keyword analyzer for queries that don't use an analyzer

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          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:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty