Debian Codegraph @

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

raw
1 # Setup
2 CREATE DATABASE federated;
3 CREATE DATABASE federated;
4 DROP TABLE IF EXISTS federated.t1;
5 CREATE TABLE federated.t1 (
6 a int
7 );
8 DROP TABLE IF EXISTS federated.t1;
9 CREATE TABLE federated.t1 (
10 a int
11 ) ENGINE="FEDERATED"
12 CONNECTION='mysql://[email protected]:SLAVE_PORT/federated/t1';
13 SELECT * FROM federated.t1;
14 a
15 SET @debug_master_save= @@GLOBAL.DEBUG;
16 # 1. Test wait_timeout with ER_NET_PACKETS_OUT_OF_ORDER error
17 SET @@GLOBAL.DEBUG='+d,bug33500956_simulate_out_of_order';
18 SELECT * FROM federated.t1;
19 a
20 # 2. Test wait_timeout with ER_NET_ERROR_ON_WRITE error
21 SET @@GLOBAL.DEBUG='+d,bug33500956_simulate_write_error';
22 SELECT * FROM federated.t1;
23 a
24 # 3. Test wait_timeout with ER_NET_WRITE_INTERRUPTED error
25 SET @@GLOBAL.DEBUG='+d,bug33500956_simulate_write_interrupted';
26 SELECT * FROM federated.t1;
27 a
28 # 4. Test wait_timeout with ER_NET_READ_ERROR error
29 SET @@GLOBAL.DEBUG='+d,bug33500956_simulate_read_error';
30 SELECT * FROM federated.t1;
31 a
32 # 5. Test wait_timeout with ER_NET_READ_INTERRUPTED error
33 SET @@GLOBAL.DEBUG='+d,bug33500956_simulate_read_interrupted';
34 SELECT * FROM federated.t1;
35 a
36 # Cleanup
37 SET @@GLOBAL.DEBUG= @debug_master_save;
38 DROP TABLE IF EXISTS federated.t1;
39 DROP DATABASE federated;
40 DROP TABLE IF EXISTS federated.t1;
41 DROP DATABASE federated;