Details
-
Bug
-
Resolution: Not a Bug
-
Major
-
None
-
6.5.0
-
Untriaged
-
Centos 64-bit
-
Unknown
Description
Build 6.5.0 build 2715
Run string match phrase query:
select count(*) from `travel-sample` where SEARCH(`travel-sample`, "'United Kingdom'") |
against standard `travel-sample` bucket produces 6801 results.
Same amount of results is produced for string query that matched 2 words:
select count(*) from `travel-sample` where SEARCH(`travel-sample`, "United Kingdom") |
gives 6801 results.
Execution plan is:
{
|
"#operator": "Sequence", |
"~children": [ |
{
|
"#operator": "IndexFtsSearch", |
"covers": [ |
"cover (search(`travel-sample`, \"'United Kingdom'\"))", |
"cover ((meta(`travel-sample`).`id`))", |
"cover (search_score((`travel-sample`.`out`)))", |
"cover (search_meta((`travel-sample`.`out`)))" |
],
|
"index": "idx_travel_sample_fts", |
"index_id": "10770c11a52fde37", |
"keyspace": "travel-sample", |
"namespace": "default", |
"search_info": { |
"field": "\"\"", |
"outname": "out", |
"query": "\"'United Kingdom'\"" |
},
|
"using": "fts" |
},
|
{
|
"#operator": "Parallel", |
"~child": { |
"#operator": "Sequence", |
"~children": [ |
{
|
"#operator": "Filter", |
"condition": "cover (search(`travel-sample`, \"'United Kingdom'\"))" |
},
|
{
|
"#operator": "InitialGroup", |
"aggregates": [ |
"count(*)" |
],
|
"group_keys": [] |
}
|
]
|
}
|
},
|
{
|
"#operator": "IntermediateGroup", |
"aggregates": [ |
"count(*)" |
],
|
"group_keys": [] |
},
|
{
|
"#operator": "FinalGroup", |
"aggregates": [ |
"count(*)" |
],
|
"group_keys": [] |
},
|
{
|
"#operator": "Parallel", |
"~child": { |
"#operator": "Sequence", |
"~children": [ |
{
|
"#operator": "InitialProject", |
"result_terms": [ |
{
|
"expr": "count(*)" |
}
|
]
|
},
|
{
|
"#operator": "FinalProject" |
}
|
]
|
}
|
}
|
]
|
}
|
FTS index definition is:
{
|
"name": "idx_travel_sample_fts", |
"type": "fulltext-index", |
"params": { |
"doc_config": { |
"docid_prefix_delim": "", |
"docid_regexp": "", |
"mode": "type_field", |
"type_field": "type" |
},
|
"mapping": { |
"default_analyzer": "standard", |
"default_datetime_parser": "dateTimeOptional", |
"default_field": "_all", |
"default_mapping": { |
"dynamic": true, |
"enabled": true |
},
|
"default_type": "_default", |
"docvalues_dynamic": true, |
"index_dynamic": true, |
"store_dynamic": false, |
"type_field": "_type" |
},
|
"store": { |
"indexType": "scorch", |
"kvStoreName": "mossStore", |
"mossStoreOptions": {} |
}
|
},
|
"sourceType": "couchbase", |
"sourceName": "travel-sample", |
"sourceUUID": "2562b8e629d87aa97fc0f5271451d8f5", |
"sourceParams": null, |
"planParams": { |
"maxPartitionsPerPIndex": 171, |
"numReplicas": 0 |
},
|
"uuid": "10770c11a52fde37" |
}
|