[Hibernate-issues] [Hibernate-JIRA] Closed: (HB-130) "where" attribute of collections mapping translates into SQL badly

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

Message:

   The following issue has been closed.

   Resolver: Gavin King
       Date: Fri, 13 Jun 2003 5:09 AM

Yep, missing a toLowerCase()

Fixed in CVS. A workaround is to use lowercase SQL.
---------------------------------------------------------------------
View the issue:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-130


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-130
    Summary: "where" attribute of collections mapping translates into SQL badly
       Type: Bug

     Status: Closed
   Priority: Critical
 Resolution: FIXED

    Project: Hibernate2
   Fix Fors:
             2.0.1
   Versions:
             2.0 final

   Assignee: Gavin King
   Reporter: Hrituc Ovidiu

    Created: Wed, 11 Jun 2003 8:52 AM
    Updated: Fri, 13 Jun 2003 5:09 AM
Environment: Win 2K Professional, Hib used under OC4J with SQL Server 2000

Description:
I added this filter on collection to get a subset of the original colection: "DATA_FIN IS NULL"
and Hibernate put this to the end of the SQL statement:
... and Perso0_.DATA_FIN Perso0_.IS Perso0_.NULL
I guess that if the SQL islands inside HQL will be solved maybe this will go away too.


---------------------------------------------------------------------
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