Trying to simplify the context for this problem, but let me know if you require additional information.
I have a table namedwith several columns, including a field named .
Each field has a BTREE index created via
I've found that queries of the typedo not return the correct number of results.
If I do a, I can see a full and accurate list of all combinations of X and Y = 'value2', since this query does not execute an (running an explain on this shows that its a query using the index on Y).
But runningclearly shows that some rows are dropped from the results when compared to what you see with . Running an explain shows that an is run on the indices on both X and Y.
Rebuilding the indices does not fix the problem, and results in the same rows consistently being dropped from the query results.
I can provide firmer context with actual query outputs if this is too abstract. Thanks for your help.