summaryrefslogtreecommitdiff
path: root/mysql-test/suite/encryption/r/innodb-remove-encryption.result
diff options
context:
space:
mode:
authorMarko Mäkelä <marko.makela@mariadb.com>2023-01-31 12:05:17 +0200
committerMarko Mäkelä <marko.makela@mariadb.com>2023-01-31 12:05:17 +0200
commit377f4ec755c81ba49c7d27e510ac5a2acd74c688 (patch)
tree62fc5164ed13a7c35260645de221c8f7e774f6a9 /mysql-test/suite/encryption/r/innodb-remove-encryption.result
parent6252a281b5020d28685777c11ee27688a9db3d66 (diff)
downloadmariadb-git-bb-11.0-MDEV-29985.tar.gz
MDEV-29985 Remove the parameter innodb_file_per_tablebb-11.0-MDEV-29985
This follows up commit e581396b7aea94485580d2c9edaa9c5df647f2b7 (MDEV-29983), which deprecated the parameter.
Diffstat (limited to 'mysql-test/suite/encryption/r/innodb-remove-encryption.result')
-rw-r--r--mysql-test/suite/encryption/r/innodb-remove-encryption.result10
1 files changed, 5 insertions, 5 deletions
diff --git a/mysql-test/suite/encryption/r/innodb-remove-encryption.result b/mysql-test/suite/encryption/r/innodb-remove-encryption.result
index 22207f8184a..e8ab4145d9d 100644
--- a/mysql-test/suite/encryption/r/innodb-remove-encryption.result
+++ b/mysql-test/suite/encryption/r/innodb-remove-encryption.result
@@ -1,6 +1,3 @@
-set global innodb_file_per_table=OFF;
-Warnings:
-Warning 1287 '@@innodb_file_per_table' is deprecated and will be removed in a future release
call mtr.add_suppression("(mysqld|mariadbd).*: file-key-management-filename is not set");
call mtr.add_suppression("Plugin 'file_key_management' init function returned error.");
call mtr.add_suppression("Plugin 'file_key_management' registration as a ENCRYPTION failed.");
@@ -12,12 +9,13 @@ create table t1(a int not null primary key, b char(200)) engine=innodb;
# Wait until encryption threads have encrypted all tablespaces
SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0;
NAME
+innodb_system
SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0;
NAME
-innodb_system
mysql/innodb_index_stats
mysql/innodb_table_stats
mysql/transaction_registry
+test/t1
# Success!
SELECT * from t1;
a b
@@ -29,6 +27,7 @@ innodb_system
mysql/innodb_index_stats
mysql/innodb_table_stats
mysql/transaction_registry
+test/t1
SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0;
NAME
# Success!
@@ -37,12 +36,13 @@ NAME
# restart: --skip-file-key-management --innodb-encrypt-tables=OFF --innodb-encryption-threads=0 --innodb-tablespaces-encryption
SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0;
NAME
-innodb_system
mysql/innodb_index_stats
mysql/innodb_table_stats
mysql/transaction_registry
+test/t1
SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0;
NAME
+innodb_system
SELECT * from t1;
a b
DROP TABLE t1;