Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Development" <derby-dev@db.apache.org>
Received-SPF: neutral (hermes.apache.org: local policy)
Message-ID: <4283FEC3.2030600@sbcglobal.net>
Date: Thu, 12 May 2005 18:11:31 -0700
From: Jack Klebanoff <klebanoff-derby@sbcglobal.net>
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
MIME-Version: 1.0
To: Derby Development <derby-dev@db.apache.org>
Subject: Re: Strange behaviour when combining column alias and group by
References: <20050512085353.GC18345@atum01.norway.sun.com>
In-Reply-To: <20050512085353.GC18345@atum01.norway.sun.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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.
>
>
>  
>
I think that this is a different issue than Derby-127. Derby-127 
concerned the combination of group by with order by. The two are 
probably related. Please file a separate Jira-report for this one.

Jack Klebanoff