mirror of
https://github.com/MariaDB/server.git
synced 2025-02-23 05:43:08 +01:00
c75bee9478
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>
17 lines
500 B
Text
17 lines
500 B
Text
connection node_2;
|
|
connection node_1;
|
|
CREATE TABLE t1(a int not null primary key) engine=innodb;
|
|
REPAIR TABLE t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 repair note The storage engine for the table doesn't support repair
|
|
CREATE VIEW v1 AS SELECT a FROM t1;
|
|
REPAIR VIEW v1;
|
|
Table Op Msg_type Msg_text
|
|
test.v1 repair status OK
|
|
DROP VIEW v1;
|
|
DROP TABLE t1;
|
|
CREATE VIEW v1 AS SELECT table_name FROM information_schema.tables;
|
|
REPAIR VIEW v1;
|
|
Table Op Msg_type Msg_text
|
|
test.v1 repair status OK
|
|
DROP VIEW v1;
|