willholley commented on issue #962: Mango: generate a warning instead of an error when an user-specified index cannot be used URL: https://github.com/apache/couchdb/pull/962#issuecomment-342808251 @tonysun83 Regarding your concerns about the fallback behaviour: 1. This is a concern in general and doesn't seem specific to this PR. Assuming users don't specify `use_index`, we depend on the query planner to select an appropriate index and it should be the case that the only indexes which can change the results are partial indexes. Indexes that are not usable for the query are excluded from the set of candidate indexes, so the fallback is safe so long as the text indexes correctly exclude themselves. 2. I think this points to a general weakness around index management for Query. Ideally it would be safe to add and remove indexes in production databases whilst only impacting performance. Unfortunately, the query planner doesn't take the index state into account, so if an index is added to a production database and it takes some time to build, the query planner would use it and time out. Again, I'm not really sure that's a concern specific to this PR, but one that should be addressed independently.
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services
