Re: Innodb transactions and drop table

2003-03-27 Thread Paul DuBois
At 13:22 +0100 3/27/03, Stefan Hinz wrote: Christian, It looks like 'drop table' implicitely does a 'commit', at least when issued by the mysql commandline utility with mysql 3.23.51. This happens even if it was a temporary heap table as typically used to emulate subselects. I think this sho

Re: Innodb transactions and drop table

2003-03-27 Thread Stefan Hinz
Christian, > It looks like 'drop table' implicitely does a 'commit', at least when > issued by the mysql commandline utility with mysql 3.23.51. This > happens even if it was a temporary heap table as typically used to > emulate subselects. > I think this should be documented. (Or better yet, n

Re: Innodb transactions and drop table

2003-03-27 Thread Heikki Tuuri
Christian, - Original Message - From: "Christian Jaeger" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Thursday, March 27, 2003 1:42 PM Subject: Innodb transactions and drop table > Hello > > It looks like 'drop table' implicitely does a 'commit', at least when > issued by