diff options
| author | Jan Lindström <jan.lindstrom@mariadb.com> | 2020-11-17 08:36:38 +0200 |
|---|---|---|
| committer | Jan Lindström <jan.lindstrom@mariadb.com> | 2020-11-17 08:36:38 +0200 |
| commit | 0bde52e6a881cdc193e421cc789885fc078e640b (patch) | |
| tree | 99ab8768459e54c2ecbaa1f1feeb5e0faf05ab2d | |
| parent | 9b30212f15e280bef6d2a9be212c3295e912b959 (diff) | |
| download | mariadb-git-0bde52e6a881cdc193e421cc789885fc078e640b.tar.gz | |
MDEV-24164 : Galera test failure on galera_fk_cascade_delete
Add wait_conditions.
| -rw-r--r-- | mysql-test/suite/galera/t/galera_fk_cascade_delete.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/suite/galera/t/galera_fk_cascade_delete.test b/mysql-test/suite/galera/t/galera_fk_cascade_delete.test index 6f0de0a1f4a..a3e0dbcf36f 100644 --- a/mysql-test/suite/galera/t/galera_fk_cascade_delete.test +++ b/mysql-test/suite/galera/t/galera_fk_cascade_delete.test @@ -40,11 +40,19 @@ set wsrep_sync_wait=0; --let $wait_condition = SELECT COUNT(*) = 2 FROM child; --source include/wait_condition.inc +--let $wait_condition = SELECT COUNT(*) = 2 FROM parent; +--source include/wait_condition.inc +--let $wait_condition = SELECT COUNT(*) = 2 FROM grandparent; +--source include/wait_condition.inc DELETE FROM grandparent WHERE id = 1; --connection node_1 --let $wait_condition = SELECT COUNT(*) = 1 FROM child; --source include/wait_condition.inc +--let $wait_condition = SELECT COUNT(*) = 1 FROM parent; +--source include/wait_condition.inc +--let $wait_condition = SELECT COUNT(*) = 1 FROM grandparent; +--source include/wait_condition.inc SELECT COUNT(*), COUNT(*) = 0 FROM parent WHERE grandparent_id = 1; SELECT COUNT(*), COUNT(*) = 0 FROM child WHERE parent_id = 1; |