You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ignite.apache.org by "Valentin Kulichenko (JIRA)" <ji...@apache.org> on 2016/09/28 22:56:22 UTC
[jira] [Created] (IGNITE-3999) Support case insensitive search in
SQL
Valentin Kulichenko created IGNITE-3999:
-------------------------------------------
Summary: 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
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)