Debian Codegraph @

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

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3
4 #
5 # Test ALTER TABLE FORCE, a 5.6.3 feature that simply rebuilds the table
6 #
7
8 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
9 INSERT INTO t1 VALUES (1);
10
11 ALTER TABLE t1 FORCE;
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;