(text/x-fossil-wiki)
The following SQL results in a segfault:
<blockquote><verbatim>
CREATE TABLE t1(x);
SELECT * FROM t1 WHERE 1 IN (SELECT value FROM json_each(x));
</verbatim></blockquote>
Bisecting shows that this problem was introduced by check-in [712267c9c0] on 2017-06-23 and was first released with SQLite 3.20.0. Preliminary analysis
suggests that the problem has nothing to do with the JSON1 extension, but is
instead a code-generator fault of some kinds that causes an OP_Column opcode
to be run on a cursor for the "t1" table before that cursor has been opened.
This problem was reported on the public mailing list by Martin Thierer.
|