Like I said, I'm running 3.6.20 now. Same problem.
> From: d...@hwaci.com > To: sqlite-users@sqlite.org > Date: Sat, 7 Nov 2009 11:04:16 -0500 > Subject: Re: [sqlite] 3.6.20 NATURAL self-join still not fixed > > > On Nov 7, 2009, at 10:54 AM, Simon Davies wrote: > > > > I used 10,000 entries, and it returned in a few seconds... (using > > 3.6.19) > > > > But there does appear to be a problem: > > sqlite> select count(*) from test1 natural join test2; > > 10 > > sqlite> select count(*) from test1 natural join test1; > > 100 > > > Try that again using 3.6.20. > > That problem was fixed by http://www.sqlite.org/src/vinfo/ > 6fe63711754on 2009-10-19. > > D. Richard Hipp > d...@hwaci.com > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _________________________________________________________________ Nya Windows 7 gör allt lite enklare. Hitta en dator som passar dig! http://windows.microsoft.com/shop _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users