[Hibernate-issues] [Hibernate-JIRA] Updated: (HB-374) Duplicate column in SQL select clause

[<leg...@at...>]

The following issue has been updated:

    Updater: Gavin King (mailto:ga...@in...)
       Date: Tue, 21 Oct 2003 2:33 AM
    Changes:
             summary changed from Wrong SQL statement with field "elementId"
             priority changed from Blocker
    ---------------------------------------------------------------------
For a full history of the issue, see:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-374&page=history

---------------------------------------------------------------------
View the issue:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-374


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-374
    Summary: Duplicate column in SQL select  clause
       Type: Bug

     Status: Assigned
   Priority: Critical

    Project: Hibernate2
   Versions:
             2.0.3

   Assignee: Gavin King
   Reporter: Andrei Pavlenko

    Created: Wed, 1 Oct 2003 9:32 AM
    Updated: Tue, 21 Oct 2003 2:33 AM
Environment: Sybase

Description:
I have "composite-id" with two fields.
I want to create "many-to-one" reference for field "elementId" but generated by Hibernate SQL query is incorrect.

When I change column name to "elementOwnerId" it is generated correctly.

See attached files.


Wrong SQL:
select attribut0_.attributeId as attributeId, attribut0_.elementId as elementId, attribut0_.possibleAttributeValueId as possible3_, attribut0_.attributeValueFreeText as attribut4_, attribut0_.attributeId as attribut1_, attribut0_.elementId as elementId from AttributeValue attribut0_ where (attribut0_.elementId=? )and(attribut0_.attributeId=? )

Error message:
Select expression results in more than one column having same name. Column name 'elementId' is specified more than once


---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.

If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira