SQLite

Artifact [55771e45]
Login

Artifact 55771e45548b9eca89d2c745c7ec9122e5b4f384:

Ticket change [55771e45] - New ticket [c997b11c] ORDER BY clause ignored in 3-way join query. by dan 2013-01-09 09:39:22.
D 2013-01-09T09:39:22.754
J comment <verbatim>\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</verbatim>\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