Details
-
Bug
-
Resolution: Fixed
-
Critical
-
6.5.1, Cheshire-Cat
-
Untriaged
-
Unknown
Description
Build: 6.5.1-6255
Load dataset : earthquakes.json
Create geo index:
{
|
"type": "fulltext-index",
|
"name": "geo-index",
|
"uuid": "59ea08fb0c6f976c",
|
"sourceType": "couchbase",
|
"sourceName": "default",
|
"sourceUUID": "fe92886e164fb487bd0588e0cbee9307",
|
"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": {
|
"earthquake": {
|
"dynamic": true,
|
"enabled": true,
|
"properties": {
|
"geo": {
|
"dynamic": false,
|
"enabled": true,
|
"fields": [
|
{
|
"docvalues": true,
|
"include_in_all": true,
|
"index": true,
|
"name": "geo",
|
"type": "geopoint"
|
}
|
]
|
}
|
}
|
}
|
}
|
},
|
"store": {
|
"indexType": "scorch"
|
}
|
},
|
"sourceParams": {}
|
}
|
Below N1FTY query with "select meta().id" returns 3 results but with "select *" returns 0 results
select meta().id from default where type='earthquake' and search(default, {"field": "geo", "polygon_points": [[-114.3743815113394, -46.756982267321966], [-171.67868606878855, -34.891248202060254], [0.558522625476428, 5.685980523172349], [-172.20567966652095, 16.806670889816562], [-165.0713403863565, 21.90009335800352], [6.011138275654218, 34.87519871500005], [-158.36147054304362, 41.645180713848376], [-118.62199373073707, 60.752915311361996], [-111.24391216054889, 17.93949563772368]]}) Limit 3
|
|
[
|
{
|
"id": "earthquake877"
|
},
|
{
|
"id": "earthquake553"
|
},
|
{
|
"id": "earthquake280"
|
}
|
]
|
|
|
select * from default where type='earthquake' and search(default, {"field": "geo", "polygon_points": [[-114.3743815113394, -46.756982267321966], [-171.67868606878855, -34.891248202060254], [0.558522625476428, 5.685980523172349], [-172.20567966652095, 16.806670889816562], [-165.0713403863565, 21.90009335800352], [6.011138275654218, 34.87519871500005], [-158.36147054304362, 41.645180713848376], [-118.62199373073707, 60.752915311361996], [-111.24391216054889, 17.93949563772368]]})
|
|
{
|
"results": []
|
}
|
Attachments
Issue Links
- relates to
-
MB-38284 [N1QL + FTS]: Geo polygon query errors when FTS index type mapping is not dynamic
- Closed