Debian Codegraph @

mysql-test/suite/encryption/t/filekeys_goodtest.inc

raw
1 -- source include/have_innodb.inc
2 -- source filekeys_plugin.inc
3
4 create table t1(c1 bigint not null, b char(200)) engine=innodb encrypted=yes encryption_key_id=1;
5 show create table t1;
6 insert t1 values (12345, repeat('1234567890', 20));
7
8 alter table t1 encryption_key_id=2;
9 show create table t1;
10 --error ER_ILLEGAL_HA_CREATE_OPTION
11 alter table t1 encryption_key_id=3;
12 show warnings;
13 show create table t1;
14 alter table t1 encryption_key_id=33;
15 show create table t1;
16 alter table t1 encryption_key_id=4;
17 show create table t1;
18
19 drop table t1;