db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Manish Khettry <manish_khet...@yahoo.com>
Subject Re: [jira] Commented: (DERBY-883) Enhance GROUP BY clause to support expressions instead of just column references.
Date Fri, 07 Jul 2006 03:35:24 GMT
Is it reasonable to exclude support for expressions in
the having clause in the first cut? i.e.

-- this is supported.
select c1+c2, sum(c3) from test group by c1+c2; 

-- this is not.
select c1+c2, sum(c3) from test group by c1+c2 having
c1+c2 > 1;

It turns out the query rewrite we do for group by's
(see the coments in the parser for about line 8068)
complicates things substantially. It would be good if
someone could clarify or explain the rationale for
doing things this way.

Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 

View raw message