Mixed table types in transactions?

[Chris Nolan]

Hi all,

Here's one of those damned annoying "what if" questions for everyone.

If I have a transaction that performs INSERTs or UPDATEs on a bunch of
tables, some InnoDB and some MyISAM, and after performing a bunch of
modifications on each I issue a ROLLBACK, does the fact that a MyISAM
table is involved in the process cause any problems with the ROLLBACK at
all?

Any definitive answer either way would be appreciated, as I have just
inheritted the codebase from hell to either maintain or redo parts of
(redo would be appreciated, so all bagging of the above approach is
invited!)

Regards,

Chris

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw