db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Manish Khettry (JIRA)" <j...@apache.org>
Subject [jira] Assigned: (DERBY-2457) Use of column aliases in group by / having clauses can cause queries to fail
Date Thu, 22 Mar 2007 05:40:32 GMT

     [ https://issues.apache.org/jira/browse/DERBY-2457?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Manish Khettry reassigned DERBY-2457:
-------------------------------------

    Assignee: Manish Khettry

> 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.0.0
>            Reporter: Andrew McIntyre
>         Assigned To: Manish Khettry
>            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.


Mime
View raw message