/ Ticket Change Details
Login
Overview

Artifact ID: 5c88913817fb9e4ca746822edfe1ceb8b1132c9a
Ticket: 190c2507eeffcd1154196faa18551cd10a3d4703
Assertion fault on a query against a view
User & Date: drh 2017-01-05 16:34:50
Changes

  1. foundin changed to: "3.16.1"
  2. 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.
    
  3. login: "drh"
  4. mimetype: "text/x-fossil-wiki"
  5. severity changed to: "Severe"
  6. status changed to: "Open"
  7. title changed to: "Assertion fault on a query against a view"
  8. type changed to: "Code_Defect"