System.Data.SQLite

If the left join clause, if other table is referenced, query returns completely wrong data set. Its difficult to explain in words, so let me write the sql which reproduces the problem:

-- create table with an index
create table t (n int, m int, s varchar);
create index tx on t(m);

--add some data to table
WITH RECURSIVE
  cnt(x) AS (
     SELECT 1
     UNION ALL
     SELECT x+1 FROM cnt 
     LIMIT 100000
  )
insert into t(n, s) SELECT x, cast(x as text) FROM cnt;
update t set m = n where (n % 1000)=0;

--problematic query
select count(*)
from t t1
left join t t2 on (t1.m = t2.n) and (t1.m is not null);
--displays 100 which is incorrect.

--Lets try the same query after dropping the index
drop index tx;

select count(*)
from t t1
left join t t2 on (t1.m = t2.n) and (t1.m is not null);
--displays 100,000 which is correct.

Incorrect query results return in left join when join clause references other table