What's the difference between the two queries?

What's the difference between the two queries?

  
Why doesn't this work:

but does this work:


In the first query you aren't really specifying a where clause.

A proper where clause is composed by a "field", a "comparation" and a "value".
Although your field is of type boolean, you aren't specifying a where clause. The logic is right, but the syntax isn't.
As you have written too, "1 = 1" works because it's a valid clause (because it has the three elements) but if you only wrote "1" it wouldn't work.

Happy querying,
Pedro Magalhães
That's too bad; I'd hope the Sequal Server would evaluate both statements equally.
Note that Outsystems accepts the above syntax without a warning.