db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: Strange behaviour when combining column alias and group by
Date Thu, 12 May 2005 22:20:43 GMT
Well, fix for Derby-127 doesn't fix this. Looks like we need a new Jira
entry. Exposed name handling is getting better, but looks like still has
some kinks.

Satheesh

Bernt M. Johnsen wrote:

>I stumbeled across this strange behaviour when combining coumn alias
>and group by:
>
>ij> select * from tt;
>I          |J          
>-----------------------
>1          |2          
>2          |3          
>1          |2          
>2          |3          
>2          |3          
>
>5 rows selected
>ij> select i, count(*) as cnt from tt group by i;
>I          |CNT        
>-----------------------
>1          |2          
>2          |3          
>
>2 rows selected
>ij> select i, count(*) as i from tt group by i;
>I          |I          
>-----------------------
>1          |1          
>2          |2          
>
>2 rows selected
>
>The last select is obviously wrong! This might be related to
>DERBY-127, but if it's not I'll file it asa separate issue.
>
>
>  
>


Mime
View raw message