On Thu, Jun 21, 2012 at 11:47 AM, Marco Bambini <ma...@sqlabs.net> wrote: > Consider the following example: > > CREATE TABLE t1(x); > CREATE TABLE t2(y); > SELECT max((SELECT avg(x) FROM t2)) FROM t1; > > With sqlite 3.7.11 NULL is returned, while with sqlite 3.7.13 an error > "Misuse of aggregate: avg()" is returned. > Any thought?
3.7.11 had a bug, 3.7.13 fixed it. Your query is invalid, t2 doesn't have column named x. Pavel _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
