| 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:
Consider the following test case: CREATE VIRTUAL TABLE stat USING dbstat; SELECT * FROM stat WHERE stat.aggregate == NULL; -- unexpected: row is fetched I would not expect the row to be fetched, since the comparison should evaluate to FALSE: SELECT stat.aggregate == NULL FROM stat; -- NULL This affects only the DBSTAT extension. | ||||