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

N1QL Search queries that involve verification fail when "fields" are included in the search request

    XMLWordPrintable

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • Neo
    • Neo
    • fts
    • Untriaged
    • 1
    • Unknown

    Description

      SELECT meta() from `travel-sample` as t
      WHERE SEARCH(t, {"query": {"query": "travel"}, "fields": ["*"]})
      LIMIT 1; 

      [
        {
          "code": 5000,
          "msg": "n1fty: search failed - cause: index read inconsistency detected",
          "query": "SELECT meta() from `travel-sample` as t\nWHERE SEARCH(t, {\"query\": {\"query\": \"travel\"}, \"fields\": [\"*\"]})\nLIMIT 1;"
        }
      ] 

      This issue is seen only in validation with blevesearch/sear.

      Attachments

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

        Activity

          abhinav Abhinav Dangeti added a comment - https://github.com/blevesearch/sear/pull/12 https://review.couchbase.org/c/n1fty/+/166949 https://review.couchbase.org/c/query/+/166950  

          Build couchbase-server-7.1.0-1839 contains n1fty commit 51bd2fe with commit message:
          MB-49888: Upgrade to blevesearch/sear@v0.0.5 to include a fix

          build-team Couchbase Build Team added a comment - Build couchbase-server-7.1.0-1839 contains n1fty commit 51bd2fe with commit message: MB-49888 : Upgrade to blevesearch/sear@v0.0.5 to include a fix

          Build couchbase-server-7.1.0-1839 contains query commit 1f1bd63 with commit message:
          MB-49888: Upgrade to blevesearch/sear@v0.0.5

          build-team Couchbase Build Team added a comment - Build couchbase-server-7.1.0-1839 contains query commit 1f1bd63 with commit message: MB-49888 : Upgrade to blevesearch/sear@v0.0.5

          People

            abhinav Abhinav Dangeti
            abhinav Abhinav Dangeti
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty