Icon View Incident Report

Serious Serious
Reported By: Marilyn Fleming
Reported On: 10/27/1999
For: Version 1.18 Build 1
# 496 Using Upper() in a Query WHERE Clause Condition or Join Causes Incorrect Result Set

I put a secondary index (case insensitive) on SpecID and tried again. It runs instantly. It also returns only one record (it should be about 100). I took out 'upper' on the join and got all the records in about 30 sec. Is there some way to make the join case-insensitve?

Comments Comments
When using the Upper() SQL function in joins or WHERE clause conditions with available case-insensitive indexes to optimize the condition, incorrect results would be returned due to the Upper() function not handling non-Machine ASCII upper-casing properly.

Resolution Resolution
Fixed Problem on 10/28/1999 in version 1.19 build 1