AND does not work as intended

[Gloix]

If i test the query:

select * from users where email = '[email protected]'

I get 1 record (assuming that email exists) with the email field matching that of the query, and also with another field country='US'. If I extend the query like this:

select * from users where email = '[email protected]' AND country = 'US'

I get zero results.

[JoeRoddy]

Surprised I didn't notice this. Thanks @Gloix .

You can use a lower-case 'and' for now and it should work as intended. I'll have this fixed for the next release.

[Gloix]

Wow I never tested with the lowercase version. Thank you, I'll use that for now.

[Gloix]

Speaking of which, I tested the OR operator as well, with no luck as well. Uppercase and lowercase 😕.

[JoeRoddy]

Right, maybe we should make another issue for that at some point. I have a page with some of the supported/non-supported features here. It's possible it's out of date.

[Gloix]

Oh right, I'm sorry, I didn't see that. Maybe outputting an error in response to a query with missing operators will prevent people from reporting things like that :)

[JoeRoddy]

Great idea @Gloix ! Right now it's just the "Documentation" button in the sidebar, but I doubt many people actually click it. Error handling could definitely use a lot of work in general.