mariadb/mysql-test/suite/galera/t/galera_repair_view.test
Daniele Sciascia c75bee9478 MDEV-25538 Crash on REPAIR VIEW that was created from IS table
Remove calls to wsrep_append_fk_parent_table() during REPAIR/OPTIMIZE
TABLE processing. It turns out that REPAIR or OPTIMIZE commands on
table t, do not acquire MDL locks on parent tables of t (as shown in
the included test).  Thus making wsrep_append_fk_parent_table()
unnecessary for OPTIMIZE and REPAIR.
This also fixes MDEV-24446 and reenables test galera.mysql-wsrep#198.

Reviewed-by: Jan Lindström <jan.lindstrom@mariadb.com>
2022-01-19 15:32:42 +02:00

12 lines
293 B
Text

--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;