I think this is a consequence of the oddity described here: [](https://www.sqlite.org/datatype3.html#affcompoundview) The expression is true if "c0" is assigned INTEGER affinity, but false if it is assigned BLOB affinity. And since which affinity the column is assigned is indeterminate, so are the results of the query. Dan.