Nikolay Izhikov commented on IGNITE-3999:

Hello, [~aakhmedov].

As far as I can see there are some unfixed comments in Upsource from Alexander 
I'm also done a preliminary review and leave some comments in Upsource.

Please, see all the comments and fix it. 

> 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.5
> 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

Reply via email to