Details
-
Bug
-
Resolution: Won't Fix
-
Major
-
6.6.0, Cheshire-Cat
-
Untriaged
-
1
-
Unknown
Description
Build: 7.0.0-2005
- Load Travel-Sample
- Create a GSI with type: CREATE INDEX `def_type` ON `travel-sample`(`type`)
- Create FTS index with below:
{"type": "fulltext-index","name": "t_smapl","uuid": "3157423be1f0eae5","sourceType": "gocbcore","sourceName": "travel-sample","sourceUUID": "7e9fad049aa02b440b6d98cd93dbeeaa","planParams": {"maxPartitionsPerPIndex": 171,"indexPartitions": 6},"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": {"airline": {"dynamic": false,"enabled": true,"properties": {"country": {"dynamic": false,"enabled": true,"fields": [{"analyzer": "keyword","docvalues": true,"include_in_all": true,"include_term_vectors": true,"index": true,"name": "country","type": "text"}]}}},"airport": {"dynamic": false,"enabled": true,"properties": {"country": {"dynamic": false,"enabled": true,"fields": [{"analyzer": "keyword","docvalues": true,"include_in_all": true,"include_term_vectors": true,"index": true,"name": "country","type": "text"}]}}}}},"store": {"indexType": "scorch"}},"sourceParams": {}}
- Below query wit only "USING FTS" s good and goes FTS index
SELECT meta().idFROM `travel-sample` as t USE INDEX (USING FTS)WHERE type = "airline" and country = "France"Explain plan:{"#operator": "Sequence","~children": [{"#operator": "IndexFtsSearch","as": "t","index": "t_smapl","index_id": "3157423be1f0eae5","keyspace": "travel-sample","namespace": "default","search_info": {"field": "\"\"","options": "{\"index\": \"t_smapl\"}","outname": "out","query": "{\"query\": {\"field\": \"country\", \"term\": \"France\"}, \"score\": \"none\"}"},"using": "fts"},{"#operator": "Fetch","as": "t","keyspace": "travel-sample","namespace": "default"},{"#operator": "Parallel","~child": {"#operator": "Sequence","~children": [{"#operator": "Filter","condition": "(((`t`.`type`) = \"airline\") and ((`t`.`country`) = \"France\"))"},{"#operator": "InitialProject","result_terms": [{"expr": "(meta(`t`).`id`)"}]}]}}]}
- Below query with "USING FTS, USING GSI" makes it use IntersectScan even though all fields are available in FTS index
SELECT meta().idFROM `travel-sample` as t USE INDEX (USING FTS, USING GSI)WHERE type = "airline" and country = "France"Explain Plan:{"#operator": "Sequence","~children": [{"#operator": "IntersectScan","scans": [{"#operator": "IndexScan3","as": "t","index": "def_type","index_id": "8035bfadaccbc3c2","index_projection": {"primary_key": true},"keyspace": "travel-sample","namespace": "default","spans": [{"exact": true,"range": [{"high": "\"airline\"","inclusion": 3,"low": "\"airline\""}]}],"using": "gsi"},{"#operator": "IndexFtsSearch","as": "t","index": "t_smapl","index_id": "3157423be1f0eae5","keyspace": "travel-sample","namespace": "default","search_info": {"field": "\"\"","options": "{\"index\": \"t_smapl\"}","outname": "out","query": "{\"query\": {\"field\": \"country\", \"term\": \"France\"}, \"score\": \"none\"}"},"using": "fts"}]},{"#operator": "Fetch","as": "t","keyspace": "travel-sample","namespace": "default"},{"#operator": "Parallel","~child": {"#operator": "Sequence","~children": [{"#operator": "Filter","condition": "(((`t`.`type`) = \"airline\") and ((`t`.`country`) = \"France\"))"},{"#operator": "InitialProject","result_terms": [{"expr": "(meta(`t`).`id`)"}]}]}}]}
Attachments
Issue Links
- relates to
-
-
- Closed
-