[hibernate-issues] [Hibernate-JIRA] Created: (HHH-7111) Uppercase support for ILikeExpression.

[Sebastian (JIRA)]

Uppercase support for ILikeExpression.
--------------------------------------

                 Key: HHH-7111
                 URL: https://hibernate.onjira.com/browse/HHH-7111
             Project: Hibernate ORM
          Issue Type: Improvement
          Components: query-criteria
            Reporter: Sebastian


If you want to do an ignore case like restriction (with ilike) the resulting SQL always uses the lower function.

That's unfortunate especially when an index on a column is uppercase and you want to make use of that index. It's also hard to convince DBAs to change their indexes because Hibernate doesn't support uppercase likes.

It would be nice to specify if upper() or lower() in ilike() should be used.

I know I can use upper() in HQL but than I would miss out all the advantages of the Criteria API.

Cheers,

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira