Debian Codegraph @

mysql-test/suite/encryption/r/innodb_encryption_is.result

raw
1 CREATE TABLE t1 (c VARCHAR(8)) ENGINE=InnoDB ENCRYPTED=YES ENCRYPTION_KEY_ID=1;
2 CREATE TABLE t2 (c VARCHAR(8)) ENGINE=InnoDB ENCRYPTED=YES ENCRYPTION_KEY_ID=2;
3 INSERT INTO t1 VALUES ('foobar');
4 INSERT INTO t2 VALUES ('foobar');
5 SELECT NAME, ENCRYPTION_SCHEME, MIN_KEY_VERSION, CURRENT_KEY_VERSION,
6 CURRENT_KEY_ID
7 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION
8 WHERE NAME LIKE '%t1' OR NAME LIKE '%t2';
9 NAME ENCRYPTION_SCHEME MIN_KEY_VERSION CURRENT_KEY_VERSION CURRENT_KEY_ID
10 test/t1 1 1 1 1
11 test/t2 1 1 1 2
12 DROP TABLE t1, t2;