Fixed the truncate optimization so that sqlite3_changes() and
sqlite3_total_changes() interfaces and the count_changes pragma
return the correct values.
The test in question is checking rowcount after executing "DELETE FROM test", which would trigger the truncate optimisation code path.
I can't reproduce this problem locally. What version of sqlite are you running there?
Looking at the sqlite release history (http:// sqlite. org/changes. html), one of the fixes in 3.6.5 sounds relevant:
Fixed the truncate optimization so that sqlite3_changes() and total_changes( ) interfaces and the count_changes pragma
sqlite3_
return the correct values.
The test in question is checking rowcount after executing "DELETE FROM test", which would trigger the truncate optimisation code path.