Correct c-treeACE SQL Query Returns With BETWEEN Conditions

A query containing 3 conditions on the same field using > and < operator was found to return the wrong result. When possible, the c-treeACE SQL engine substitutes two predicates on the same column with a between predicate. After creating the between predicate, the predicates that have been replace by BETWEEN are removed as they are now redundant, however, other predicates on the same column were also incorrectly removed. c-treeACE SQL query logic was adjusted such that if the index operator is BETWEEN, then only those predicates that were used to form the BETWEEN predicate are considered to be redundant.