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

[N1FTY] Querying for non-indexed field returns zero results with type-mapped index in the query

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 7.0.0
    • Cheshire-Cat
    • fts
    • Untriaged
    • 1
    • Yes

    Description

      Build: 7.0.0 build 5294

      • Create a cluster with fts and query
      • Load some documents in default bucket.
        Example doc:

        {
          "emp_id": "10000025",
          "name": "Gabi Phillips",
          "dept": "HR",
          "email": "gabi@mcdiabetes.com",
          "salary": 88415.97,
          "join_date": "1999-01-06T20:59:00",
          "languages_known": [
            "French",
            "Hindi",
            "Urdu"
          ],
          "is_manager": true,
          "mutated": 0,
          "type": "emp",
          "manages": {
            "team_size": 7,
            "reports": [
              "Araceli Davis",
              "Severin Palmer",
              "Cynara Ángel",
              "Beryl Walker II",
              "Kerry Wells",
              "Amara Damián",
              "Kory Josué"
            ]
          }
        }
        

      • Create type mapped index with below:

        {
          "type": "fulltext-index",
          "name": "custom_index",
          "uuid": "501235bf79234fee",
          "sourceType": "gocbcore",
          "sourceName": "default",
          "sourceUUID": "afb1121d6b7bd18abc4f8175e4b100a8",
          "planParams": {
            "maxPartitionsPerPIndex": 1024,
            "indexPartitions": 1
          },
          "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": true,
                "enabled": false
              },
              "default_type": "_default",
              "docvalues_dynamic": true,
              "index_dynamic": true,
              "store_dynamic": false,
              "type_field": "type",
              "types": {
                "emp": {
                  "dynamic": false,
                  "enabled": true,
                  "properties": {
                    "is_manager": {
                      "dynamic": false,
                      "enabled": true,
                      "fields": [
                        {
                          "include_in_all": true,
                          "include_term_vectors": true,
                          "index": true,
                          "name": "is_manager",
                          "type": "boolean"
                        }
                      ]
                    },
                    "join_date": {
                      "dynamic": false,
                      "enabled": true,
                      "fields": [
                        {
                          "include_in_all": true,
                          "include_term_vectors": true,
                          "index": true,
                          "name": "join_date",
                          "type": "datetime"
                        }
                      ]
                    },
                    "manages": {
                      "dynamic": false,
                      "enabled": true,
                      "properties": {
                        "reports": {
                          "dynamic": false,
                          "enabled": true,
                          "fields": [
                            {
                              "analyzer": "standard",
                              "include_in_all": true,
                              "include_term_vectors": true,
                              "index": true,
                              "name": "reports",
                              "type": "text"
                            }
                          ]
                        }
                      }
                    },
                    "name": {
                      "dynamic": false,
                      "enabled": true,
                      "fields": [
                        {
                          "index": true,
                          "name": "name",
                          "type": "text"
                        }
                      ]
                    }
                  }
                }
              }
            },
            "store": {
              "indexType": "scorch",
              "mossStoreOptions": {},
              "segmentVersion": 15
            }
          },
          "sourceParams": {}
        }
        

      • Below query with "Select * " returns 0 results where in "select meta().id" resturns results with above doc

        select * from default where type='emp' and search(default, {"field": "name", "match": "Gabi Phillips"},{"index": "custom_index"})
        

      Attachments

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

        Activity

          People

            girish.benakappa Girish Benakappa
            girish.benakappa Girish Benakappa
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty