[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2997?page=c... ] Vladimir Kralik updated HHH-2997: --------------------------------- Attachment: LikeExpression.patch Patch for Hibernate 3.2.6 -- 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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2997?page=c... ] Adam Czysciak updated HHH-2997: ------------------------------- Attachment: hibernate2997test.zip Attached a test case - bug occurs on Hibernate 3.2.6 as well. Adding Expression.like() and Expression.like().ignoreCase() to the Criteria works ok. Adding custom Expression (own class extending LikeExpression) doesn't work for ignoreCase=false - Hibernate always binds toLower()'ed value of the pattern. Test output: Hibernate: select test_seq.nextval from dual Hibernate: insert into test (text, ID) values (?, ?) DEBUG org.hibernate.type.StringType - binding 'XyZ uniq1206517288290 blablabla' to parameter: 1 DEBUG org.hibernate.type.IntegerType - binding '16' to parameter: 2 Hibernate: select this_.ID as ID0_0_, this_.text as text0_0_ from test this_ where this_.text like ? DEBUG org.hibernate.type.StringType - binding 'XyZ uniq1206517288290%' to parameter: 1 DEBUG org.hibernate.type.IntegerType - returning '16' as column: ID0_0_ DEBUG org.hibernate.type.StringType - returning 'XyZ uniq1206517288290 blablabla' as column: text0_0_ Hibernate: select this_.ID as ID0_0_, this_.text as text0_0_ from test this_ where lower(this_.text) like ? DEBUG org.hibernate.type.StringType - binding 'xyz uniq1206517288290%' to parameter: 1 DEBUG org.hibernate.type.IntegerType - returning '16' as column: ID0_0_ DEBUG org.hibernate.type.StringType - returning 'XyZ uniq1206517288290 blablabla' as column: text0_0_ Hibernate: select this_.ID as ID0_0_, this_.text as text0_0_ from test this_ where lower(this_.text) like ? escape '\' DEBUG org.hibernate.type.StringType - binding 'xyz uniq1206517288290%' to parameter: 1 DEBUG org.hibernate.type.IntegerType - returning '16' as column: ID0_0_ DEBUG org.hibernate.type.StringType - returning 'XyZ uniq1206517288290 blablabla' as column: text0_0_ Hibernate: select this_.ID as ID0_0_, this_.text as text0_0_ from test this_ where this_.text like ? escape '\' DEBUG org.hibernate.type.StringType - binding 'xyz uniq1206517288290%' to parameter: 1 -- 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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2997?page=c... ] Christian Jaeger commented on HHH-2997: --------------------------------------- Albert is right - the problem lies in org.hibernate.criterion.LikeExpression: in getTypedValues, the value is always converted to lower case, even if the search should be case-sensitive. This problem still isn't fixed in version 3.5.0. This is a major issue on databases where "like" queries always search case-sensitive (e.g. on Oracle). On these databases, if ignoreCase = false, LikeExpression will currently EXCLUDE any results with uppercase letters. You won't recognize the difference on databases that don't search case-sensitive, e.g. MS Sql Server). -- 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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2997?page=c... ] Strong Liu resolved HHH-2997. ----------------------------- Resolution: Fixed Fix Version/s: 3.5.0.Next 3.3.x 3.2.x patch applied, thanks very much -- 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