ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pavel Tupitsyn <ptupit...@apache.org>
Subject Re: case sensitive Apache ignite.net SQL query
Date Wed, 22 Aug 2018 09:35:49 GMT
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.zhuravlev.wk@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/
>>
>

Mime
View raw message