Open
Description
The REVERSE_OPERATORS in DocumentDbRules are defined in a way that returns unexpected results.
Ex. For a column val [1, 2, 3] select val from int_table where 2 >= val
should return [1, 2]
Currently, the driver reverses the operator >= to be '$lt' which is the same as select val from int_table where val < 2
which returns [1]
The correct reverse operator is '$lte' which should return [1, 2]
.
This should be a very quick fix, I made the change locally myself and it looks like this: Reverse Operator Change