| Ticket Hash: | c31034044bb72c89319b5f2022518234409b4261 | |||
| Title: | LEFT JOIN in view malfunctions with NOTNULL | |||
| Status: | Closed | Type: | Code_Defect | |
| Severity: | Critical | Priority: | Immediate | |
| Subsystem: | Unknown | Resolution: | Fixed | |
| Last Modified: | 2019-10-10 17:10:18 | |||
| Version Found In: | 3.30.0 | |||
| User Comments: | ||||
mrigger added on 2019-10-10 14:12:24:
(text/x-fossil-wiki)
Consider the following test case: <pre> CREATE TABLE t0(c0); CREATE TABLE t1(c1); INSERT INTO t0(c0) VALUES(0); CREATE VIEW v0(c0) AS SELECT t1.c1 FROM t0 LEFT JOIN t1; SELECT * FROM v0 WHERE v0.c0 NOTNULL NOTNULL; -- expected: row is fetched, actual: no row is fetched </pre> Unexpectedly, the SELECT does not fetch the row contained in the table, although the condition should evaluate to TRUE: <pre> SELECT v0.c0 NOTNULL NOTNULL FROM v0; -- TRUE </pre> | ||||