db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kathey Marsden (JIRA)" <derby-...@db.apache.org>
Subject [jira] Updated: (DERBY-765) Valid query fails with ERROR X0A00: The select list mentions column 'A' twice...
Date Wed, 26 Jul 2006 16:53:14 GMT
     [ 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

        

Mime
View raw message