D 2013-01-09T09:39:22.754 J comment \r\n$\s./sqlite3\s\r\nSQLite\sversion\s3.7.16\s2013-01-08\s12:48:10\r\nEnter\s".help"\sfor\sinstructions\r\nEnter\sSQL\sstatements\sterminated\swith\sa\s";"\r\nsqlite>\sCREATE\sTABLE\st1(a\sINTEGER\sPRIMARY\sKEY);\r\nsqlite>\sCREATE\sTABLE\st2(b\sINTEGER\sPRIMARY\sKEY,\sc\sINTEGER);\r\nsqlite>\sCREATE\sTABLE\st3(d\sINTEGER);\r\nsqlite>\s\r\nsqlite>\sINSERT\sINTO\st1\sVALUES(1);\r\nsqlite>\sINSERT\sINTO\st1\sVALUES(2);\r\nsqlite>\sINSERT\sINTO\st1\sVALUES(3);\r\nsqlite>\s\r\nsqlite>\sINSERT\sINTO\st2\sVALUES(3,\s1);\r\nsqlite>\sINSERT\sINTO\st2\sVALUES(4,\s2);\r\nsqlite>\sINSERT\sINTO\st2\sVALUES(5,\s3);\r\nsqlite>\s\r\nsqlite>\sINSERT\sINTO\st3\sVALUES(4);\r\nsqlite>\sINSERT\sINTO\st3\sVALUES(3);\r\nsqlite>\sINSERT\sINTO\st3\sVALUES(5);\r\nsqlite>\r\nsqlite>\sSELECT\st1.a\sFROM\st1,\st2,\st3\sWHERE\st1.a=t2.c\sAND\st2.b=t3.d\sORDER\sBY\st1.a;\r\n2\r\n1\r\n3\r\n\r\n\r\nProblem\sintroduced\sby\s[956e4d7f89].\r\n\r\nFirst\sreported\son\sthe\smailing\slist:\shttp://www.mail-archive.com/sqlite-users@sqlite.org/msg74717.html J detected Application_Fault J severity Critical J status Open J subsystem Code_Generator J title ORDER\sBY\sclause\signored\sin\s3-way\sjoin\squery J type Code_Defect K c997b11c4d53a2ee9983111d0c676dd7d4f01ec7 U dan Z c34f1a0370f276ee3ffcea7c27650f4a