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

FTS:match query not returning the results

    XMLWordPrintable

Details

    • Untriaged
    • 1
    • Yes

    Description

      Build: 6.6.0 build 7716

      • Load the dataset attached
      • Create an index like below:

        {
          "type": "fulltext-index",
          "name": "default_index",
          "uuid": "7db53797cfab72d2",
          "sourceType": "couchbase",
          "sourceName": "default",
          "planParams": {
            "maxPartitionsPerPIndex": 171
          },
          "params": {
            "doc_config": {
              "docid_prefix_delim": "",
              "docid_regexp": "",
              "mode": "type_field",
              "type_field": "type"
            },
            "mapping": {
              "analysis": {},
              "default_analyzer": "standard",
              "default_datetime_parser": "dateTimeOptional",
              "default_field": "_all",
              "default_mapping": {
                "dynamic": false,
                "enabled": false
              },
              "default_type": "_default",
              "docvalues_dynamic": true,
              "index_dynamic": true,
              "store_dynamic": false,
              "type_field": "_type",
              "types": {
                "emp": {
                  "default_analyzer": "keyword",
                  "dynamic": true,
                  "enabled": true
                }
              }
            },
            "store": {
              "indexType": "scorch",
              "mossStoreOptions": {}
            }
          },
          "sourceParams": {}
        }
        

      • Below query isn't returning the expected results (which was returing in 6.5.1 build 6292, now returning 0 results)

        curl -XPOST -H "Content-Type: application/json" \
        -u <username>:<password> http://172.23.121.67:8094/api/index/default_index/query \
        -d '{
          "explain": true,
          "fields": [
            "*"
          ],
          "highlight": {},
          "query": {
            "query": "name:Safiya"
          }
        }'
         
         
        curl -XPOST -H "Content-Type: application/json" -u Administrator:password http://172.23.121.67:8094/api/index/default_index/query -d '{
          "explain": true,
          "fields": [
            "*"
          ],
          "highlight": {},
          "query": {
            "field": "name", "match":"Safiya"       
          }
        }'
         
         
        Expected results:
         
        [
          {
            "id": "emp10000001",
            "name": "Safiya Palmer"
          },
          {
            "id": "emp10000042",
            "name": "Safiya Reed"
          }
        ]
        
        

      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:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty