SQLite Forum

COUNT statement returns inconsistent values when used with UNION ALL
Login
For query: 


```SQL
CREATE VIEW v0 ( v1 ) AS SELECT CAST ( 0 AS VARCHAR(1) );
CREATE VIEW v2 ( v3 ) AS SELECT * FROM v0 UNION ALL SELECT ( v1 IN ( 10) ) from v0;
SELECT * FROM v2 NATURAL JOIN v2;
SELECT COUNT(*) FROM v2 NATURAL JOIN v2;
```

The expected answer should be: 00 2. 
However, the actual output is: 0000 2.

This problem seems to be introduced by de9ed6293de53e89b7c37e7de9a8697d86d7f619