I don't use MySQL but as I understand it not all versions of MySQL have transaction support. I think one of the commencial distributions does.
Martin -- Martin J. Evans Easysoft Ltd, UK Development On 13-Dec-2002 Jeff Urlwin wrote: > >> >> Jeff >> >> Same env as in previous post. >> >> t\05meth.........1..6 >> ok 1 >> ok 2 >> DBD::ODBC::db rollback failed: [MySQL][ODBC 3.51 Driver]Warning: >> Some non-transactional changed tab >> les couldn't be rolled back (SQL-HY000)(DBD: db_rollback/SQLTransact >> err=-1) at t\05meth.t line 34. >> ok 3 >> ok 4 >> ok 5 >> ok 6 >> calling finish >> resetting attributes >> disconnecting >> disconnected >> ok >> >> I assume this rollback error is due to me using MySQL 3.23.51, and is >> thus expected and harmless. Correct? > > I don't normally test with MySQL, I wouldn't call it expected, but it > seems that MySQL doesn't handle the same level of committing that the > tests are looking for. So, as long as you understand that in your > application, you'll be OK. > > Jeff
