Reported By: Sanford Aranoff Reported On: 11/24/2003 For: Version 4.00 Build 1
# 1491Executing SQL Statements or Filter Expressions that Can Use Descending Indexes Cause Improper Result Executing the following SQL returns an empty set. However, if we set it = 2, it is fine.
select * from BrokerMessages
where BrokerMessages_ID >= 2
CommentsThe problem was with descending indexes not working properly for >= or <= optimized conditions.
ResolutionFixed Problem on 11/26/2003 in version 4.01 build 1