i am seeing that pinot query doesnt work for “*not like”* clause. its working as like.. is there a known bug?

@Atri Sharma @Rong R

Can you elaborate a bit? Not able to see the screenshot for some reason. Is it giving wrong results or a compilation error?

Its giving wrong result. Both like and not like are giving same result

Can you share the exact query? I will try reproducing

select distinct countries from bidrequest where countries not like ‘%AR%’

I could reproduce this

Yeah, I did spend some time on this and NOT is not being respected for LIKE. I will fix that this week