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
- icomment:
Here is a variant of the second test case that does not require the manual disabling of the query flattener: <blockquote><verbatim> 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 ) ); </verbatim></blockquote>
- login: "drh"
- mimetype: "text/x-fossil-wiki"