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.
Please provide a test case that reproduces this issue – thanks!
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!
Bulk rejecting issues lacking a test case or recent response.