# 1171 Executing a Live Query with a Constant Expression in the WHERE Clause Returns Incorrect Results

---

I don't know if this has been discussed before but I think I found a bug in DBISAM version 3.10:

Create a table named "test":


CREATE TABLE test (
id AUTOINC NOT NULL,
temp INT,
PRIMARY KEY (id));


then insert two records:

INSERT INTO test (temp) VALUES (123);
INSERT INTO test (temp) VALUES (NULL);


The following statement gives correctly one result:

SELECT *
FROM test
WHERE (temp IS NULL);


Now look at the following query:

SELECT *
FROM test
WHERE (temp IS NULL) or (False = True);

When a canned result set is requested (RequestLive=FALSE) this query returns the same result as the first query (that's correct). But when you request a live result set (RequestLive=TRUE) then the query returns NO result at all.