db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bryan Pendleton (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-2457) Use of column aliases in group by / having clauses can cause queries to fail
Date Sat, 10 May 2008 01:49:55 GMT

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

Bryan Pendleton updated DERBY-2457:
-----------------------------------

    Attachment: additionalTests.diff

Attached is 'additionalTests.diff', which is a straightforward
conversion of '1624_repro.sql' into a patch to GroupByTest.java.

I think it's valuable having these tests, even if we decide that
the current behavior is current and that we don't want to change it.
In that case, the tests will serve to verify the desired behavior.

Also, if someone should experiment with changing the behavior
in the future, having these tests in the system will draw people's
attention to this JIRA entry, and thus to the discussion and comments
in the issue.

So, I propose to commit the test-only patch, and resolve the 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, additionalTests.diff
>
>
> 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