/ 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. Change foundin to "3.16.1"
  2. Change icomment to:

    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.

  3. Change login to "drh"
  4. Change mimetype to "text/x-fossil-wiki"
  5. Change severity to "Severe"
  6. Change status to "Open"
  7. Change title to "Assertion fault on a query against a view"
  8. Change type to "Code_Defect"