Innodb transactions and drop table

2003-03-27 Thread Christian Jaeger
Hello 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, not do a

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

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, not

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