Debian Codegraph @

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

raw
1 create table t1(c1 bigint not null, b char(200)) engine=innodb encrypted=yes encryption_key_id=1;
2 show create table t1;
3 Table Create Table
4 t1 CREATE TABLE `t1` (
5 `c1` bigint(20) NOT NULL,
6 `b` char(200) DEFAULT NULL
7 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci `encrypted`=yes `encryption_key_id`=1
8 insert t1 values (12345, repeat('1234567890', 20));
9 alter table t1 encryption_key_id=2;
10 show create table t1;
11 Table Create Table
12 t1 CREATE TABLE `t1` (
13 `c1` bigint(20) NOT NULL,
14 `b` char(200) DEFAULT NULL
15 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci `encrypted`=yes `encryption_key_id`=2
16 drop table t1;
17 # Test checks if opening an too large secret does not crash the server.