SQLite Forum

Unexpected results with IS NOT NULL
Login
Hi all.

For query:

```SQL
CREATE TABLE v0 ( v2 INT, v1 INT);
INSERT INTO v0 VALUES ( 10, 10 );
CREATE UNIQUE INDEX v4 ON v0 ( v1 ) WHERE v2 > NULL;

SELECT * FROM v0;
/* 10 | 10 */
SELECT * FROM v0 WHERE v0.v2 IS NOT NULL;
/* EMPTY */
```

The second SELECT statement failed to output the row. Fossil bisecting results show the bug introduced commit is: [fc98218cf69e63bdb9e5f154521a341508502cd8cfe04cb870cabee2d99e0cb3][1].

[1]: src:/timeline?c=fc98218cf69e63bdb9e5

Looking forward to your reply.