in reply to Need help in Perl DBI (SQLite) execute behaviour
DBI documents the return value from ->do and ->execute.
->do returns the number of affected rows, as does ->execute, but only if the number is actially known to the database driver.
I wouldn't place too much importance on the return value except its truthyness.
In Section
Seekers of Perl Wisdom