From: Date: June 13 2007 11:05am
Subject: CREATE INDEX is not committed?
List-Archive: http://lists.mysql.com/internals/34726
Message-Id: <20070613090532.GB4957@localhost.localdomain>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

I wonder if the following is correct behavior.  This is from
innodb.test:

create table t1 (i int, j int ) ENGINE=innodb;
insert into t1 values (1,2);
select * from t1 where i=1 and j=2;
create index ax1 on t1 (i,j);
select * from t1 where i=1 and j=2;

If I set a breakpoint on innobase_commit, it gets invoked for the
INSERT, but not for the CREATE TABLE or CREATE INDEX statements.

I have the impression that this behavior has been changed in the past
few weeks.

The documentation of CREATE INDEX doesn't mention transactions.  I
suppose that InnoDB is not the only transactional engine where data
dictionary operations are not truly transactional.  Is it OK for the
engine to commit the transaction when it feels like that, or should
MySQL instead invoke commit?

	Marko