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.

dan added on 2015-10-24 20:34:34:

Fixed by [bfea226d].

This page was generated in about
0.004s by
Fossil 2.8 [246f249e5a] 2019-01-21 20:07:41