| 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:
Consider the following test case: 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 The row is not fetched, even though the predicate should evaluate to TRUE: SELECT '0' = rt0.c2 FROM rt0; -- 1 | ||||