| Ticket Hash: | 74a4c3860c440178e438469ab51a156b58f25f1b | |||
| Title: | DBSTAT query computes incorrect result for name column | |||
| Status: | Closed | Type: | Code_Defect | |
| Severity: | Minor | Priority: | Low | |
| Subsystem: | Unknown | Resolution: | Fixed | |
| Last Modified: | 2020-01-04 18:53:36 | |||
| Version Found In: | 3.30.0 | |||
| User Comments: | ||||
mrigger added on 2020-01-04 16:09:08:
(text/x-fossil-wiki)
Consider the following test case: <pre> CREATE VIRTUAL TABLE stat USING dbstat; SELECT * FROM stat WHERE stat.name = NULL; -- unexpected: row is fetched </pre> Unexpectedly, a row is fetched, even though the predicate should evaluate to FALSE: <pre> SELECT stat.name = NULL FROM stat; -- NULL </pre> This issue seems to be related to [727074e2ae]. | ||||