Debian Codegraph @

mysql-test/suite/query_rewrite_plugins/t/rpl_ddl_rewriter.test

raw
1 # Tests for replication of statements that are rewritten by
2 # the ddl rewrite plugin.
3
4 --source include/not_group_replication_plugin.inc
5 --source include/master-slave.inc
6
7
8 --echo #
9 --echo # Install plugin on nmaster.
10 --echo #
11
12 connection master;
13
14 --source suite/query_rewrite_plugins/include/have_ddl_rewriter.inc
15 --source suite/query_rewrite_plugins/include/install_ddl_rewriter.inc
16 --source include/have_log_bin.inc
17
18 SELECT PLUGIN_NAME, PLUGIN_TYPE, PLUGIN_VERSION, PLUGIN_TYPE_VERSION
19 FROM information_schema.plugins
20 WHERE plugin_name LIKE 'ddl_rewriter';
21
22 --source include/sync_slave_sql_with_master.inc
23
24 SELECT PLUGIN_NAME, PLUGIN_TYPE, PLUGIN_VERSION, PLUGIN_TYPE_VERSION
25 FROM information_schema.plugins
26 WHERE plugin_name LIKE 'ddl_rewriter';
27
28 connection master;
29
30 --echo #
31 --echo # Create tables.
32 --echo #
33
34 CREATE SCHEMA mysqltest_ddl_rewriter;
35 USE mysqltest_ddl_rewriter;
36 CREATE TABLE t1(i int) DATA DIRECTORY = '/tmp';
37 CREATE TABLE t2(i int) INDEX DIRECTORY = '/tmp';
38 CREATE TABLE t3(i int) ENCRYPTION = 'n';
39
40
41 --echo #
42 --echo # Tables on master.
43 --echo #
44
45 SHOW CREATE TABLE t1;
46 SHOW CREATE TABLE t2;
47 SHOW CREATE TABLE t3;
48 --source include/sync_slave_sql_with_master.inc
49
50
51 --echo #
52 --echo # Tables on slave.
53 --echo #
54
55 USE mysqltest_ddl_rewriter;
56 SHOW CREATE TABLE t1;
57 SHOW CREATE TABLE t2;
58 SHOW CREATE TABLE t3;
59
60
61 --echo #
62 --echo # Cleanup and uninstall plugin.
63 --echo #
64
65 connection master;
66 DROP SCHEMA mysqltest_ddl_rewriter;
67 UNINSTALL PLUGIN ddl_rewriter;
68
69
70 --source include/sync_slave_sql_with_master.inc
71 --source include/rpl_end.inc