Suddenly $dbh->{AutoCommit}=0 => "Transactions not supported bydatabase"

Hello

Some users of the Debian packages I create recently reported that after the
upgrade from MySQL 5.0.22 to 5.0.24 Perl scripts that try to explicitly set
$dbh->{AutoCommit} = 0;
die with the error message:
"Transactions not supported by database"

I could verify this but failed to trace down the exact reason due to the
confusing perl-xs code :) At least I figured out that
* ethereal tells me that the greeting and login request both set the
"client knows transactions" flag to 1
* the default for imp_dbh->has_transactions is TRUE in dbdimp.c of
DBD::mysql and
* that set variable setting triggers dbd_db_STORE_attrib() from dbdimp.c
which for some reason thinks that imp_dbh->has_transactions is FALSE.

Has anybody a clue if this really is a recent change or if it should work?

bye,

-christian-

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org