--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;