Debian Codegraph @

mysql-test/suite/perfschema/t/keyring_keys.test

raw
1
2 --let $KEYRING_DIR=keyring
3 --let $KEYRING_FILE_DATA_VALUE=$KEYRING_DIR/perf_schema
4 --let $KEYRING_FILE_LOCATION=$MYSQL_TMP_DIR/$KEYRING_FILE_DATA_VALUE
5
6 --echo # Restart server with keyring_file plugin
7 --error 0,1
8 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR $KEYRING_PLUGIN keyring_file.so
9 --let $restart_parameters=restart:--early-plugin-load=$KEYRING_PLUGIN --loose-keyring_file_data=$KEYRING_FILE_LOCATION
10 --source include/restart_mysqld.inc
11
12 CREATE DATABASE WL_11543_PERF_SCHEMA_KEYRING;
13 USE WL_11543_PERF_SCHEMA_KEYRING;
14
15 SELECT count(*) FROM performance_schema.keyring_keys;
16
17 CREATE TABLE t1(c1 INT, c2 char(20)) ENGINE = InnoDB ENCRYPTION="Y";
18 SELECT count(*) FROM performance_schema.keyring_keys;
19
20 ALTER INSTANCE ROTATE INNODB MASTER KEY;
21 SELECT count(*) FROM performance_schema.keyring_keys;
22
23 --replace_column 1 SOME_KEY_ID
24 SELECT * FROM performance_schema.keyring_keys;
25
26 --echo # cleanup
27 DROP TABLE t1;
28 UNINSTALL PLUGIN keyring_file;
29 DROP DATABASE WL_11543_PERF_SCHEMA_KEYRING;
30
31 --let $restart_parameters="restart:"
32 --source include/restart_mysqld.inc
33 --remove_file $KEYRING_FILE_LOCATION
34 --rmdir $MYSQL_TMP_DIR/$KEYRING_DIR