Re: DBI bug, InnoDB bug, MySQL bug, or I'm just plain missing something.

2001-08-16 Thread mickalo
On Thu, 16 Aug 2001 16:43:22 -0700 (PDT), "Eric J. Schwertfeger" <[EMAIL PROTECTED]> wrote: >>The interesting part is, if I run the program with autocommit on, it >>works fine. Unfortunately, transactions are essential. I found that the >>program works if I turn autocommit on but wrap the criti

DBI bug, InnoDB bug, MySQL bug, or I'm just plain missing something.

2001-08-16 Thread Eric J. Schwertfeger
I've got a part of a complex system that isn't behaving as expected. I've got one perl program running with autocommit off that creates entries in a table and commits the changes. At some point, the rows have their state field changed from 'active' to 'closed', and these changes are then commit