Debian Codegraph @

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

raw
1 #
2 # This test attempts to show that table admin commands
3 # (OPTIMIZE / REPAIR / ANALYZE ...) on child table,
4 # do NOT cause conflicts on parent table operations.
5 # Contrary to what is said in MDEV-21577, which claimed
6 # that OPTIMIZE and REPAIR do take MDL locks on parent
7 # table.
8 #
9 # Should this test start failing due to a conflict
10 # (i.e. ER_LOCK_DEADLOCK), then it might be that we
11 # are missing additional keys for certification
12 # on the corresponding table admin command.
13
14 --source include/galera_cluster.inc
15
16 --let $table_admin_command = OPTIMIZE
17 --let $fk_constraint =
18 --source galera_ddl_fk_no_conflict.inc
19 --let $fk_constraint = ON UPDATE CASCADE
20 --source galera_ddl_fk_no_conflict.inc
21 --let $fk_constraint = ON DELETE CASCADE
22 --source galera_ddl_fk_no_conflict.inc
23 --let $fk_constraint = ON UPDATE CASCADE ON DELETE CASCADE
24 --source galera_ddl_fk_no_conflict.inc
25
26
27 --let $table_admin_command = REPAIR
28 --let $fk_constraint =
29 --source galera_ddl_fk_no_conflict.inc
30 --let $fk_constraint = ON UPDATE CASCADE
31 --source galera_ddl_fk_no_conflict.inc
32 --let $fk_constraint = ON DELETE CASCADE
33 --source galera_ddl_fk_no_conflict.inc
34 --let $fk_constraint = ON UPDATE CASCADE ON DELETE CASCADE
35 --source galera_ddl_fk_no_conflict.inc
36
37
38 --let $table_admin_command = CHECK
39 --let $fk_constraint =
40 --source galera_ddl_fk_no_conflict.inc
41 --let $fk_constraint = ON UPDATE CASCADE
42 --source galera_ddl_fk_no_conflict.inc
43 --let $fk_constraint = ON DELETE CASCADE
44 --source galera_ddl_fk_no_conflict.inc
45 --let $fk_constraint = ON UPDATE CASCADE ON DELETE CASCADE
46 --source galera_ddl_fk_no_conflict.inc
47
48
49 --let $table_admin_command = ANALYZE
50 --let $fk_constraint =
51 --source galera_ddl_fk_no_conflict.inc
52 --let $fk_constraint = ON UPDATE CASCADE
53 --source galera_ddl_fk_no_conflict.inc
54 --let $fk_constraint = ON DELETE CASCADE
55 --source galera_ddl_fk_no_conflict.inc
56 --let $fk_constraint = ON UPDATE CASCADE ON DELETE CASCADE
57 --source galera_ddl_fk_no_conflict.inc