Icon View Incident Report

Serious Serious
Reported By: Fernando Dias
Reported On: 8/29/2004
For: Version 4.10 Build 1
# 1822 >= Empty String Conditions On Indexed String Fields Not Working Properly

The follwing statement is returning wrong results. I could only detect the problem when there is an index on the column ISRC.

DROP TABLE IF EXISTS TBL1;
CREATE TABLE IF NOT EXISTS "TBL1"
(
   "isrc" VARCHAR(12),
PRIMARY KEY ("RecordID") 
LOCALE CODE 2070
);

CREATE INDEX IF NOT EXISTS "isrc" ON "tbl1" ("isrc");

INSERT INTO "tbl1" VALUES ('');
INSERT INTO "tbl1" VALUES ('');
INSERT INTO "tbl1" VALUES ('1');
INSERT INTO "tbl1" VALUES ('2');

SELECT ISRC FROM TBL1 WHERE ISRC>='' 



Comments Comments
We've also updated the Data Types and NULL Support section of the manual to include information on what results should be expected with the available operators when used with NULL values.


Resolution Resolution
Fixed Problem on 9/20/2004 in version 4.11 build 1
Image