db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matt Solnit <msol...@soasta.com>
Subject Re: Unable to group by certain functions
Date Wed, 04 Mar 2009 21:25:26 GMT
P.S.  I forgot to include the following:

Derby version 10.4.2.0
Java version 1.5.0_16
Mac OS X 10.5.6 (32-bit)

On 3/4/09 1:22 PM, "Matt Solnit" <msolnit@soasta.com> wrote:

> Hi all.  I'm trying to use GROUP BY with Derby, and it looks like certain
> functions work and certain ones don't.
> 
> For example, the following:
> 
> ij> CREATE TABLE foo (a INT);
> ij> SELECT ABS(a) FROM foo GROUP BY ABS(a);
> 
> works fine.  But if I use CEIL or FLOOR, I get an error:
> 
> ij> SELECT CEIL(a) FROM foo GROUP BY CEIL(a);
> 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.
> 
> I'm not sure what the difference is, but I came across DERBY-592 (JDBC-escaped
> functions) and I'm wondering if this is part of the issue.
> 
> Am I doing something incorrectly, or is this a bug?
> 
> -- Matt


Mime
View raw message