http://www.perlmonks.org?node_id=531402

antitrust has asked for the wisdom of the Perl Monks concerning the following question:

AutoCommit flag resets on my database handle, every time I call "connect_cached". Is this a known "feature" or am I missing something?

The problem is that I "begin_work" a transaction and do some queries. If now I call "connect_cached", it returns me the same handle (at least dbh with the same mysql_thread_id), but AutoCommit flag on that handle is set to 1! How is that possible?