Debian Codegraph @

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

raw
1 CREATE TABLE t1 (id INT NOT NULL PRIMARY KEY, a VARCHAR(255)) ENGINE=InnoDB encrypted=yes;
2 CREATE TABLE t2 (id INT NOT NULL PRIMARY KEY, a VARCHAR(255)) ENGINE=InnoDB;
3 CREATE TABLE t3 (id INT, a VARCHAR(255)) ENGINE=InnoDB encrypted=yes;
4 CREATE TABLE t4 (id INT, a VARCHAR(255)) engine=InnoDB;
5 CREATE TABLE t5 (id INT NOT NULL PRIMARY KEY, a TEXT(500), b VARCHAR(255), FULLTEXT(b)) ENGINE=InnoDB encrypted=yes;
6 CREATE TABLE t6 (id INT, a TEXT(500), b VARCHAR(255), FULLTEXT(b)) ENGINE=InnoDB;
7 CREATE TABLE t7 (id INT NOT NULL PRIMARY KEY, a VARCHAR(255)) ENGINE=InnoDB row_format=compressed encrypted=yes;
8 create procedure innodb_insert_proc (repeat_count int)
9 begin
10 declare current_num int;
11 set current_num = 0;
12 while current_num < repeat_count do
13 insert into t1 values (current_num,repeat('foobar',12));
14 insert into t2 values (current_num,repeat('tempsecret', 12));
15 insert into t3 values (current_num,repeat('barfoo',42));
16 insert into t4 values (current_num,repeat('repeat',42));
17 insert into t5 values (current_num,substring('A BC DEF GHIJ KLM NOPQRS TUV WXYZ 012 3456789', rand()*36+1, 100), repeat('author new',22));
18 insert into t6 values (current_num,substring('A BC DEF GHIJ KLM NOPQRS TUV WXYZ 012 3456789', rand()*36+1, 100), repeat('mangled old',22));
19 insert into t7 values (current_num,repeat('mysql',42));
20 set current_num = current_num + 1;
21 end while;
22 end//
23 commit;
24 set autocommit=0;
25 call innodb_insert_proc(1500);
26 commit;
27 set autocommit=1;
28 # Wait max 10 min for key encryption threads to encrypt all spaces
29 # t1 yes on expecting NOT FOUND
30 NOT FOUND /foobar/ in t1.ibd
31 # t2 ... on expecting NOT FOUND
32 NOT FOUND /tempsecret/ in t2.ibd
33 # t3 ... on expecting NOT FOUND
34 NOT FOUND /barfoo/ in t3.ibd
35 # t4 ... on expecting NOT FOUND
36 NOT FOUND /repeat/ in t4.ibd
37 # t5 ... on expecting NOT FOUND
38 NOT FOUND /author/ in t5.ibd
39 # t6 ... on expecting NOT FOUND
40 NOT FOUND /mangled/ in t6.ibd
41 # t7 ... on expecting NOT FOUND
42 NOT FOUND /mysql/ in t7.ibd
43 # restart
44 ALTER TABLE t1 ADD COLUMN b int default 2;
45 ALTER TABLE t2 ADD COLUMN b int default 2;
46 ALTER TABLE t7 ADD COLUMN b int default 2;
47 ALTER TABLE t1 ADD KEY a(a), ADD KEY b(b);
48 ALTER TABLE t2 ADD KEY a(a), ADD KEY b(b);
49 ALTER TABLE t3 ADD COLUMN c int default 5;
50 ALTER TABLE t4 ADD COLUMN c int default 5;
51 ALTER TABLE t3 ADD KEY (a), ADD KEY c(c);
52 ALTER TABLE t4 ADD KEY (a), ADD KEY c(c);
53 ALTER TABLE t5 ADD FULLTEXT(a);
54 ALTER TABLE t6 ADD FULLTEXT(a);
55 ALTER TABLE t7 ADD KEY a(a), ADD key b(b);
56 SHOW CREATE TABLE t1;
57 Table Create Table
58 t1 CREATE TABLE `t1` (
59 `id` int(11) NOT NULL,
60 `a` varchar(255) DEFAULT NULL,
61 `b` int(11) DEFAULT 2,
62 PRIMARY KEY (`id`),
63 KEY `a` (`a`),
64 KEY `b` (`b`)
65 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci `encrypted`=yes
66 SHOW CREATE TABLE t2;
67 Table Create Table
68 t2 CREATE TABLE `t2` (
69 `id` int(11) NOT NULL,
70 `a` varchar(255) DEFAULT NULL,
71 `b` int(11) DEFAULT 2,
72 PRIMARY KEY (`id`),
73 KEY `a` (`a`),
74 KEY `b` (`b`)
75 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
76 SHOW CREATE TABLE t3;
77 Table Create Table
78 t3 CREATE TABLE `t3` (
79 `id` int(11) DEFAULT NULL,
80 `a` varchar(255) DEFAULT NULL,
81 `c` int(11) DEFAULT 5,
82 KEY `a` (`a`),
83 KEY `c` (`c`)
84 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci `encrypted`=yes
85 SHOW CREATE TABLE t4;
86 Table Create Table
87 t4 CREATE TABLE `t4` (
88 `id` int(11) DEFAULT NULL,
89 `a` varchar(255) DEFAULT NULL,
90 `c` int(11) DEFAULT 5,
91 KEY `a` (`a`),
92 KEY `c` (`c`)
93 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
94 SHOW CREATE TABLE t5;
95 Table Create Table
96 t5 CREATE TABLE `t5` (
97 `id` int(11) NOT NULL,
98 `a` text DEFAULT NULL,
99 `b` varchar(255) DEFAULT NULL,
100 PRIMARY KEY (`id`),
101 FULLTEXT KEY `b` (`b`),
102 FULLTEXT KEY `a` (`a`)
103 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci `encrypted`=yes
104 SHOW CREATE TABLE t6;
105 Table Create Table
106 t6 CREATE TABLE `t6` (
107 `id` int(11) DEFAULT NULL,
108 `a` text DEFAULT NULL,
109 `b` varchar(255) DEFAULT NULL,
110 FULLTEXT KEY `b` (`b`),
111 FULLTEXT KEY `a` (`a`)
112 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
113 SHOW CREATE TABLE t7;
114 Table Create Table
115 t7 CREATE TABLE `t7` (
116 `id` int(11) NOT NULL,
117 `a` varchar(255) DEFAULT NULL,
118 `b` int(11) DEFAULT 2,
119 PRIMARY KEY (`id`),
120 KEY `a` (`a`),
121 KEY `b` (`b`)
122 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci ROW_FORMAT=COMPRESSED `encrypted`=yes
123 # t1 yes on expecting NOT FOUND
124 NOT FOUND /foobar/ in t1.ibd
125 # t2 ... on expecting NOT FOUND
126 NOT FOUND /tempsecret/ in t2.ibd
127 # t3 ... on expecting NOT FOUND
128 NOT FOUND /barfoo/ in t3.ibd
129 # t4 ... on expecting NOT FOUND
130 NOT FOUND /repeat/ in t4.ibd
131 # t5 ... on expecting NOT FOUND
132 NOT FOUND /author/ in t5.ibd
133 # t6 ... on expecting NOT FOUND
134 NOT FOUND /mangled/ in t6.ibd
135 # t7 ... on expecting NOT FOUND
136 NOT FOUND /mysql/ in t7.ibd
137 # restart
138 DROP PROCEDURE innodb_insert_proc;
139 DROP TABLE t1, t2, t3, t4, t5, t6, t7;