| Ticket Hash: | aa573a787b8f1fdf40f749be7ef2a1a3741bed17 | |||
| Title: | Comparison on INT column in rtree table malfunctions | |||
| Status: | Fixed | Type: | Feature_Request | |
| Severity: | Minor | Priority: | Immediate | |
| Subsystem: | Unknown | Resolution: | Fixed | |
| Last Modified: | 2019-12-06 01:38:39 | |||
| Version Found In: | 3.30.0 | |||
| User Comments: | ||||
mrigger added on 2019-12-05 23:06:58:
(text/x-fossil-wiki)
Consider the following test case: <pre> CREATE VIRTUAL TABLE rt0 USING rtree(c0, c1, c2 INT); INSERT INTO rt0(c2) VALUES(0); SELECT * FROM rt0 WHERE '0' = rt0.c2; -- unexpected: row is not fetched </pre> The row is not fetched, even though the predicate should evaluate to TRUE: <pre> SELECT '0' = rt0.c2 FROM rt0; -- 1 </pre> | ||||