Suddenly $dbh->{AutoCommit}=0 => 'Transactions not supported by database'

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/[email protected]