[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-6915) Restrictions.ilike(String propertyValue, Object value) does not correctly initialize LikeExpresison
Shawn Clowater (JIRA)
noreply at atlassian.com
Mon Apr 2 23:43:50 EDT 2012
[ https://hibernate.onjira.com/browse/HHH-6915?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=46149#comment-46149 ]
Shawn Clowater commented on HHH-6915:
-------------------------------------
Steve, it used to be EXACT (since it was passing null to the LikeExpression for MatchMode) but it got flipped to ANYWHERE with this change.
> Restrictions.ilike(String propertyValue, Object value) does not correctly initialize LikeExpresison
> ---------------------------------------------------------------------------------------------------
>
> Key: HHH-6915
> URL: https://hibernate.onjira.com/browse/HHH-6915
> Project: Hibernate ORM
> Issue Type: Bug
> Components: core
> Affects Versions: 4.0.0.Final
> Reporter: Martin Kartumovich
> Assignee: Steve Ebersole
> Priority: Minor
> Labels: criteria
> Fix For: 4.1.2
>
> Time Spent: 22m
>
> The method Restrictions.ilike(String propertyValue, Object value) uses the LikeExpression-Constructor LikeExpression(propertyName, value.toString()) which will initialize the LikeExpression with "ignoreCase = false".
> The resulting SQL shows a normal "xyz like ?" instead of the expected "lower(xyz) like lower(?)" (i.e. Oracle10gDialect).
> This issue seems to have been introduced with HHH-4943.
> Workaround: Use Restrictions.ilike(String propertyValue, Object value, MatchMode mode). This will correctly initialize LikeExpression with "ignoreCase = true".
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the hibernate-issues
mailing list