http://www.sqlite.org/cvstrac/tktview?tn=3202
There seems to be some deep-seated issue with floating-point arithmetic related to the recent rebuild with FTS3. A simple test case: sqlite> select 6.6989+22.912345; sqlite> select 6.5989+22.912345; 29.511245 I tried this on 3.5.9-3 and on 3.5.9-2, and it worked under -2. I downloaded the patches for each and diff'd them, and the only non-comment difference was this: -+DEB_OPT_FLAG := -O2 -fno-strict-aliasing -DSQLITE_ENABLE_COLUMN_METADATA ++DEB_OPT_FLAG := -O2 -fno-strict-aliasing -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_ENABLE_FTS3 This leads me to believe that the bug is related to FTS3. -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]