SQLite
View Ticket
Not logged in
Ticket UUID: 7a31705a7e6c95d514e6f20a6900f436bbc9fed8
Title: Name resolution fails when table name is a prefix of another table
Status: Fixed Type: Code_Defect
Severity: Critical Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2013-03-01 17:43:37
Version Found In: 3.7.16-alpha
User Comments:
drh added on 2013-02-26 12:31:15: (text/x-fossil-wiki)
The following script gives an error on the SELECT statement:

<blockquote><verbatim>
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;
</verbatim></blockquote>

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.