| 1 |
--source include/have_sequence.inc |
| 2 |
--source include/have_innodb.inc |
| 3 |
--source include/have_file_key_management_plugin.inc |
| 4 |
|
| 5 |
--disable_cursor_protocol |
| 6 |
SELECT CAST(variable_value AS INT) INTO @old_encrypted |
| 7 |
FROM information_schema.global_status |
| 8 |
WHERE variable_name = 'innodb_encryption_n_temp_blocks_encrypted'; |
| 9 |
|
| 10 |
SELECT CAST(variable_value AS INT) INTO @old_decrypted |
| 11 |
FROM information_schema.global_status |
| 12 |
WHERE variable_name = 'innodb_encryption_n_temp_blocks_decrypted'; |
| 13 |
--enable_cursor_protocol |
| 14 |
|
| 15 |
CREATE TEMPORARY TABLE t1(f1 CHAR(200), f2 CHAR(200)) ENGINE=InnoDB; |
| 16 |
INSERT INTO t1 (f1,f2) SELECT '', '' FROM seq_1_to_8192; |
| 17 |
|
| 18 |
CREATE TEMPORARY TABLE t2(f1 CHAR(100), f2 CHAR(200), f3 CHAR(200))ENGINE=InnoDB; |
| 19 |
INSERT INTO t2 (f1,f2,f3) SELECT '', '', '' FROM seq_1_to_8192; |
| 20 |
|
| 21 |
SELECT COUNT(*) FROM t1; |
| 22 |
SELECT COUNT(*) FROM t2; |
| 23 |
|
| 24 |
SELECT CAST(variable_value AS INT) > @old_encrypted |
| 25 |
FROM information_schema.global_status |
| 26 |
WHERE variable_name = 'innodb_encryption_n_temp_blocks_encrypted'; |
| 27 |
|
| 28 |
SELECT CAST(variable_value AS INT) > @old_decrypted |
| 29 |
FROM information_schema.global_status |
| 30 |
WHERE variable_name = 'innodb_encryption_n_temp_blocks_decrypted'; |