On 14 Feb 2018, at 7:50am, Dominique Devienne <ddevie...@gmail.com> wrote:
> Thanks. That's interesting. But then, why use it in this context?
> Why DRH wants to purposely bypass the index in this case?
> How is that relevant to testing tuple / row-values comparisons? --DD
In the original example, column a is the PRIMARY KEY. SQLite automatically
makes an index for the PRIMARY KEY. So SQLIte might use that index if there's
a WHERE clause on a. In the case of the ticket DRH wants to avoid this, since
the bug shows up only when an index is not used.
sqlite-users mailing list