/ Artifact Content
Login

Artifact a8a0089dfa936c43222e5aea843b88a84e83937d:

Ticket change [a8a0089d] - Open ticket [1c69be2d]: Incorrect GROUP BY when input and output columns have the same name plus 4 other changes by drh 2014-06-10 20:11:36.
D 2014-06-10T20:11:36.244
J icomment It\shas\scome\sto\slight\sthat\ssome\slegacy\sAndroid\sapplications\sare\scoded\r\nwith\squeries\sthat\sare\slogically\sequivalent\sto\sthis:\r\n\r\n<blockquote><verbatim>\r\nCREATE\sTABLE\st1(a,x);\r\nCREATE\sTABLE\st2(a,y);\r\nSELECT\st1.a\sAS\sa,\sx,\sy\sFROM\st1,\st2\sGROUP\sBY\sa;\r\n</verbatim></blockquote>\r\n\r\nThe\soriginal\sfix\sfor\sthis\sticket\s(see\scheck-in\s[f2d175f975cd])\scaused\ssuch\r\nqueries\sto\sgive\san\serror:\s\s"ambiguous\scolumn:\sa".\s\sThe\squery\sis\sindeed\s\r\nincorrect.\s\sNevertheless,\swe\sneed\sto\sfind\sa\sway\sto\sget\sSQLite\sto\srun\sand\r\nreturn\sthe\scorrect\sresult\seven\sfor\sthese\sincorrect,\slegacy\squeries.
J login drh
J mimetype text/x-fossil-wiki
J resolution Open
J status Open
K 1c69be2dafc28b9f2d80ff022c89395afa106083
U drh
Z b8b6baec2cf1d3ca9b9daf2633d28acc