Details
-
Bug
-
Resolution: Not a Bug
-
Major
-
Cheshire-Cat
-
Untriaged
-
Centos 64-bit
-
1
-
Unknown
Description
Build: 7.0.0-4332
Create kv: `default`.scope1.collection1
Load 1000 docs into collection1, all docs look like:
{
|
"mutated": 0, |
"join_date": "1953-06-19T04:47:33", |
"languages_known": [ |
"German", |
"Chinese", |
"French" |
],
|
"manages": { |
"reports": [ |
"Cynara Richardson IX", |
"Ambika Miller XII", |
"Perdita Lewis", |
"Killian Wright", |
"Beryl Wood", |
"Severin Carter", |
"Callia Mitchell", |
"Chatha Palmer" |
],
|
"team_size": 8 |
},
|
"name": "Casondrah Josué", |
"dept": "Pre-sales", |
"salary": 102870, |
"type": "emp", |
"is_manager": true, |
"email": "Casondrah@mcdiabetes.com", |
"emp_id": "10000001" |
}
|
meta().id looks like
emp1
|
....
|
emp1000
|
Trying to use the following fts index
{
|
"name": "default_index_1", |
"type": "fulltext-index", |
"params": { |
"doc_config": { |
"docid_prefix_delim": "emp", |
"docid_regexp": "", |
"mode": "scope.collection.docid_prefix", |
"type_field": "type" |
},
|
"mapping": { |
"default_analyzer": "keyword", |
"default_datetime_parser": "dateTimeOptional", |
"default_field": "_all", |
"default_mapping": { |
"dynamic": false, |
"enabled": false |
},
|
"default_type": "_default", |
"docvalues_dynamic": true, |
"index_dynamic": true, |
"store_dynamic": false, |
"type_field": "_type", |
"types": { |
"scope1.collection1": { |
"default_analyzer": "keyword", |
"dynamic": true, |
"enabled": true |
}
|
}
|
},
|
"store": { |
"indexType": "scorch", |
"mossStoreOptions": {}, |
"segmentVersion": 15 |
}
|
},
|
"sourceType": "gocbcore", |
"sourceName": "default", |
"sourceUUID": "7cafbfe31ebd85b39a4f720b8a1d583b", |
"sourceParams": {}, |
"planParams": { |
"maxPartitionsPerPIndex": 171, |
"numReplicas": 0, |
"indexPartitions": 6 |
},
|
"uuid": "1d574773a8779015" |
}
|
to execute the following query:
select count(*) from `default`.scope1.collection1 USE INDEX(USING FTS) where meta().id LIKE 'emp%' |
Server response is:
[
|
{
|
"code": 4000, |
"msg": "No index available on keyspace `default`:`default`.`scope1`.`collection1` that matches your query. Use CREATE PRIMARY INDEX ON `default`:`default`.`scope1`.`collection1` to create a primary index, or check that your expected index is online.", |
"query": "select count(*) from `default`.scope1.collection1 USE INDEX(USING FTS) where meta().id LIKE 'emp%'" |
}
|
]
|