View Incident Report

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

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

Resolution

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

More Support Options