SQLite

Artifact [542dd814]
Login

Artifact 542dd814e31ff2820d99da318ff7cdb5404aa1be:

Ticket change [542dd814] - New ticket [7a31705a] Name resolution fails when table name is a prefix of another table. by drh 2013-02-26 12:31:15.
     1
     2
     3
     4
     5
     6
     7
     8
     9
    10
    11
    12
D 2013-02-26T12:31:15.818
J foundin 3.7.16-alpha
J icomment The\sfollowing\sscript\sgives\san\serror\son\sthe\sSELECT\sstatement:\r\n\r\n<blockquote><verbatim>\r\nCREATE\sTABLE\st1\s(a\sINTEGER\sPRIMARY\sKEY);\r\nCREATE\sTABLE\st2\s(a\sINTEGER\sPRIMARY\sKEY,\sb\sINTEGER);\r\nCREATE\sTABLE\st2x\s(b\sINTEGER\sPRIMARY\sKEY);\r\nSELECT\st1.a\sFROM\s((t1\sJOIN\st2\sON\st1.a=t2.a)\sAS\sx\sJOIN\st2x\sON\sx.b=t2x.b)\sas\sy;\r\n</verbatim></blockquote>\r\n\r\nThe\serror\sonly\soccurs\sif\sthe\sname\sof\sthe\sthird\stable\sincludes\sthe\sname\r\nof\sthe\ssecond\stable\sas\sa\sprefix.\s\sThis\sproblem\swas\sintroduced\sby\r\ncheck-in\s[99127a669c]\son\s2013-01-03\sand\shas\snever\sappeared\sin\san\sofficial\r\nrelease.
J login drh
J mimetype text/x-fossil-wiki
J severity Critical
J status Open
J title Name\sresolution\sfails\swhen\stable\sname\sis\sa\sprefix\sof\sanother\stable
J type Code_Defect
K 7a31705a7e6c95d514e6f20a6900f436bbc9fed8
U drh
Z f43c12b8eea39f70931776554aca92d6