Overview
| Artifact ID: | 5c88913817fb9e4ca746822edfe1ceb8b1132c9a |
|---|---|
| Ticket: | 190c2507eeffcd1154196faa18551cd10a3d4703
Assertion fault on a query against a view |
| User & Date: | drh 2017-01-05 16:34:50 |
Changes
- foundin changed to: "3.16.1"
- icomment:
The following SQL causes an assertion fault: <blockquote><verbatim> 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); </verbatim></blockquote> Bisecting isolates the problem to check-in [b9727e6bbfc3c] (2015-05-22). The problem first appeared in version 3.8.11 on 2015-07-27.
- login: "drh"
- mimetype: "text/x-fossil-wiki"
- severity changed to: "Severe"
- status changed to: "Open"
- title changed to: "Assertion fault on a query against a view"
- type changed to: "Code_Defect"