release/src/router/mysql/mysql-test/suite/federated/federated_plugin.test

   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;