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

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

Message:

   The following issue has been closed.

   Resolver: Gavin King
       Date: Sat, 14 Jun 2003 4:54 AM

The trouble here is that "true" is not really standard SQL. I know Postgres recognizes this, but Hibernate's Dialect system doesn't yet try and abstract these kind of details. For now, use the workaround you discovered.

The parser of the where attribute is pretty braindead, but capable of handling _most_ use cases.
---------------------------------------------------------------------
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: Closed
   Priority: Major
 Resolution: WON'T FIX

    Project: Hibernate2
 Components: 
             core
   Versions:
             2.0 final

   Assignee: Gavin King
   Reporter: Antoni Reus

    Created: Fri, 13 Jun 2003 6:47 AM
    Updated: Sat, 14 Jun 2003 4:54 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