> Lastly, I'm assuming that 'IS' and 'IS NOT' is functionally
> equivalent to the '=' and '<>' operators?
> Or is there some subtle difference
As long as neither the LHS or the RHS are null, then IS and IS NOT are the same
as == and <> respectively.
However, if you use the "comparison" opera
OK, I finally got around to upgrading the sqlite version to 3.25.1, and
testing this xBestIndex stuff out. Here is what I found:
These forms can still bypass the vtable's implementation of
constraints/indices. They are all negations:
NOT MATCH
NOT LIKE
NOT GLOB
NOT REGEXP
In each of these case
2 matches
Mail list logo