Re: GROUP BY

Lennart <erik.lennart.jonsson_at_gmail.com> wrote in news:f2n1on$m8d$1 _at_registered.motzarella.org:

> V.J. Kumar wrote:
> [...]

>>> SELECT 1
>>> FROM r
>>> GROUP BY ();
>>> 
>>> returns a single tuple even if r is empty.
>> 
>> What SQL would that be? 

What have 'extended grouping capabilities' got to do with the claim that the simple 'group by' miraculously creates a tuple out of nothing ? It does not, either in the implementations I referred to or in the '92 standard. Neither does it in '99, btw ! Also 'select 1 from t1 group by grouping sets ()' is syntactically incorrect in both implementations.

>
> /Lennart
>
> PS, Mimer (or whatever the are called these days) has a sql validator
> where one can test conformance against different versions of sql:
>
> http://developer.mimer.com/validator/index.htm
>
> DS.
>
> [...]
>
Received on Sat May 19 2007 - 16:52:15 CEST