This bug was fixed on 2012-08-28 (by the checkin at http://www.sqlite.org/src/info/200a81358c). The fix is available in SQLite version 3.7.14 and 3.7.14.1 as well as on trunk.
On Thu, Oct 25, 2012 at 11:50 AM, Steve Pomeroy <spome...@mit.edu> wrote: > This bug was originally found on a version of sqlite3 (tested in 3.5.9 > and 3.7.11) in Android (2.2.1 and 4.1.2 respectively), but I've been > able to recreate it on sqlite3 3.7.13 from Debian/wheezy. > > Test case: > > CREATE TABLE t1(a,b,c); > INSERT INTO t1 VALUES(1,2,3), (4,5,6); > CREATE TABLE t2(d,e,f); > INSERT INTO t2 VALUES(3,6,9), (4,8,12); > > # This works as expected > SELECT * FROM (SELECT a AS x, b AS y FROM t1 UNION ALL SELECT d AS x, e > AS y FROM t2); > #1|2 > #4|5 > #3|6 > #4|8 > > # this doesn't crash... > SELECT * FROM (SELECT a AS x, b AS y FROM t1 UNION ALL SELECT d AS x, e > AS y, f AS z FROM t2); > #1|2 > #4|5 > #3|6 > #4|8 > > # but this causes a segfault (it's missing column "y" from the second > inner SELECT): > SELECT * FROM (SELECT a AS x, b AS y FROM t1 UNION ALL SELECT d AS x > FROM t2); > > -- > Steve Pomeroy > MIT Mobile Experience Lab > http://mobile.mit.edu/ > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users