/ Ticket Change Details
Login
Overview

Artifact ID: 0d3537a720242f7e5bd4240fd2b4dec681a287ce2849602fcf9f7b9f5d98db3a
Ticket: 787fa716be3a7f650cac1b1413f12f95f5e7639d
Assertion fault when multi-use subquery implemented by co-routine
User & Date: drh 2018-11-08 22:03:39
Changes

  1. Change icomment to:

    Here is a variant of the second test case that does not require the manual disabling of the query flattener:

    CREATE TABLE t1 (a); INSERT INTO t1 (a) VALUES (104);
    CREATE TABLE t2 (b); INSERT INTO t2 (b) VALUES (104);
    CREATE TABLE t3 (c); INSERT INTO t3 (c) VALUES (104);
    CREATE TABLE t4 (d); INSERT INTO t4 (d) VALUES (104);
    SELECT *
    FROM t1 CROSS JOIN t2 ON (t1.a = t2.b) WHERE t2.b IN (
      SELECT t3.c
      FROM t3
      WHERE t3.c IN (
        SELECT d FROM (SELECT DISTINCT d FROM t4) AS x WHERE x.d=104
      )
    );
    
  2. Change login to "drh"
  3. Change mimetype to "text/x-fossil-wiki"