[hibernate-issues] [Hibernate-JIRA] Created: (HHH-6345) sql like restriction and projection on a same field does not work (database -- mqsql)

[MANISH (JIRA)]

sql like restriction and projection on a same field does not work (database -- mqsql)
-------------------------------------------------------------------------------------

                 Key: HHH-6345
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6345
             Project: Hibernate Core
          Issue Type: Bug
          Components: query-criteria
    Affects Versions: 3.5.6
         Environment: version-hibernate-3.5.6 
database-Mqsql 5.1.54

            Reporter: MANISH 


I encountered this problem when I put group by on two columns of a table using hibernate criteria.I want to access some columns from  the table using projection and I put the like restriction on the same columns using hibernate criteria that I want to access through projection. When I fetch the list I get the sql grammar exception. I track the issue, I found that the hibernate tries to put like clause on the column alias name which is not possible, ultimately hibernate is generating wrong sql query.

-- 
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
-
For more information on JIRA, see: http://www.atlassian.com/software/jira