On 7/25/16, Richard Hipp <d...@sqlite.org> wrote: > On 7/25/16, Richard Hipp <d...@sqlite.org> wrote: >> If it is a bug, we'll fix it. > > It is a bug. The ticket is here: > https://www.sqlite.org/src/tktview/a0bac8b3c3
The bug is now fixed on trunk. (See https://www.sqlite.org/src/info/b819bace9c2a0b01 for the fix.) It turns out that the index on a PK is not required to reproduce the problem. All that is required is an indexed min() query with a range constraint on the column that requires an affinity transformation. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
