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
\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
\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