Icon View Incident Report

Serious Serious
Reported By: Sanford Aranoff
Reported On: 11/24/2003
For: Version 4.00 Build 1
# 1491 Executing 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

Comments Comments
The problem was with descending indexes not working properly for >= or <= optimized conditions.

Resolution Resolution
Fixed Problem on 11/26/2003 in version 4.01 build 1