Debian Codegraph @

mysql-test/suite/encryption/t/innodb_encryption_is.test

raw
1 -- source include/have_innodb.inc
2 -- source include/have_file_key_management_plugin.inc
3
4 CREATE TABLE t1 (c VARCHAR(8)) ENGINE=InnoDB ENCRYPTED=YES ENCRYPTION_KEY_ID=1;
5 CREATE TABLE t2 (c VARCHAR(8)) ENGINE=InnoDB ENCRYPTED=YES ENCRYPTION_KEY_ID=2;
6 INSERT INTO t1 VALUES ('foobar');
7 INSERT INTO t2 VALUES ('foobar');
8
9 #
10 # MDEV-9640: Add used key_id to INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION
11 #
12 --sorted_result
13 SELECT NAME, ENCRYPTION_SCHEME, MIN_KEY_VERSION, CURRENT_KEY_VERSION,
14 CURRENT_KEY_ID
15 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION
16 WHERE NAME LIKE '%t1' OR NAME LIKE '%t2';
17
18 DROP TABLE t1, t2;