mysql-test/suite/galera/t/MW-328B.test


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36

#
# MW-328 Fix unnecessary/silent BF aborts
# 

#
# Make sure an unrelated SELECT following a BF-aborted query never 
# gets the deadlock error
#

--source include/galera_cluster.inc
--source include/big_test.inc
--source suite/galera/t/MW-328-header.inc

--connection node_2
--let $count = 100

SET SESSION wsrep_retry_autocommit = 0;

--disable_query_log

while ($count)
{
  --error 0,1213
  INSERT IGNORE INTO t2 SELECT f2 FROM t1;

  --disable_result_log
  --error 0
  SELECT 1 FROM DUAL;
  --enable_result_log

  --dec $count
}

--enable_query_log

--source suite/galera/t/MW-328-footer.inc