mysql-test/suite/federated/error_on_close-8313.test


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38

#
# MDEV-8313 Got an error writing communication packets
#
source include/federated.inc;

enable_connect_log;

connection slave;
create table t1 (foo int, bar int);

connection master;

--replace_result $SLAVE_MYSOCK SLAVE_MYSOCK
eval create server 's1' foreign data wrapper 'mysql' options
  (HOST 'localhost',
  DATABASE 'test',
  USER 'root',
  PASSWORD '',
  SOCKET '$SLAVE_MYSOCK');


eval create table t1 (foo integer, bar integer) engine=federated
  connection='s1';

select * from t1;

connection slave;
source include/restart_mysqld.inc;

connection master;
drop table t1;
drop server s1;

connection slave;
drop table t1;

source include/federated_cleanup.inc;