D 2013-03-27T11:39:51.811
J icomment The\sORDER\sBY\sclause\son\sthe\sfinal\sSELECT\sof\sthe\sfollowing\sscript\sdoes\snot\swork:\r\n\r\n<blockquote><verbatim>\r\nCREATE\sTABLE\st1(a,\sb,\sPRIMARY\sKEY(a,b));\r\nINSERT\sINTO\st1\sVALUES(1,1),(1,2);\r\nCREATE\sTABLE\st2(x,\sy,\sPRIMARY\sKEY(x,y));\r\nINSERT\sINTO\st2\sVALUES(3,3),(4,4);\r\nSELECT\sa,\sx\sFROM\st1,\st2\sORDER\sBY\s1,\s2;\r\n</verbatim></blockquote>\r\n\r\nThis\sscript\sis\sa\sreduction\sof\sthe\ssame\sbug\sthat\scauses\sthe\sproblem\r\nin\sthe\sinitial\sbug\sreport\sabove.\r\n\r\nThis\sproblem\swas\sintroduced\sto\strunk\sby\scheck-in\s[956e4d7f8958e706]\son\r\n2012-10-03\sand\sfirst\sappeared\sin\srelease\s3.7.15.
J login drh
J mimetype text/x-fossil-wiki
J priority Immediate
J resolution Open
J subsystem Unknown
J title Incorrect\soutput\sorder\son\sa\sjoin\swith\san\sORDER\sBY
K a179fe746592d4aecc5c1ec2f6583a4e765e6ccf
U drh
Z 0ba19f5e53f7b7343e2f1e9c60304aca