/ Ticket Change Details
Login
Overview

Artifact ID: 838f5f420d220e87d9ec548a4ff34ef387e7e9b1fb8535b95b032826703855c1
Ticket: 787fa716be3a7f650cac1b1413f12f95f5e7639d
Assertion fault when multi-use subquery implemented by co-routine
User & Date: drh 2018-11-08 20:49:18
Changes

  1. Change icomment to:

    Here is another test case that does not require manually disabling the query flattener:

    CREATE TABLE t5(a, b, c, d);
    CREATE INDEX t5a ON t5(a);
    CREATE INDEX t5b ON t5(b);
    CREATE TABLE t6(e);
    INSERT INTO t6 VALUES(1);
    INSERT INTO t5 VALUES(1,1,1,1), (2,2,2,2);
    SELECT * FROM t5 WHERE (a=1 OR b=2) AND c IN (
      SELECT e FROM (SELECT DISTINCT e FROM t6) WHERE e=1
    );
    

    The failure in this test case also goes back to check-in [020b8b106fc8f840f6b506e1c9c3bc75676daec3] on 2015-05-29.

  2. Change login to "drh"
  3. Change mimetype to "text/x-fossil-wiki"