Overview
Artifact ID: | 542dd814e31ff2820d99da318ff7cdb5404aa1be |
---|---|
Ticket: | 7a31705a7e6c95d514e6f20a6900f436bbc9fed8
Name resolution fails when table name is a prefix of another table |
User & Date: | drh 2013-02-26 12:31:15 |
Changes
- foundin changed to: "3.7.16-alpha"
- icomment:
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.
- login: "drh"
- mimetype: "text/x-fossil-wiki"
- severity changed to: "Critical"
- status changed to: "Open"
- title changed to:
Name resolution fails when table name is a prefix of another table
- type changed to: "Code_Defect"