[Hibernate-issues] [Hibernate-JIRA] Created: (HB-134) the "where" attribute in collection mapping generates incorrect sql

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

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