SQLite

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