Debian Codegraph @

mysql-test/suite/galera/t/galera_alter_engine_innodb.test

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3
4 #
5 # Test ALTER ENGINE from InnoDB to InnoDB
6 #
7
8 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
9 INSERT INTO t1 VALUES (1);
10
11 ALTER TABLE t1 ENGINE=InnoDB;
12
13 --connection node_2
14 SELECT ENGINE = 'InnoDB' FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
15 SELECT COUNT(*) = 1 FROM t1;
16
17 DROP TABLE t1;