diff options
Diffstat (limited to 'plugin/hashicorp_key_management/mysql-test/vault/r/hashicorp_encode.result')
-rw-r--r-- | plugin/hashicorp_key_management/mysql-test/vault/r/hashicorp_encode.result | 49 |
1 files changed, 49 insertions, 0 deletions
diff --git a/plugin/hashicorp_key_management/mysql-test/vault/r/hashicorp_encode.result b/plugin/hashicorp_key_management/mysql-test/vault/r/hashicorp_encode.result new file mode 100644 index 00000000..04ac22b9 --- /dev/null +++ b/plugin/hashicorp_key_management/mysql-test/vault/r/hashicorp_encode.result @@ -0,0 +1,49 @@ +SHOW GLOBAL variables LIKE "hashicorp%"; +Variable_name Value +hashicorp_key_management_cache_timeout 60000 +hashicorp_key_management_cache_version_timeout 0 +hashicorp_key_management_caching_enabled ON +hashicorp_key_management_check_kv_version OFF +hashicorp_key_management_max_retries 3 +hashicorp_key_management_timeout 60 +hashicorp_key_management_use_cache_on_timeout OFF +hashicorp_key_management_vault_ca +hashicorp_key_management_vault_url VAULT_ADDR/v1/mariadbtest/ +create table t1(c1 bigint not null, b char(200)) engine=innodb encrypted=yes encryption_key_id=1; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL, + `b` char(200) DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci `encrypted`=yes `encryption_key_id`=1 +insert t1 values (12345, repeat('1234567890', 20)); +alter table t1 encryption_key_id=2; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL, + `b` char(200) DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci `encrypted`=yes `encryption_key_id`=2 +alter table t1 encryption_key_id=33; +ERROR HY000: Table storage engine 'InnoDB' does not support the create option 'ENCRYPTION_KEY_ID' +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL, + `b` char(200) DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci `encrypted`=yes `encryption_key_id`=2 +alter table t1 encryption_key_id=3; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL, + `b` char(200) DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci `encrypted`=yes `encryption_key_id`=3 +alter table t1 encryption_key_id=4; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL, + `b` char(200) DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci `encrypted`=yes `encryption_key_id`=4 +drop table t1; |