Comment 1 for bug 427584

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
    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.