/ View Ticket
Login
Ticket UUID: 190c2507eeffcd1154196faa18551cd10a3d4703
Title: Assertion fault on a query against a view
Status: Fixed Type: Code_Defect
Severity: Severe Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2017-01-05 17:38:31
Version Found In: 3.16.1
User Comments:
drh added on 2017-01-05 16:34:50:

The following SQL causes an assertion fault:

CREATE TABLE t1(a);
CREATE TABLE t2(b);
CREATE TABLE t3(c);
CREATE VIEW vvv AS SELECT b FROM t2 ORDER BY 1;
SELECT 123 FROM t1, (SELECT b FROM vvv UNION ALL SELECT c from t3);

Bisecting isolates the problem to check-in [b9727e6bbfc3c] (2015-05-22). The problem first appeared in version 3.8.11 on 2015-07-27.