How does N1QL handle the stale parameter?
1. Does N1QL use "stale=ok" for queries that use created indexes?
2. Is there an issue with stale documents for buckets that have no indexes created on them? In other words, if a primary index is not created and "SELECT * FROM default" is called, is it possible for the result from the query to be outdated?
- N1QL currently uses the default, which is equivalent to stale=ok
- If documents are being mutated, it is possible for the results to be "outdated". The version read and returned by N1QL will satisfy the query conditions.
We are adding secondary indexes that will provide certain snapshot semantics that we define.