SQLite

The following SQL gives an assertion fault while running the SELECT in the CREATE TABLE statement:

CREATE TABLE t1(a TEXT);
INSERT INTO t1(a) VALUES(1),(2);
CREATE TABLE t2(x TEXT, y TEXT);
INSERT INTO t2(x,y) VALUES(3,4);
CREATE TEMP TABLE t3 AS
  SELECT a AS p, coalesce(y,a) AS q FROM t1 LEFT JOIN t2 ON a=x;

This problem was reported on the sqlite-users@sqlite.org mailing list by Nissl Reinhard. Bisecting shows that the problem was introduced by check-in [36b613ccf0ddb764a].

This appears to be the same underlying problem as ticket [43107840f1c02], just in a different spot in the code.