[ https://issues.apache.org/jira/browse/IGNITE-3999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16472819#comment-16472819 ]
Valentin Kulichenko commented on IGNITE-3999: --------------------------------------------- [~dpavlov], [~vozerov], [~aakhmedov] Guys, I'm not going to judge whether the solution proposed here is the best one or not - Vladimir knows better. However, I do know that this functionality is highly demanded - there were multiple requests from our users. Having said that, I'm OK with closing this ticket as long as we have an alternative. Personally, I really like the idea of supporting function indexes. They would cover case-insensitive search, as well as many other use cases. > Support case insensitive search in SQL > -------------------------------------- > > Key: IGNITE-3999 > URL: https://issues.apache.org/jira/browse/IGNITE-3999 > Project: Ignite > Issue Type: Improvement > Components: sql > Affects Versions: 1.7 > Reporter: Valentin Kulichenko > Assignee: Amir Akhmedov > Priority: Critical > Labels: sql-engine > Fix For: 2.6 > > > Currently case insensitive search is possible only with the help of > {{lower()}} function: > {code} > select name from MyValue where lower(name) = 'abc_5' > {code} > But this will always be a full scan, even if {{name}} field is indexed. > We need to correctly support {{VARCHAR_IGNORECASE}} H2 type in Ignite and add > a respective property to {{@QuerySqlField}} annotation. -- This message was sent by Atlassian JIRA (v7.6.3#76005)