USE test;
DROP TABLE IF EXISTS T1;
CREATE TABLE T1 (id integer);
SET autocommit=1;
BEGIN;
CREATE INDEX foo_t1 on T1 (id);
SELECT (@@server_id) INTO @a;
SELECT IF(@a <> @TMASTER_ID,'OK (slave)','FAIL (master)') AS result;
result
OK (slave)
DROP TABLE T1;
COMMIT;