On 2/19/19, Ignacio Losiggio <iglosig...@gmail.com> wrote: > > CREATE TABLE IF NOT EXISTS t (id integer NOT NULL PRIMARY KEY > AUTOINCREMENT); > INSERT INTO t VALUES(1); > SELECT a.id FROM t AS a INNER JOIN t as b ON a.id = b.id WHERE a.id IN > (1, 2, 3);
I have checked in a fix on trunk (https://www.sqlite.org/src/info/b5f90bfe6295ab3a) but the ticket (https://www.sqlite.org/src/info/df46dfb631f75694) has been kept open pending further testing and analysis. If everything still looks good in the morning, I'll close the ticket then. Thank you for an excellent bug report, Ignacio. It is always great when we can get a concise and easily reproducible testcase like this. The fact that you went to the trouble to bisect is above and beyond the call of duty. Thanks. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users