Consider the following test case:

<pre>
CREATE TABLE t0(c0);
INSERT INTO t0(c0) VALUES (0.0), (0);
CREATE VIEW v0(c0) AS SELECT DISTINCT c0 FROM t0;
SELECT * FROM v0; -- expected: 0.0, 0, actual: 0.0
</pre>

Unexpectedly, only one of the zero values is fetched. This bug can indirectly be observed by the different behavior of two related queries:

<pre>
SELECT COUNT(*) FROM v0 WHERE v0.c0 || 0.1; -- 1
SELECT (v0.c0 || 0.2) IS TRUE FROM v0; -- 0
</pre>