The following script gives an error on the SELECT statement:

CREATE TABLE t1 (a INTEGER PRIMARY KEY);
CREATE TABLE t2 (a INTEGER PRIMARY KEY, b INTEGER);
CREATE TABLE t2x (b INTEGER PRIMARY KEY);
SELECT t1.a FROM ((t1 JOIN t2 ON t1.a=t2.a) AS x JOIN t2x ON x.b=t2x.b) as y;

The error only occurs if the name of the third table includes the name of the second table as a prefix. This problem was introduced by check-in 99127a669c on 2013-01-03 and has never appeared in an official release.

Name resolution fails when table name is a prefix of another table