SQLite Forum

documenting SQLite's "IS" behavior
Login
Well, almost, there's another wrinkle.

See if the right operand of IS (or IS NOT) is a boolean literal it changes its meaning.

So for instance

```
select 2 is true 
1
```

but 

```
select 2 is not distinct from true
false
```

The is operator changes its meaning if its right operand is either of the literals true or false.  So "IS" is distinct from "IS DISTINCT FROM" :D