SQLite Forum

Unexpected return from the NULL column
Login
Thank you for the correction! 

In this case, is the output row from the first query expected?

Assuming v3 is being calculated as `NULL`, we replaced v3 into `NULL` in the WHERE clause of the first query and observe this: 

```SQL
CREATE TABLE v0 ( v1);
INSERT INTO v0 VALUES ( 255);
ALTER TABLE v0 ADD COLUMN v3 AS ( NULL) NOT NULL;
SELECT "-----";
SELECT * FROM v0 WHERE NULL NOT IN ( SELECT count ( * ) FROM v0);
/* Return NULL */
```

This is expected but mismatched with the original outputs.