Re: LIKE operator in Apache ignite SQL

Yes, it is working. Thanks, Ilya -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: LIKE operator in Apache ignite SQL

Hello! I believe this is the case! Have you checked? Regards, -- Ilya Kasnacheev 2018-05-23 12:38 GMT+03:00 the_palakkaran : > @ilya So does this mean an SQL field query executed on a cache as "select > custNo from Customer where custId like '%SAM%'" will work and

Re: LIKE operator in Apache ignite SQL

@ilya So does this mean an SQL field query executed on a cache as "select custNo from Customer where custId like '%SAM%'" will work and return values ? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: LIKE operator in Apache ignite SQL

LIKE in Apache Ignite should work as it is described in SQL standard, where '%' means 'any characters'. Note that indexes can only be used with LIKE if wildcard is not used at first position: foo LIKE '%bar%' - no index. foo LIKE 'bar%' - can use index. Regards, -- Ilya Kasnacheev 2018-05-23

LIKE operator in Apache ignite SQL

Hi, will like operator work in Apache ignite in the same way as in Oracle? I saw somewhere it should be uses as key=%value%. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/