All versions of SQLite from 2.8.8 and back contain a critical bug that can result in index corruption if you try to insert a large negative number (a number less than -2147483648) into an indexed numeric column. A fix for this specific problem has been checked into CVS. Extensive testing is currently underway to find similar problems in other parts of the code. Expect to see a 2.8.9 release soon.
For additional information, see:
http://www.sqlite.org/cvstrac/tktview?tn=552
-- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]