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

Description

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.

Environment

version-hibernate-3.5.6
database-Mqsql 5.1.54

Activity

Show:
Brett Meyer
October 29, 2013, 4:12 PM

Please provide a test case that reproduces this issue – thanks!

Brett Meyer
December 19, 2013, 10:31 PM

Note: In an attempt to clean up the HHH JIRA, we will be rejecting any ticket that sits in the "Awaiting Test Case" state for 2-3 months with no response. So, if this issue is critical to you, please attach a reproducing test case ASAP. Thanks!

Brett Meyer
March 3, 2014, 3:41 PM

Bulk rejecting issues lacking a test case or recent response.

Assignee

Unassigned

Reporter

MANISH

Fix versions

None

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

Priority

Major
Configure