SQLite

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