Using SQLite 3.6.20 (SQLITE_ENABLE_STAT2=1).
PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; CREATE TABLE Test ( TestID INTEGER PRIMARY KEY, T1 INTEGER NOT NULL, T2 INTEGER NOT NULL, T3 INTEGER NOT NULL, T4 INTEGER NOT NULL, T5 INTEGER NOT NULL, T6 INTEGER NOT NULL, T7 INTEGER NOT NULL, DT DATE NOT NULL, T8 INTEGER NOT NULL, T9 INTEGER NOT NULL, T10 INTEGER NOT NULL, T11 INTEGER NOT NULL, UNIQUE (T2, T1) ); -- Fill with random data! COMMIT TRANSACTION; SELECT COUNT(*) FROM Test; -- Blistering fast! SELECT COUNT(*) FROM Test NATURAL JOIN Test; -- "Never" terminates I have over 50,000 entries... Thanks. > From: danielk1...@gmail.com > To: sqlite-users@sqlite.org > Date: Sat, 7 Nov 2009 11:36:52 +0700 > Subject: Re: [sqlite] 3.6.20 NATURAL self-join still not fixed > > > On Nov 7, 2009, at 5:25 AM, Kristoffer Danielsson wrote: > > > > > http://www.sqlite.org/src/info/b73fb0bd64 > > > > > > > > Just tried this statement in SQLite 3.6.20: > > > > SELECT COUNT(*) FROM X NATURAL JOIN X; <--- "never" terminates > > What is the schema and contents of table X that causes this? > > Dan. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _________________________________________________________________ Nya Windows 7 - Hitta en dator som passar dig! Mer information. http://windows.microsoft.com/shop _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
