Debian Codegraph @

mysql-test/suite/federated/federated_debug.test

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