On 2016-02-08 19:15, Richard Hipp wrote: > 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.
My working code has already morphed into something that isn't triggering the bug, but it's gratifying to see a proposed fix so quickly, as I'm likely to hit it again during this project. -- Yorick