| Ticket Hash: | ac184eb571d5e6e0f1d54f8fe4b3158e60138018 | |||
| Title: | Row with comparison on TEXT UNIQUE column is not fetched | |||
| Status: | Fixed | Type: | Code_Defect | |
| Severity: | Important | Priority: | Immediate | |
| Subsystem: | Unknown | Resolution: | Fixed | |
| Last Modified: | 2019-08-22 11:14:02 | |||
| Version Found In: | 3.29.0 | |||
| User Comments: | ||||
mrigger added on 2019-08-22 09:44:23:
(text/x-fossil-wiki)
Consider the following test case: <pre> CREATE TABLE t0(c0 TEXT UNIQUE, c1); INSERT INTO t0(c0) VALUES (-1); SELECT * FROM t0 WHERE - x'ce' >= t0.c0; -- unexpected: row is not fetched </pre> I would expect the row to be fetched, since the following returns TRUE: <pre> SELECT - x'ce' >= t0.c0 FROM t0; </pre> drh added on 2019-08-22 11:14:02: (text/x-fossil-wiki) False positive in the sqlite3ExprNeedsNoAffinityChange() optimization. The error first appeared in version 3.8.1 (2013-10-17). | ||||