Reported By: Ole Willy Tuv Reported On: 7/5/2003 For: Version 3.24 Build 1
# 1387Comparing a UPPER() Expression Against an Non-UPPER() Expression Can Cause Incorrect SQL Results The following SELECT statement is returning 1 row.
drop table if exists memory TestTable;
create table memory TestTable(
ID integer,
StringField char(20),
primary key(ID)
language "English (USA)"
);
create nocase index ix_StringField on memory TestTable(StringField);
insert into memory TestTable values (1, 'Tim');
select *
from memory TestTable
where upper(StringField) = 'tim'
ResolutionFixed Problem on 7/12/2003 in version 3.25 build 1