mysql-test/main/plugin_innodb.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

--source include/not_embedded.inc
--source include/have_example_plugin.inc
--source include/have_innodb.inc

if (!`select count(*) from information_schema.plugins
         where plugin_name = 'innodb' and plugin_status = 'active' and
              plugin_library is null`) {
  skip Need compiled-in InnoDB;
}


install plugin example soname 'ha_example';
create table t1(a int) engine=example;
drop table t1;

alter table mysql.plugin engine=innodb;
--source include/shutdown_mysqld.inc

--exec $MYSQLD_CMD  --innodb --help --verbose > $MYSQL_TMP_DIR/plugin_innodb.txt 2> $MYSQL_TMP_DIR/plugin_innodb.err
perl;
  open(F, '<', "$ENV{MYSQL_TMP_DIR}/plugin_innodb.txt") or die;
  while (<F>) {
    print if /EXAMPLE/;
  }
EOF

--source include/start_mysqld.inc

create table t1(a int) engine=example;
select * from t1;
drop table t1;

alter table mysql.plugin engine=aria;
uninstall plugin example;