in reply to Re: SQLite select not returning all rows
in thread SQLite select not returning all rows

and the last piece for this particular puzzle is a missing commit before the disconnect (thanks erix) in DESTROY:

$dbh->do ("DELETE FROM managers WHERE id = '$self->{myId}'"); $dbh->commit (); $dbh->disconnect ();

DWIM is Perl's answer to Gödel