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. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users