Details
-
Bug
-
Resolution: Fixed
-
Critical
-
Cheshire-Cat
-
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"})