[ http://issues.apache.org/jira/browse/DERBY-765?page=all ]
Kathey Marsden updated DERBY-765:
---------------------------------
Derby Info: [Existing Application Impact, Regression, Release Note Needed]
This is a regression introduced by the fix for DERBY-280. After some
discussion on the list regarding that issue, it was decided that the state of
continuing to return wrong results was worse than introducing this new
regression as the fix requires a fairly significant change. It is my
understanding that DERBY-681 would fix this bug.
I think due dilligence for 10.2 even if the bug remains would include a
comprehensive release note in release note format with a documented workaround.
> Valid query fails with ERROR X0A00: The select list mentions column 'A'
> twice...
> --------------------------------------------------------------------------------
>
> Key: DERBY-765
> URL: http://issues.apache.org/jira/browse/DERBY-765
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.2.0.0
> Reporter: Kathey Marsden
> Priority: Minor
>
> The following query is valid but fails with 10.2
> ij> create table bug280
> (
> a int,
> b int
> );
> 0 rows inserted/updated/deleted
> ij> insert into bug280( a, b )
> values ( 1, 1 ), ( 1, 2 ), ( 1, 3 ), ( 2, 1 ), ( 2, 2 );
> 5 rows inserted/updated/deleted
> ij> select a+1 as a, a+1 as a from bug280 group by a;
> ERROR X0A00: The select list mentions column 'A' twice. This is not allowed
> in queries with GROUP BY or HAVING clauses. Try aliasing one of the
> conflicting columns to a unique name.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
