2 messages in com.mysql.lists.perlPossible error in t/50commit.t?
FromSent OnAttachments
Scotty Allen26 Jul 2003 15:30 
Rudy Lippan26 Jul 2003 18:05 
Subject:Possible error in t/50commit.t?
From:Scotty Allen (sco@scottyallen.com)
Date:07/26/2003 03:30:42 PM
List:com.mysql.lists.perl

Hi all,

I've been troubleshooting why transactions aren't working as I expect on mysql 4.0.14 and DBD-mysql 2.9002, and while I don't think it has anything to do with it, I found that t/50commit.t was skipping testing transactions, even though transactions are supported.

If you look at line 145-149 of t/mysql.dbtest:

if ($row->{'Variable_name'} eq 'have_innobase' && $row->{'Value'} eq 'YES') { $have_transactions = "innobase"; last; }

It references have_innobase, but if I do a "show variables" in mysql, there is a have_innodb instead.

Am I missing something here, or is this genuinely a difference between mysql 3.2 and 4.0 that needs to be addressed in DBD::mysql?

-Scotty