After switching from hibernate 3.6.8 to 4 using Oracle10gDialect the case insensitive Restrictions.ilike does not work any longer. The resulting sql shows a normal "where xyz like ?" instead of "where lower(xyz) like lower(?)".
I did not find any comments on this in the release notes or the migration guide. So I took a look in the source and found that with hibernate 4 a new method has been introduced in Dialect.java: "supportsCaseInsensitiveLike". This method returns false by default and is only overridden in PosgresSQLDialect.
Does anyone know why the OracleDialects do not support ilike any longer?
Thanks.

After some more searching in the sources i found the cause. It seems to be a bug that was introduced with HHH-4943:
The method Restrictions.ilike(String propertyValue, Object value) uses the LikeExpression-Constructor LikeExpression(propertyName, value.toString()) which will initialize LikeExpression with "ignoreCase = false".
I think this not the expected behaviour.

Workaround: Use Restrictions.ilike(String propertyValue, Object value, MatchMode mode).

Created a new issue for this:
https://hibernate.onjira.com/browse/HHH-6915