On 7/25/16, Richard Hipp <[email protected]> wrote: > On 7/25/16, Richard Hipp <[email protected]> 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 [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
