You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Amir Akhmedov (JIRA)" <ji...@apache.org> on 2016/11/03 14:47:58 UTC
[jira] [Assigned] (IGNITE-3999) Support case insensitive search in
SQL
[ https://issues.apache.org/jira/browse/IGNITE-3999?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Amir Akhmedov reassigned IGNITE-3999:
-------------------------------------
Assignee: Amir Akhmedov
> Support case insensitive search in SQL
> --------------------------------------
>
> Key: IGNITE-3999
> URL: https://issues.apache.org/jira/browse/IGNITE-3999
> Project: Ignite
> Issue Type: Improvement
> Components: cache
> Affects Versions: 1.7
> Reporter: Valentin Kulichenko
> Assignee: Amir Akhmedov
> Priority: Critical
> Fix For: 1.8
>
>
> 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
(v6.3.4#6332)