Icon View Incident Report

Serious Serious
Reported By: Ole Willy Tuv
Reported On: 7/5/2003
For: Version 3.24 Build 1
# 1387 Comparing 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'



Resolution Resolution
Fixed Problem on 7/12/2003 in version 3.25 build 1
Image