45 lines
1.3 KiB
Plaintext
45 lines
1.3 KiB
Plaintext
#
|
|
# Bug #29820184 REDO LOGS MAY SILENTLY BE IGNORED WHEN ENCRYPTED TABLE
|
|
# CANNOT BE DECRYPTED.
|
|
#
|
|
CREATE TABLE t1(
|
|
a INT NOT NULL PRIMARY KEY,
|
|
c CHAR(200),
|
|
b BLOB,
|
|
INDEX(b(10))) ENGINE=innodb ROW_FORMAT=compressed ENCRYPTION='Y';
|
|
CREATE TABLE t2(
|
|
a INT NOT NULL PRIMARY KEY,
|
|
c CHAR(200),
|
|
b BLOB,
|
|
INDEX(b(10))) ENGINE=innodb ROW_FORMAT=compressed ENCRYPTION='Y';
|
|
CREATE TABLE t3(
|
|
a INT NOT NULL PRIMARY KEY,
|
|
c CHAR(200),
|
|
b BLOB,
|
|
INDEX(b(10))) ENGINE=innodb ENCRYPTION='Y';
|
|
CREATE TABLE t4(
|
|
a INT NOT NULL PRIMARY KEY,
|
|
c CHAR(200),
|
|
b BLOB,
|
|
INDEX(b(10))) ENGINE=innodb ENCRYPTION='Y';
|
|
# restart
|
|
INSERT INTO t2 SELECT * FROM t1;
|
|
INSERT INTO t3 SELECT * FROM t1;
|
|
INSERT INTO t4 SELECT * FROM t1;
|
|
COMMIT;
|
|
SET GLOBAL innodb_flush_log_at_trx_commit=1;
|
|
BEGIN;
|
|
UPDATE t1 SET c = REPEAT('secret3', 20);
|
|
UPDATE t2 SET c = REPEAT('secret4', 20);
|
|
UPDATE t3 set c = REPEAT('secret4', 20);
|
|
UPDATE t4 set c = REPEAT('secret4', 20);
|
|
INSERT INTO t1 (a,c,b) VALUES (21, REPEAT('secret5',20), REPEAT('secret6',6000));
|
|
INSERT INTO t2 (a,c,b) VALUES (21, REPEAT('secret7',20), REPEAT('secret8',6000));
|
|
INSERT into t3 (a,c,b) VALUES (21, REPEAT('secret9',20), REPEAT('secre10',6000));
|
|
INSERT into t4 (a,c,b) VALUES (21, REPEAT('secre11',20), REPEAT('secre12',6000));
|
|
COMMIT;
|
|
# Kill the server
|
|
# Restart mysqld without keyring plugin
|
|
# Restart mysqld with keyring plugin
|
|
drop TABLE t1,t2,t3,t4;
|