Debian Codegraph @

mysql-test/suite/federated/r/federated_debug.result

raw
1 CREATE DATABASE federated;
2 CREATE DATABASE federated;
3 #
4 # Bug#47525: MySQL crashed (Federated)
5 #
6 # Switch to slave
7 CREATE TABLE t1(a INT);
8 INSERT INTO t1 VALUES (1);
9 # Switch to master
10 CREATE TABLE t1(a INT) ENGINE=FEDERATED
11 CONNECTION='mysql://[email protected]:SLAVE_PORT/test/t1';
12 SELECT * FROM t1;
13 a
14 1
15 # Start a asynchronous reload
16 mysqladmin: [Warning] Using a password on the command line interface can be insecure.
17 # Wait for tables to be closed
18 # Timeout in include/wait_show_condition.inc for = '0'
19 # show_statement : SHOW STATUS LIKE 'Open_tables'
20 # field : Value
21 # condition : = '0'
22 # max_run_time : 31
23 # Ensure that the server didn't crash
24 SELECT * FROM t1;
25 a
26 1
27 # Drop tables on master and slave
28 DROP TABLE t1;
29 DROP TABLE t1;
30 # Federated cleanup
31 DROP TABLE IF EXISTS federated.t1;
32 DROP DATABASE federated;
33 DROP TABLE IF EXISTS federated.t1;
34 DROP DATABASE federated;