|
2019-09-03
| ||
| 13:35 | • Fixed ticket [29f635e0af]: IS NULL unexpectedly evaluates to TRUE plus 6 other changes (artifact: be0508679b user: drh) | |
|
2019-09-02
| ||
| 22:14 | • Fixed ticket [29f635e0af]. (artifact: 781749e770 user: drh) | |
| 22:13 | Fix a bug introduced earlier today by check-in [88833a9c2849c959]. Ticket [29f635e0af71234b] (check-in: 6e7b4527d3 user: drh tags: trunk) | |
| 19:22 | • New ticket [29f635e0af] IS NULL unexpectedly evaluates to TRUE. (artifact: 34ebd7c76e user: mrigger) | |
| Ticket Hash: | 29f635e0af71234be40dfc8d3d31bb7ff5b07a1a | ||
| Title: | IS NULL unexpectedly evaluates to TRUE | ||
| Status: | Fixed | Type: | Code_Defect |
| Severity: | Important | Priority: | Immediate |
| Subsystem: | Unknown | Resolution: | Fixed |
| Last Modified: |
2019-09-03 13:35:00 5.86 years ago |
Created: |
2019-09-02 19:22:41 5.86 years ago |
| Version Found In: | 3.29.0 | ||
| User Comments: | ||||
|
mrigger added on 2019-09-02 19:22:41:
Consider the test case below: CREATE TABLE t0(c0 TEXT, c1 REAL, c2, PRIMARY KEY(c2, c0, c1)); CREATE INDEX i0 ON t0(c1 IN (c0)); INSERT INTO t0(c0, c2) VALUES (0, NULL) ON CONFLICT(c2, c1, c0) DO NOTHING; UPDATE t0 SET c2 = x''; SELECT * FROM t0 WHERE t0.c2 IS NULL; -- unexpected: row is fetched The row is fetched, even though the WHERE condition should evaluate to FALSE: SELECT t0.c2 IS NULL FROM t0; -- expected: FALSE drh added on 2019-09-02 22:14:19: The problem was introduced by a check-in earlier today that was itself a fix for ticket [2841e99d104c6436]. | ||||