Ticket Hash: | 30e2c183b6b356e4e4b871d582b28f184f5a2c7c | |||
Title: | column = NULL predicate evaluates to TRUE for rtree table | |||
Status: | Fixed | Type: | Code_Defect | |
Severity: | Minor | Priority: | Immediate | |
Subsystem: | Unknown | Resolution: | Fixed | |
Last Modified: | 2019-12-05 13:35:06 | |||
Version Found In: | 3.30.0 | |||
User Comments: | ||||
mrigger added on 2019-12-05 08:12:30:
(text/x-fossil-wiki)
Consider the following test case: <pre> CREATE VIRTUAL TABLE rt0 USING rtree(c0, c1, c2); INSERT INTO rt0(c0) VALUES(0); SELECT * FROM rt0 WHERE rt0.c0 = NULL; -- unexpected: row is fetched </pre> Unexpectedly, the row is fetched, even though the predicate rt0.c0 = NULL should evaluate to FALSE: <pre> SELECT (rt0.c0 = NULL) IS TRUE FROM rt0; -- 0 </pre> |