I see one more query not returning any results and also not using the index.
create index created_index on bucket(created)
explain select * from bucket where STR_TO_MILLIS(doc.created) between
STR_TO_MILLIS('2014-06-01') and STR_TO_MILLIS('2014-06-02')
"input": {
"as": "loop_gateway",
"bucket": "loop_gateway",
"ids": null,
"input": {
"as": "",
"bucket": "loop_gateway",
"cover": false,
"index": "#alldocs",
"pool": "default",
"ranges": null,
"type": "scan"
},
"pool": "default",
"projection": null,
"type": "fetch"
}
--
You received this message because you are subscribed to the Google Groups
"Couchbase" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
