SQLite

View Ticket
Login
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:

Consider the following test case:

CREATE VIRTUAL TABLE stat USING dbstat;
SELECT * FROM stat WHERE stat.name = NULL; -- unexpected: row is fetched

Unexpectedly, a row is fetched, even though the predicate should evaluate to FALSE:

SELECT stat.name = NULL FROM stat; -- NULL

This issue seems to be related to [727074e2ae].