Details
-
Bug
-
Resolution: Duplicate
-
Major
-
7.1.0
-
Untriaged
-
1
-
Yes
Description
Build: 7.1.0 build 1062
JOB: centos-fts_custom-map-n1ql-rqg-scorch_6.5_P1
FTS index:
{
|
"type": "fulltext-index",
|
"name": "custom_index",
|
"uuid": "3dd8055c71152469",
|
"sourceType": "gocbcore",
|
"sourceName": "default",
|
"sourceUUID": "d003c2fe8a3337f07ad800c783ec639a",
|
"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": {
|
"team_size": {
|
"dynamic": false,
|
"enabled": true,
|
"fields": [
|
{
|
"analyzer": "standard",
|
"include_in_all": true,
|
"include_term_vectors": true,
|
"index": true,
|
"name": "team_size",
|
"type": "number"
|
}
|
]
|
}
|
}
|
},
|
"mutated": {
|
"dynamic": false,
|
"enabled": true,
|
"fields": [
|
{
|
"include_in_all": true,
|
"index": true,
|
"name": "mutated",
|
"type": "number"
|
}
|
]
|
},
|
"name": {
|
"dynamic": false,
|
"enabled": true,
|
"fields": [
|
{
|
"analyzer": "keyword",
|
"include_in_all": true,
|
"index": true,
|
"name": "name",
|
"type": "text"
|
}
|
]
|
}
|
}
|
}
|
}
|
},
|
"store": {
|
"indexType": "scorch",
|
"mossStoreOptions": {},
|
"segmentVersion": 15
|
}
|
},
|
"sourceParams": {}
|
}
|
Below FTS and N1QL search query returns 1000 results:
{
|
"explain": true,
|
"fields": [
|
"*"
|
],
|
"highlight": {},
|
"query": {
|
"query": "-name:\"Quella\""
|
}
|
}
|
|
|
select meta().id from default where type='emp' and search(default, {"query": "-name:\"Quella\""})
|
below N1QL search query returns 0 results:
select name from default where type='emp' and search(default, {"query": "-name:\"Quella\""})
|