SQLite

This:

CREATE TABLE t1(x, z);
INSERT INTO t1 VALUES('aaa', 4.0);
INSERT INTO t1 VALUES('aaa', 4.0);
CREATE VIEW vvv AS
  SELECT * FROM t1
    UNION ALL
  SELECT 0, 0 WHERE 0;

SELECT (
  SELECT sum(z) FROM vvv WHERE x='aaa'
) FROM sqlite_master;

currently returns two rows containing the single value 4.0 (instead of 8.0). The problem is that when SQLite creates an automatic index on view "vvv", it incorrectly discards duplicate rows - making the sum() expression equivalent to just 4.0 instead of (4.0 + 4.0).

Problem introduced here:

http://www.sqlite.org/src/info/020b8b106fc8f840

First appeared in release 3.8.11.

Fixed by [bfea226d].