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
|
