Incorrect GROUP BY when input and output columns have the same name
|User & Date:||drh 2014-06-10 20:11:36|
- Change icomment to:
It has come to light that some legacy Android applications are coded with queries that are logically equivalent to this: <blockquote><verbatim> CREATE TABLE t1(a,x); CREATE TABLE t2(a,y); SELECT t1.a AS a, x, y FROM t1, t2 GROUP BY a; </verbatim></blockquote> The original fix for this ticket (see check-in [f2d175f975cd]) caused such queries to give an error: "ambiguous column: a". The query is indeed incorrect. Nevertheless, we need to find a way to get SQLite to run and return the correct result even for these incorrect, legacy queries.
- Change login to "drh"
- Change mimetype to "text/x-fossil-wiki"
- Change resolution to "Open"
- Change status to "Open"