db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bernt M. Johnsen" <Bernt.John...@Sun.COM>
Subject Re: Functions in GROUP BY expressions? (related to DERBY-883)
Date Fri, 27 Oct 2006 06:24:40 GMT
>>>>>>>>>>>> Army wrote (2006-10-26 15:25:49):
>> [...]
>> // Doesn't work but seems like it could/should based on above queries...
> ij> select sin(i) from t1 group by sin(i);
> ERROR 42Y30: The SELECT list of a grouped query contains at least one 
> invalid expression. If a SELECT list has a GROUP BY, the list may only 
> contain valid grouping expressions and valid aggregate expressions.
> [...]

To me it seems natural that this one doesn't work. To group by double
or float values is not reasonable.

Bernt Marius Johnsen, Database Technology Group, 
Staff Engineer, Technical Lead Derby/Java DB
Sun Microsystems, Trondheim, Norway

View raw message