summaryrefslogtreecommitdiff
path: root/mysql-test/suite/galera/t/galera_repair_view.test
blob: 0010d90c7ece831e7d2f91ffb217f3ed405b660a (plain)
1
2
3
4
5
6
7
8
9
10
11
12
--source include/galera_cluster.inc

CREATE TABLE t1(a int not null primary key) engine=innodb;
REPAIR TABLE t1;
CREATE VIEW v1 AS SELECT a FROM t1;
REPAIR VIEW v1;
DROP VIEW v1;
DROP TABLE t1;

CREATE VIEW v1 AS SELECT table_name FROM information_schema.tables;
REPAIR VIEW v1;
DROP VIEW v1;