When we have a $or query with two clauses on the same field:
0 < a < 5
|
|
or
|
|
5 < a < 10
|
the query optimizer is generating the following index bounds:
0 < a < 10
|
which is incorrect (5 should not be in bounds).