[hibernate-issues] [JIRA] (HHH-12726) Serious performance issue in hibernate-core\src\main\java\org\hibernate\criterion\SimpleExpression.java when using with a database with case insensitive string comparisons

[Steve (JIRA)]

Steve ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5eb75ee87dab3a0bb44c752a ) *commented* on HHH-12726 ( https://hibernate.atlassian.net/browse/HHH-12726?atlOrigin=eyJpIjoiODdlNmYzMDU5YWRjNDMyNGFhYzEyZjNjNjQ1M2YxZjQiLCJwIjoiaiJ9 )

Re: Serious performance issue in hibernate-core\src\main\java\org\hibernate\criterion\SimpleExpression.java when using with a database with case insensitive string comparisons ( https://hibernate.atlassian.net/browse/HHH-12726?atlOrigin=eyJpIjoiODdlNmYzMDU5YWRjNDMyNGFhYzEyZjNjNjQ1M2YxZjQiLCJwIjoiaiJ9 )

Is there any workaround yet?
I'm facing the same "issue". I tried some workarounds using derived properties, but sometimes Hibernate won't create the column at all or just create a normal column...

If I don't find a good solution, I'll implement it in my business logic (just doing .toLowerCase before every access or using a second field...), but that's not something I would prefer over a built-in solution.

Using MariaDB102Dialect

( https://hibernate.atlassian.net/browse/HHH-12726#add-comment?atlOrigin=eyJpIjoiODdlNmYzMDU5YWRjNDMyNGFhYzEyZjNjNjQ1M2YxZjQiLCJwIjoiaiJ9 ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-12726#add-comment?atlOrigin=eyJpIjoiODdlNmYzMDU5YWRjNDMyNGFhYzEyZjNjNjQ1M2YxZjQiLCJwIjoiaiJ9 )

Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.core&referrer=utm_source%3DNotificationLink%26utm_medium%3DEmail ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailNotificationLink&mt=8 ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100126- sha1:9bc00fe )
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/hibernate-issues/attachments/20200510/0534658b/attachment.html