Debian Codegraph @

mysql-test/suite/federated/federated_bug_585688.result

raw
1 connect master,127.0.0.1,root,,test,$MASTER_MYPORT,;
2 connect slave,127.0.0.1,root,,test,$SLAVE_MYPORT,;
3 connection master;
4 CREATE DATABASE federated;
5 connection slave;
6 CREATE DATABASE federated;
7 #
8 # Bug #585688: maridb crashes in federatedx code
9 #
10 connection slave;
11 CREATE TABLE federated.t1(a TEXT);
12 INSERT INTO federated.t1 VALUES('abc'), ('gh'), ('f'), ('ijk'), ('de');
13 connect conn_1,127.0.0.1,root,,,$MASTER_MYPORT;
14 connection master;
15 flush tables;
16 connection conn_1;
17 CREATE TABLE federated.t1(a TEXT) ENGINE=FEDERATED
18 CONNECTION='mysql://[email protected]:SLAVE_PORT/federated/t1';
19 disconnect conn_1;
20 connection master;
21 flush tables;
22 connect conn_2,127.0.0.1,root,,,$MASTER_MYPORT;
23 connect conn_3,127.0.0.1,root,,,$MASTER_MYPORT;
24 connection conn_2;
25 describe federated.t1;
26 Field Type Null Key Default Extra
27 a text YES NULL
28 connection conn_3;
29 show table status from federated;
30 Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment Max_index_length Temporary
31 t1 FEDERATED 10 Dynamic 5 20 X X X X X X X X utf8mb4_uca1400_ai_ci NULL 0 N
32 disconnect conn_2;
33 connect conn_4,127.0.0.1,root,,,$MASTER_MYPORT;
34 connection conn_4;
35 show table status from federated;
36 Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment Max_index_length Temporary
37 t1 FEDERATED 10 Dynamic 5 20 X X X X X X X X utf8mb4_uca1400_ai_ci NULL 0 N
38 disconnect conn_3;
39 disconnect conn_4;
40 connection master;
41 DROP TABLE federated.t1;
42 connection slave;
43 DROP TABLE federated.t1;
44 connection default;
45 connection master;
46 DROP TABLE IF EXISTS federated.t1;
47 DROP DATABASE IF EXISTS federated;
48 connection slave;
49 DROP TABLE IF EXISTS federated.t1;
50 DROP DATABASE IF EXISTS federated;