Debian Codegraph @

mysql-test/suite/innodb/r/log_encrypt_7.result

raw
1 SET GLOBAL innodb_redo_log_encrypt = ON;
2 CREATE TABLE t1(c1 INT, c2 char(20)) ENCRYPTION="Y" ENGINE = InnoDB;
3 ERROR HY000: Can't find master key from keyring, please check in the server log if a keyring is loaded and initialized successfully.
4 CREATE TABLE t1(c1 INT, c2 char(20)) ENGINE = InnoDB;
5 ALTER TABLE t1 ENCRYPTION="Y", algorithm=copy;
6 ERROR HY000: Can't find master key from keyring, please check in the server log if a keyring is loaded and initialized successfully.
7 DROP DATABASE IF EXISTS tde_db;
8 CREATE DATABASE tde_db;
9 USE tde_db;
10 SET GLOBAL innodb_redo_log_encrypt = ON;
11 SHOW WARNINGS;
12 Level Code Message
13 CREATE TABLE tde_db.t4 (a BIGINT PRIMARY KEY, b LONGBLOB) ENGINE=InnoDB;
14 INSERT INTO t4 (a, b) VALUES (1, REPEAT('a', 6*512*512));
15 SELECT a,LEFT(b,10) FROM tde_db.t4;
16 a LEFT(b,10)
17 1 aaaaaaaaaa
18 # restart
19 SELECT a,LEFT(b,10) FROM tde_db.t4;
20 a LEFT(b,10)
21 1 aaaaaaaaaa
22 DROP TABLE tde_db.t4;
23 DROP TABLE test.t1;
24 DROP DATABASE tde_db;