| Ticket Hash: | 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 12.35 years ago |
Created: |
2013-02-26 12:31:15 12.36 years ago |
| Version Found In: | 3.7.16-alpha | ||
| User Comments: | ||||
|
drh added on 2013-02-26 12:31:15:
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. | ||||