Re: transactions and create table (was Questions about MySQL implementation)

2003-12-18 Thread Heikki Tuuri
quot; <[EMAIL PROTECTED]> Vastaanottaja: <[EMAIL PROTECTED]> Kopio: <[EMAIL PROTECTED]> Lähetetty: Thursday, December 18, 2003 5:02 PM Aihe: transactions and create table (was Questions about MySQL implementation) > What is the official word on doing a CREATE TABLE inside a transaction? Can

transactions and create table (was Questions about MySQL implementation)

2003-12-18 Thread Bill Easton
What is the official word on doing a CREATE TABLE inside a transaction? Can I do one without causing the transaction to commit? By experiment, it appears that 4.0.14 allows this, although, even if the CREATE TABLE is for an InnoDB table, a ROLLBACK doesn't remove the created table. It appears th