/usr/lib/mysql-testsuite/t/archive_plugin.test is in percona-server-test-5.6 5.6.22-rel71.0-0ubuntu4.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
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 | --source include/not_windows.inc
--source include/have_archive_plugin.inc
# When running in parallel we get
# Warning 1620 Plugin is busy and will be uninstalled on shutdown
--source include/not_parallel.inc
CREATE TABLE t1(a int) ENGINE=ARCHIVE;
DROP TABLE t1;
INSTALL PLUGIN archive SONAME 'ha_archive.so';
--error 1125
INSTALL PLUGIN ARCHIVE SONAME 'ha_archive.so';
UNINSTALL PLUGIN archive;
INSTALL PLUGIN archive SONAME 'ha_archive.so';
CREATE TABLE t1(a int) ENGINE=ARCHIVE;
DROP TABLE t1;
# This dummy statement is required for --ps-protocol mode.
# The thing is that last prepared statement is "cached" in mysqltest.cc
# (unless "reconnect" is enabled, and that's not the case here).
# This statement forces mysqltest.cc to close prepared "DROP TABLE t1".
# Otherwise, the plugin can not be uninstalled because there is an active
# prepared statement using it.
SELECT 1;
UNINSTALL PLUGIN archive;
--error ER_SP_DOES_NOT_EXIST
UNINSTALL PLUGIN archive;
|