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. > > > >
