SQLite

In the following test case, unexpectedly, four rows are fetched, also containing two rows with duplicate v0.c0=1 values:

<pre>
CREATE TABLE t0(c0);
CREATE VIRTUAL TABLE vt0 USING fts5(c0);
INSERT INTO t0(c0) VALUES (1), (0);
INSERT INTO vt0(c0) VALUES (0), (0);
CREATE VIEW v0 AS SELECT DISTINCT t0.c0 FROM vt0, t0 ORDER BY vt0.rowid;
SELECT * FROM v0; -- unexpected: 4 rows are fetched
</pre>

The DISTINCT seems to work correctly when used together with a COUNT:

<pre>
SELECT COUNT(*) FROM v0 WHERE v0.c0; -- 1
</pre>

Problem introduced by check-in [171138122690faaf] (2014-04-25)
which was an attempt
to fix ticket [388d01d4bb8f9a8b].  That fix was incorrect.