Message:
A new issue has been created in JIRA.
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-134
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-134
Summary: the "where" attribute in collection mapping generates incorrect sql
Type: Bug
Status: Unassigned
Priority: Major
Project: Hibernate2
Components:
core
Versions:
2.0 final
Assignee:
Reporter: Antoni Reus
Created: Fri, 13 Jun 2003 6:47 AM
Updated: Fri, 13 Jun 2003 6:47 AM
Environment: RedHat Linux 7.2, JBoss 3.2.1, J2SDK 1.4.1_02, PostgreSQL 7.3.2
Description:
I have a mapping with the following set:
....
<set
name="fillsPublicats"
order-by="data desc"
inverse="true"
lazy="true"
cascade="all"
where="publicat = true" >
<jcs-cache usage="read-write"/>
<key column="pare_id" />
<one-to-many class="org.ibit.foros.model.Missatge"/>
</set>
....
When the Collection gets initialized it generates the query with this where clause:
WHERE FO_MI0_.pare_id=? and FO_MI0_.publicat = FO_MI0_.true
^^^^^^^^
ORDER BY FO_MI0_.data desc;
that throws a JDBCException
while the expected would be:
WHERE FO_MI0_.pare_id=? and FO_MI0_.publicat = true
ORDER BY FO_MI0_.data desc;
---------------------------------------------------------------------
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/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
