At 15:37 28.05.2009, D. Richard Hipp wrote:
>Have you tried these two queries on other SQL database engines besides
>SQLite? What do PostgreSQL and MySQL make of them?
MySQL (5.0.21) reports no erros on either of both queries:
select
(select count(*) from t t_inner
group by t_outer.c) -- t_outer !!!
from t t_outer;
select
(select count(*) from t t_inner
group by t_inner.c) -- t_inner !!!
from t t_outer;
I do not have access to PostgreSQL right now.
The SQLite help [1] says: "The expressions in the GROUP BY clause do not have
to be expressions that appear in the result." Reading this, I'd expect that
both queries should run - even if the 1st one does not make much sense.
Opinions?
Ralf
[1] http://www.sqlite.org/lang_select.html
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
