Debian Codegraph @

mysql-test/suite/encryption/t/innodb-page_encryption-32k.test

raw
1 --source include/no_valgrind_without_big.inc
2 --source include/not_embedded.inc
3 # Tests for setting innodb-page-size=32k;
4 --source include/have_innodb.inc
5 --source include/have_innodb_32k.inc
6 --source include/have_file_key_management_plugin.inc
7
8 create table innodb_normal(c1 bigint not null, b char(200)) engine=innodb;
9 create table innodb_compact(c1 bigint not null, b char(200)) engine=innodb row_format=compact encrypted=yes encryption_key_id=1;
10 --error ER_CANT_CREATE_TABLE
11 create table innodb_dynamic(c1 bigint not null, b char(200)) engine=innodb row_format=dynamic encrypted=yes encryption_key_id=3;
12 show warnings;
13 create table innodb_dynamic(c1 bigint not null, b char(200)) engine=innodb row_format=dynamic encrypted=yes encryption_key_id=33;
14 create table innodb_redundant(c1 bigint not null, b char(200)) engine=innodb row_format=redundant encrypted=yes encryption_key_id=4;
15
16 show create table innodb_compact;
17 show create table innodb_dynamic;
18 show create table innodb_redundant;
19
20 delimiter //;
21 create procedure innodb_insert_proc (repeat_count int)
22 begin
23 declare current_num int;
24 set current_num = 0;
25 while current_num < repeat_count do
26 insert into innodb_normal values(current_num, substring(MD5(RAND()), -150));
27 set current_num = current_num + 1;
28 end while;
29 end//
30 delimiter ;//
31 commit;
32
33 set autocommit=0;
34 call innodb_insert_proc(5000);
35 commit;
36 set autocommit=1;
37
38 insert into innodb_compact select * from innodb_normal;
39 insert into innodb_dynamic select * from innodb_normal;
40 insert into innodb_redundant select * from innodb_normal;
41
42 update innodb_compact set c1 = c1 + 1;
43 update innodb_dynamic set c1 = c1 + 1;
44 update innodb_redundant set c1 = c1 + 1;
45 select count(*) from innodb_compact where c1 < 1500000;
46 select count(*) from innodb_dynamic where c1 < 1500000;
47 select count(*) from innodb_redundant where c1 < 1500000;
48
49 --source include/restart_mysqld.inc
50
51 update innodb_compact set c1 = c1 + 1;
52 update innodb_dynamic set c1 = c1 + 1;
53 update innodb_redundant set c1 = c1 + 1;
54 select count(*) from innodb_compact where c1 < 1500000;
55 select count(*) from innodb_dynamic where c1 < 1500000;
56 select count(*) from innodb_redundant where c1 < 1500000;
57
58 alter table innodb_compact engine=innodb encrypted=DEFAULT encryption_key_id=DEFAULT;
59 show create table innodb_compact;
60 alter table innodb_dynamic engine=innodb encrypted=DEFAULT encryption_key_id=DEFAULT;
61 show create table innodb_dynamic;
62 alter table innodb_redundant engine=innodb encrypted=DEFAULT encryption_key_id=DEFAULT;
63 show create table innodb_redundant;
64
65 --source include/restart_mysqld.inc
66
67 show create table innodb_compact;
68 show create table innodb_dynamic;
69 show create table innodb_redundant;
70
71 update innodb_compact set c1 = c1 + 1;
72 update innodb_dynamic set c1 = c1 + 1;
73 update innodb_redundant set c1 = c1 + 1;
74 select count(*) from innodb_compact where c1 < 1500000;
75 select count(*) from innodb_dynamic where c1 < 1500000;
76 select count(*) from innodb_redundant where c1 < 1500000;
77
78 drop procedure innodb_insert_proc;
79 drop table innodb_normal;
80 drop table innodb_compact;
81 drop table innodb_dynamic;
82 drop table innodb_redundant;