/ 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. Change foundin to "3.29.0"
  2. Change icomment to:

    Consider the following test case:

    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
    

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

    SELECT COUNT(*) FROM v0 WHERE v0.c0 || 0.1; -- 1
    SELECT (v0.c0 || 0.2) IS TRUE FROM v0; -- 0
    
  3. Change login to "mrigger"
  4. Change mimetype to "text/x-fossil-wiki"
  5. Change severity to "Critical"
  6. Change status to "Open"
  7. Change title to "DISTINCT malfunctions for VIEW"
  8. Change type to "Code_Defect"