SQLite Forum

operators IS TRUE and IS FALSE missing from diagrams and table plus possible evaluation errors
Login
Unfortunately `IS TRUE` is not the same as `<> 0`.  There are the `NULL` cases to consider. Like regular `IS` that's its main reason for existing.