diff options
Diffstat (limited to 'mysql-test/suite/encryption/r/innodb-bad-key-change.result')
-rw-r--r-- | mysql-test/suite/encryption/r/innodb-bad-key-change.result | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/suite/encryption/r/innodb-bad-key-change.result b/mysql-test/suite/encryption/r/innodb-bad-key-change.result index 68267f2498d..45c32317557 100644 --- a/mysql-test/suite/encryption/r/innodb-bad-key-change.result +++ b/mysql-test/suite/encryption/r/innodb-bad-key-change.result @@ -7,6 +7,7 @@ call mtr.add_suppression("InnoDB: Encrypted page \\[page id: space=[1-9][0-9]*, call mtr.add_suppression("InnoDB: Table `test`\\.`t[12]` is corrupted"); call mtr.add_suppression("File '.*mysql-test.std_data.keysbad3\\.txt' not found"); # Start server with keys2.txt +# restart: --file-key-management-filename=MYSQL_TEST_DIR/std_data/keys2.txt SET GLOBAL innodb_file_per_table = ON; CREATE TABLE t1 (c VARCHAR(8)) ENGINE=InnoDB ENCRYPTED=YES ENCRYPTION_KEY_ID=2; INSERT INTO t1 VALUES ('foobar'); @@ -28,15 +29,19 @@ foobar 1 foobar 2 # Restart server with keysbad3.txt +# restart: --file-key-management-filename=MYSQL_TEST_DIR/std_data/keysbad3.txt SELECT * FROM t1; ERROR 42S02: Table 'test.t1' doesn't exist in engine +# restart: --file-key-management-filename=MYSQL_TEST_DIR/std_data/keysbad3.txt DROP TABLE t1; # Start server with keys3.txt +# restart: --file-key-management-filename=MYSQL_TEST_DIR/std_data/keys3.txt SET GLOBAL innodb_default_encryption_key_id=5; CREATE TABLE t2 (c VARCHAR(8), id int not null primary key, b int, key(b)) ENGINE=InnoDB ENCRYPTED=YES; INSERT INTO t2 VALUES ('foobar',1,2); # Restart server with keys2.txt +# restart: --file-key-management-filename=MYSQL_TEST_DIR/std_data/keys2.txt SELECT * FROM t2; ERROR 42S02: Table 'test.t2' doesn't exist in engine SELECT * FROM t2 where id = 1; @@ -66,3 +71,4 @@ ERROR 42S02: Table 'test.t2' doesn't exist in engine DROP TABLE t2; # Start server with keys2.txt +# restart: --file-key-management-filename=MYSQL_TEST_DIR/std_data/keys2.txt |