[Hibernate-issues] [Hibernate-JIRA] Commented: (HB-374) Wrong SQL statement with field "elementId"

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

The following comment has been added to this issue:

     Author: Andrei Pavlenko
    Created: Mon, 6 Oct 2003 3:36 AM
       Body:
Still not working.

List list = ses.find("from AttributeValue as attributeValue where attributeValue.elementId = ? and attributeValue.attributeId = ?", new Object[]{new Long(9001), new Long(9001)}, new Type[]{Hibernate.LONG, Hibernate.LONG});

---------------------------------------------------------------------
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: Wrong SQL statement with field "elementId"
       Type: Bug

     Status: Unassigned
   Priority: Blocker

    Project: Hibernate2
   Versions:
             2.0.3

   Assignee: 
   Reporter: Andrei Pavlenko

    Created: Wed, 1 Oct 2003 9:32 AM
    Updated: Wed, 1 Oct 2003 9:36 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