alias other than {this} does not work in sqlRestriction ------------------------------------------------------- Key: HHH-5668 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5668 Project: Hibernate Core Issue Type: Bug Components: query-criteria Environment: ALL Reporter: Dave DetachedCriteria c = .. c.createAlias("teacher","t").add(Restrictions.sqlRestriction("locate('abc', t.name)=2")); it caused sql error. It allows {this} alias only. all aliases defined should be allowed in 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