/ Ticket Change Details
Login
Overview

Artifact ID: 183f1b7c5a12330a3d12dc54616cd162934a4fb3404e81990ef02173210f72d4
Ticket: c4130c33be081b2e75e8eb12b623ff6b67752ed0
DISTINCT malfunctions for VIEW
User & Date: mrigger 2019-09-10 19:07:26
Changes

  1. foundin changed to: "3.29.0"
  2. 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>
    
  3. login: "mrigger"
  4. mimetype: "text/x-fossil-wiki"
  5. severity changed to: "Critical"
  6. status changed to: "Open"
  7. title changed to: "DISTINCT malfunctions for VIEW"
  8. type changed to: "Code_Defect"