|
2020-02-17
| ||
| 19:25 | A better (smaller and faster) solution to ticket [4374860b29383380]. (check-in: abc473fb user: drh tags: trunk) | |
| 00:12 | • Fixed ticket [4374860b]: Segmentation fault in isAuxiliaryVtabOperator plus 5 other changes (artifact: 971c60ab user: drh) | |
| 00:12 | Take care when checking the table of a TK_COLUMN expression node to see if the table is a virtual table to first ensure that the Expr.y.pTab pointer is not null due to generated column optimizations. Ticket [4374860b29383380]. (check-in: 9d0d4ab9 user: drh tags: trunk) | |
|
2020-02-16
| ||
| 20:37 | • New ticket [4374860b] Segmentation fault in isAuxiliaryVtabOperator. (artifact: 35dadd92 user: yongheng) | |
| Ticket Hash: | 4374860b2938338013e536f70af02584ada7de87 | |||
| Title: | Segmentation fault in isAuxiliaryVtabOperator | |||
| Status: | Fixed | Type: | Code_Defect | |
| Severity: | Important | Priority: | Low | |
| Subsystem: | Unknown | Resolution: | Fixed | |
| Last Modified: | 2020-02-17 00:12:19 | |||
| Version Found In: | 3.31.1, trunk | |||
| User Comments: | ||||
yongheng added on 2020-02-16 20:37:12:
Consider the following POC:
---
CREATE TABLE v0(v3, v1 AS(v1) UNIQUE);
CREATE TABLE v5(v6 UNIQUE, v7 UNIQUE);
CREATE VIEW v8(v9) AS SELECT coalesce(v3, v1) FROM v0 WHERE v1 IN('MED BOX');
SELECT *FROM v8 JOIN v5 WHERE 0 > v7 AND v9 OR v6 = 's%';
---
It triggers an seg fault in trunk and release version of sqlite.
| ||||