Hi everyone, i’m in the community. I’ve been starting to use scylladb lately and i just noticed that i cant use “brackets” in where clause, at least not to encapsulate blocks, this prevents me from using ‘or’ properly, and yes, im not using allow filtering, anyway, what i noticed is that i cant do this:
select * from users
where (country = ‘BR’ and state = ‘SP’) or (country = ‘BR’ and state = ‘RJ’)
when i try to do this i get an error saying that i’m missing ‘)’
even though i’m not, and weird as it sounds, looking at the docs, it seems to me that i was supposed to be able to do this