Debian Codegraph @

mysql-test/suite/federated/t/federated_plugin.test

raw
1 --source include/have_federated_plugin.inc
2
3 # Uninstall will not uninstall if ps has been used
4 --disable_ps_protocol
5
6 connect (master,localhost,root,,test,$MASTER_MYPORT,);
7 connect (slave,localhost,root,,test,$SLAVE_MYPORT,);
8
9 connection master;
10 CREATE TABLE t2(a int);
11
12 connection slave;
13 CREATE TABLE t1(a int) ENGINE=FEDERATED
14 CONNECTION='mysql://root@localhost:$MASTER_MYPORT/test/t2';
15 DROP TABLE t1;
16
17 --replace_result $FEDERATED_PLUGIN FEDERATED_PLUGIN
18 eval INSTALL PLUGIN federated SONAME '$FEDERATED_PLUGIN';
19 --replace_result $FEDERATED_PLUGIN FEDERATED_PLUGIN
20 --error ER_UDF_EXISTS
21 eval INSTALL PLUGIN FEDERATED SONAME '$FEDERATED_PLUGIN';
22
23 UNINSTALL PLUGIN federated;
24
25 --replace_result $FEDERATED_PLUGIN FEDERATED_PLUGIN
26 eval INSTALL PLUGIN federated SONAME '$FEDERATED_PLUGIN';
27
28 CREATE TABLE t1(a int) ENGINE=FEDERATED
29 CONNECTION='mysql://root@localhost:$MASTER_MYPORT/test/t2';
30 DROP TABLE t1;
31
32 UNINSTALL PLUGIN federated;
33 --error ER_SP_DOES_NOT_EXIST
34 UNINSTALL PLUGIN federated;
35
36 connection master;
37 DROP TABLE t2;