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