Spracherkennung für: .test vermutete Sprache: SQL {SQL[119] ABAP[80] Lisp[35]} [Methode: maximale Elemente, drei Dimensionen]
--source include/galera_cluster.inc
--source include/have_innodb.inc
#
# Test ALTER TABLE FORCE, a 5.6.3 feature that simply rebuilds the table
#
CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
INSERT INTO t1 VALUES (1);
ALTER TABLE t1 FORCE;
--connection node_2
SELECT ENGINE = 'InnoDB' FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
SELECT COUNT(*) = 1 FROM t1;
DROP TABLE t1;
[Dauer der Verarbeitung: 0.7 Sekunden]
