Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <1150882991.1210287535769.JavaMail.jira@brutus>
Date: Thu, 8 May 2008 15:58:55 -0700 (PDT)
From: "Bryan Pendleton (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Commented: (DERBY-2457) Use of column aliases in group by /
 having clauses can cause queries to fail
In-Reply-To: <4170688.1173999609456.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/DERBY-2457?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12595416#action_12595416 ] 

Bryan Pendleton commented on DERBY-2457:
----------------------------------------

I see the portion of the standard that Jack refers to, and I agree that
it specifies that only identifiers used in ORDER BY clauses should
be allowed to refer to derived columns. Section 6.6, syntax rule 8.a.i
appears to be the text that that Jack observed.

So perhaps we should resolve this issue as invalid?

> Use of column aliases in group by / having clauses can cause queries to fail
> ----------------------------------------------------------------------------
>
>                 Key: DERBY-2457
>                 URL: https://issues.apache.org/jira/browse/DERBY-2457
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 10.3.1.4
>            Reporter: Andrew McIntyre
>            Assignee: Bryan Pendleton
>            Priority: Minor
>         Attachments: 1624_repro.sql
>
>
> Some use of column aliases in group by / having clauses can cause queries to fail with error 42X04. The queries can sometimes be made to work by also aliasing the table or rewriting the query to use a subselect. Attached is a simple sql script which reproduces the issue, originally found as part of DERBY-1624.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.