Debian Codegraph @

mysql-test/suite/federated/federated_bug_585688.test

raw
1 source include/federated.inc;
2
3 --echo #
4 --echo # Bug #585688: maridb crashes in federatedx code
5 --echo #
6 connection slave;
7 CREATE TABLE federated.t1(a TEXT);
8 INSERT INTO federated.t1 VALUES('abc'), ('gh'), ('f'), ('ijk'), ('de');
9
10 connect (conn_1,127.0.0.1,root,,,$MASTER_MYPORT);
11
12 connection master;
13 flush tables;
14
15 connection conn_1;
16 --replace_result $SLAVE_MYPORT SLAVE_PORT
17 eval CREATE TABLE federated.t1(a TEXT) ENGINE=FEDERATED
18 CONNECTION='mysql://[email protected]:$SLAVE_MYPORT/federated/t1';
19 disconnect conn_1;
20
21 connection master;
22 flush tables;
23
24 connect (conn_2,127.0.0.1,root,,,$MASTER_MYPORT);
25 connect (conn_3,127.0.0.1,root,,,$MASTER_MYPORT);
26
27 connection conn_2;
28 describe federated.t1;
29
30 connection conn_3;
31 --replace_column 7 X 8 X 9 X 10 X 11 X 12 X 13 X 14 X
32 show table status from federated;
33
34 disconnect conn_2;
35 connect (conn_4,127.0.0.1,root,,,$MASTER_MYPORT);
36
37 connection conn_4;
38 --replace_column 7 X 8 X 9 X 10 X 11 X 12 X 13 X 14 X
39 show table status from federated;
40
41 disconnect conn_3;
42 disconnect conn_4;
43
44 connection master;
45 DROP TABLE federated.t1;
46
47 connection slave;
48 DROP TABLE federated.t1;
49
50 connection default;
51
52 source include/federated_cleanup.inc;
53