[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2997) LikeExpression case sensitive not working properly

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2997?page=c... ] Albert Fried commented on HHH-2997: ----------------------------------- The problem is IMHO in the class org.hibernate.criterion.LikeExpression (see the comments): public String toSqlString( Criteria criteria, CriteriaQuery criteriaQuery) throws HibernateException { Dialect dialect = criteriaQuery.getFactory().getDialect(); String[] columns = criteriaQuery.getColumnsUsingProjection( criteria, propertyName ); if ( columns.length != 1 ) { throw new HibernateException( "Like may only be used with single-column properties" ); } // THIS IS OK: String lhs = ignoreCase ? dialect.getLowercaseFunction() + '(' + columns[0] + ')' : columns[0]; return lhs + " like ?" + ( escapeChar == null ? "" : " escape \'" + escapeChar + "\'" ); } public TypedValue[] getTypedValues( Criteria criteria, CriteriaQuery criteriaQuery) throws HibernateException { // THIS IS NOT OK BECAUSE ALWAYS .toLowerCase(): return new TypedValue[] { criteriaQuery.getTypedValue( criteria, propertyName, value.toString().toLowerCase() ) // THIS COULD BE OK: // return new TypedValue[] { // criteriaQuery.getTypedValue( criteria, propertyName, // ignoreCase ? value.toString().toLowerCase() : value.toString() ) }; } -- 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