Debian Codegraph @

mysql-test/suite/federated/t/federated_debug.test

raw
1 --source include/have_debug.inc
2 --source suite/federated/include/federated.inc
3
4 --echo #
5 --echo # Bug#47525: MySQL crashed (Federated)
6 --echo #
7
8 connection slave;
9 --echo # Switch to slave
10 CREATE TABLE t1(a INT);
11 INSERT INTO t1 VALUES (1);
12
13 connection master;
14 --echo # Switch to master
15 --replace_result $SLAVE_MYPORT SLAVE_PORT
16 eval CREATE TABLE t1(a INT) ENGINE=FEDERATED
17 CONNECTION='mysql://[email protected]:$SLAVE_MYPORT/test/t1';
18
19 SELECT * FROM t1;
20
21 --echo # Start a asynchronous reload
22 --exec $MYSQLADMIN --no-defaults --default-character-set=latin1 -S $MASTER_MYSOCK -P $MASTER_MYPORT -u root --password= refresh 2>&1
23
24 --echo # Wait for tables to be closed
25 let $show_statement= SHOW STATUS LIKE 'Open_tables';
26 let $field= Value;
27 let $condition= = '0';
28 --source include/wait_show_condition.inc
29
30 --echo # Ensure that the server didn't crash
31 SELECT * FROM t1;
32 --echo # Drop tables on master and slave
33 DROP TABLE t1;
34 connection slave;
35 DROP TABLE t1;
36
37 connection default;
38 --echo # Federated cleanup
39 source suite/federated/include/federated_cleanup.inc;