On 2/8/16, Richard Hipp <drh at sqlite.org> wrote: > On 2/8/16, Poor Yorick <org.sqlite at pooryorick.com> wrote: >> The following query produces a third phantom record on my system: > > Running "PRAGMA automatic_index=OFF;" might alleviate the symptoms > your are experiencing, until we can get a proper fix published. >
The bug appears to be quite a bit more serious. A proposed fix has been checked into trunk. Please try out the trunk to see if that works better for you. We will continue to analyze the problem and write tests in the meantime. The latest "snapshot" at https://www.sqlite.org/download.html contains the proposed fix. -- D. Richard Hipp drh at sqlite.org