[
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)
