Overview
Artifact ID: | 183f1b7c5a12330a3d12dc54616cd162934a4fb3404e81990ef02173210f72d4 |
---|---|
Ticket: | c4130c33be081b2e75e8eb12b623ff6b67752ed0
DISTINCT malfunctions for VIEW |
User & Date: | mrigger 2019-09-10 19:07:26 |
Changes
- foundin changed to: "3.29.0"
- icomment:
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>
- login: "mrigger"
- mimetype: "text/x-fossil-wiki"
- severity changed to: "Critical"
- status changed to: "Open"
- title changed to: "DISTINCT malfunctions for VIEW"
- type changed to: "Code_Defect"