SQLite
Ticket Change Details
Not logged in
Overview

Artifact ID: 542dd814e31ff2820d99da318ff7cdb5404aa1be
Ticket: 7a31705a7e6c95d514e6f20a6900f436bbc9fed8
Name resolution fails when table name is a prefix of another table
Date: 2013-02-26 12:31:15
User: drh
Changes

  1. Change foundin to "3.7.16-alpha"
  2. Change icomment to:
    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.
    
  3. Change login to "drh"
  4. Change mimetype to "text/x-fossil-wiki"
  5. Change severity to "Critical"
  6. Change status to "Open"
  7. Change title to:
    Name resolution fails when table name is a prefix of another table
    
  8. Change type to "Code_Defect"