You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@ignite.apache.org by shuvendu <sh...@travelcentrictechnology.com> on 2018/08/22 09:04:10 UTC

case sensitive Apache ignite.net SQL query

Hi,

How to make apache ignite sqlquery to ignore case.

for example

var _arg = new object[] { "%abc%" };

new SqlQuery(typeof(CustomerModel), "CustomerName like ?", _arg)

var _arg = new object[] { "%ABC%" };

new SqlQuery(typeof(CustomerModel), "CustomerName like ?", _arg)

i am getting different results in both the cases

Thanks

Shuvendu




--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: case sensitive Apache ignite.net SQL query

Posted by Pavel Tupitsyn <pt...@apache.org>.

Hi,

The workaround is to use UPPER SQL function:

var _arg = new object[] { "%ABC%" };
new SqlQuery(typeof(CustomerModel), "UPPER(CustomerName) like ?", _arg)

Pavel

On Wed, Aug 22, 2018 at 12:15 PM Evgenii Zhuravlev <e....@gmail.com>
wrote:

> Hi,
>
> As for now, Ignite SQL is case-sensitive. There are plans to
> support case-insensitive search in SQL in future, here is the ticket:
> https://issues.apache.org/jira/browse/IGNITE-3999
>
> Evgenii
>
> ср, 22 авг. 2018 г. в 12:04, shuvendu <
> shuvendu.das@travelcentrictechnology.com>:
>
>> Hi,
>>
>> How to make apache ignite sqlquery to ignore case.
>>
>> for example
>>
>> var _arg = new object[] { "%abc%" };
>>
>> new SqlQuery(typeof(CustomerModel), "CustomerName like ?", _arg)
>>
>> var _arg = new object[] { "%ABC%" };
>>
>> new SqlQuery(typeof(CustomerModel), "CustomerName like ?", _arg)
>>
>> i am getting different results in both the cases
>>
>> Thanks
>>
>> Shuvendu
>>
>>
>>
>>
>> --
>> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>>
>

Re: case sensitive Apache ignite.net SQL query

Posted by Evgenii Zhuravlev <e....@gmail.com>.

Hi,

As for now, Ignite SQL is case-sensitive. There are plans to
support case-insensitive search in SQL in future, here is the ticket:
https://issues.apache.org/jira/browse/IGNITE-3999

Evgenii

ср, 22 авг. 2018 г. в 12:04, shuvendu <
shuvendu.das@travelcentrictechnology.com>:

> Hi,
>
> How to make apache ignite sqlquery to ignore case.
>
> for example
>
> var _arg = new object[] { "%abc%" };
>
> new SqlQuery(typeof(CustomerModel), "CustomerName like ?", _arg)
>
> var _arg = new object[] { "%ABC%" };
>
> new SqlQuery(typeof(CustomerModel), "CustomerName like ?", _arg)
>
> i am getting different results in both the cases
>
> Thanks
>
> Shuvendu
>
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>