--echo # --echo # WL#12261 - Test in replication environment. --echo # --source include/master-slave.inc --echo # Start the master with default_table_encryption=off --source include/rpl_connection_master.inc CREATE DATABASE db1; CREATE DATABASE db2 DEFAULT ENCRYPTION='n'; CREATE DATABASE db3 DEFAULT ENCRYPTION='y'; SHOW CREATE DATABASE db1; SHOW CREATE DATABASE db2; SHOW CREATE DATABASE db3; # CREATE TABLESPACE ts1 ADD DATAFILE 'df_e1.ibd'; # CREATE TABLESPACE ts2 ADD DATAFILE 'df_e2.ibd' ENCRYPTION='n'; # CREATE TABLESPACE ts3 ADD DATAFILE 'df_e3.ibd' ENCRYPTION='y'; SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME LIKE 'ts_'; CREATE TABLE db1.t1 (f1 INT); CREATE TABLE db2.t1 (f1 INT); CREATE TABLE db3.t1 (f1 INT); SHOW CREATE TABLE db1.t1; SHOW CREATE TABLE db2.t1; SHOW CREATE TABLE db3.t1; --echo # Start the slave with default_table_encryption=on --echo # The 'table_encryption_privilege_check' setting does not affect the --echo # slave thread operations. --source include/sync_slave_sql_with_master.inc --echo # Make sure encryption type for following objects are same as master. SHOW CREATE DATABASE db1; SHOW CREATE DATABASE db2; SHOW CREATE DATABASE db3; SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME LIKE 'ts_'; SHOW CREATE TABLE db1.t1; SHOW CREATE TABLE db2.t1; SHOW CREATE TABLE db3.t1; --source include/rpl_connection_master.inc DROP DATABASE db1; DROP DATABASE db2; DROP DATABASE db3; # DROP TABLESPACE ts1; # DROP TABLESPACE ts2; # DROP TABLESPACE ts3; --source include/rpl_end.inc --connection master --source suite/xengine/include/check_xengine_log_error.inc