Re: [sqlite] GROUPY BY alias backward incompatibility

On Thu, May 28, 2009 at 04:30:14PM +0200, Ralf Junker wrote: > 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

Re: [sqlite] GROUPY BY alias backward incompatibility

> * The query that works on SQLite all versions fails on Oracle. False conclusion. Did you try to make only one row in t? > * Behaviour is inconsistent between MySQL and Oracle. I believe this conclusion is also false. Did you try several rows in t on MySQL? If it worked I wonder how it showed

Re: [sqlite] GROUPY BY alias backward incompatibility

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? I could now run the queries on Oracle Database 10g Express Edition Release 10.2.0.1.0. Prepare the table: create table t

Re: [sqlite] GROUPY BY alias backward incompatibility

ussion of SQLite Database Subject: Re: [sqlite] GROUPY BY alias backward incompatibility 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

Re: [sqlite] GROUPY BY alias backward incompatibility

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

Re: [sqlite] GROUPY BY alias backward incompatibility

On May 28, 2009, at 7:01 AM, Ralf Junker wrote: > > drop table if exists t; > create table t (c); > select >(select count() from t as t_inner > group by t_outer.c) > from t as t_outer; > > This behaviour changed in version 3.5.4. From then on, SQLite issues > an "SQL error near line

Re: [sqlite] GROUPY BY alias backward incompatibility

At 13:27 28.05.2009, D. Richard Hipp wrote: >On May 28, 2009, at 7:01 AM, Ralf Junker wrote: > >> Hello! >> >> Up to version 3.5.3, SQLite would happily execute this SQL without >> complaints: >> >> drop table if exists t; >> >> create table t (c); >> >> select >>(select count() from t t_

Re: [sqlite] GROUPY BY alias backward incompatibility

At 13:27 28.05.2009, D. Richard Hipp wrote: >On May 28, 2009, at 7:01 AM, Ralf Junker wrote: > >> Hello! >> >> Up to version 3.5.3, SQLite would happily execute this SQL without >> complaints: >> >> drop table if exists t; >> >> create table t (c); >> >> select >>(select count() from t t_

Re: [sqlite] GROUPY BY alias backward incompatibility

On May 28, 2009, at 7:01 AM, Ralf Junker wrote: > Hello! > > Up to version 3.5.3, SQLite would happily execute this SQL without > complaints: > > drop table if exists t; > > create table t (c); > > select >(select count() from t t_inner > group by t_outer.c) > from t t_outer; > Thi

[sqlite] GROUPY BY alias backward incompatibility

Hello! Up to version 3.5.3, SQLite would happily execute this SQL without complaints: drop table if exists t; create table t (c); select (select count() from t t_inner group by t_outer.c) from t t_outer; This behaviour changed in version 3.5.4. From then on, SQLite issues an