| Ticket Hash: | a55ab6d97d01ecbcf058a36ac3ccc7c7d887a1d7 | |||
| Title: | Incorrect result for TEXT comparison on rtree table | |||
| Status: | Fixed | Type: | Code_Defect | |
| Severity: | Important | Priority: | Immediate | |
| Subsystem: | Extensions | Resolution: | Fixed | |
| Last Modified: | 2019-12-05 00:45:14 | |||
| Version Found In: | 3.29.0 | |||
| User Comments: | ||||
|
mrigger added on 2019-12-04 22:53:14:
Consider the following test case: CREATE VIRTUAL TABLE rt0 USING rtree(c0, c1, c2); INSERT INTO rt0(c2) VALUES(NULL); SELECT * FROM rt0 WHERE rt0.c2 >= 'a'; -- unexpected: fetches row Unexpectedly, the inserted row is fetched, even though the predicate should evaluate to FALSE: SELECT rt0.c2 >= 'a' FROM rt0; -- 0 | ||||