Ticket Hash: | 727074e2aee3b8163efae7c8b72703e2dbd03cc0 | |||
Title: | DBSTAT query computes incorrect result for aggregate column | |||
Status: | Fixed | Type: | Code_Defect | |
Severity: | Minor | Priority: | Low | |
Subsystem: | Unknown | Resolution: | Fixed | |
Last Modified: | 2020-01-04 15:23:30 | |||
Version Found In: | 3.30.0 | |||
User Comments: | ||||
mrigger added on 2020-01-04 11:22:43:
(text/x-fossil-wiki)
Consider the following test case: <pre> CREATE VIRTUAL TABLE stat USING dbstat; SELECT * FROM stat WHERE stat.aggregate == NULL; -- unexpected: row is fetched </pre> I would not expect the row to be fetched, since the comparison should evaluate to FALSE: <pre> SELECT stat.aggregate == NULL FROM stat; -- NULL </pre> This affects only the DBSTAT extension. |