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