Debian Codegraph @

mysql-test/suite/query_rewrite_plugins/r/rpl_ddl_rewriter.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 #
7 # Install plugin on nmaster.
8 #
9 INSTALL PLUGIN ddl_rewriter SONAME 'ddl_rewriter.xxx';
10 SELECT PLUGIN_NAME, PLUGIN_TYPE, PLUGIN_VERSION, PLUGIN_TYPE_VERSION
11 FROM information_schema.plugins
12 WHERE plugin_name LIKE 'ddl_rewriter';
13 PLUGIN_NAME PLUGIN_TYPE PLUGIN_VERSION PLUGIN_TYPE_VERSION
14 ddl_rewriter AUDIT 1.0 4.1
15 include/sync_slave_sql_with_master.inc
16 SELECT PLUGIN_NAME, PLUGIN_TYPE, PLUGIN_VERSION, PLUGIN_TYPE_VERSION
17 FROM information_schema.plugins
18 WHERE plugin_name LIKE 'ddl_rewriter';
19 PLUGIN_NAME PLUGIN_TYPE PLUGIN_VERSION PLUGIN_TYPE_VERSION
20 #
21 # Create tables.
22 #
23 CREATE SCHEMA mysqltest_ddl_rewriter;
24 USE mysqltest_ddl_rewriter;
25 CREATE TABLE t1(i int) DATA DIRECTORY = '/tmp';
26 Warnings:
27 Note 1105 Query 'CREATE TABLE t1(i int) DATA DIRECTORY = '/tmp'' rewritten to 'CREATE TABLE t1(i int) ' by a query rewrite plugin
28 CREATE TABLE t2(i int) INDEX DIRECTORY = '/tmp';
29 Warnings:
30 Note 1105 Query 'CREATE TABLE t2(i int) INDEX DIRECTORY = '/tmp'' rewritten to 'CREATE TABLE t2(i int) ' by a query rewrite plugin
31 CREATE TABLE t3(i int) ENCRYPTION = 'n';
32 Warnings:
33 Note 1105 Query 'CREATE TABLE t3(i int) ENCRYPTION = 'n'' rewritten to 'CREATE TABLE t3(i int) ' by a query rewrite plugin
34 #
35 # Tables on master.
36 #
37 SHOW CREATE TABLE t1;
38 Table Create Table
39 t1 CREATE TABLE `t1` (
40 `i` int DEFAULT NULL
41 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
42 SHOW CREATE TABLE t2;
43 Table Create Table
44 t2 CREATE TABLE `t2` (
45 `i` int DEFAULT NULL
46 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
47 SHOW CREATE TABLE t3;
48 Table Create Table
49 t3 CREATE TABLE `t3` (
50 `i` int DEFAULT NULL
51 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
52 include/sync_slave_sql_with_master.inc
53 #
54 # Tables on slave.
55 #
56 USE mysqltest_ddl_rewriter;
57 SHOW CREATE TABLE t1;
58 Table Create Table
59 t1 CREATE TABLE `t1` (
60 `i` int DEFAULT NULL
61 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
62 SHOW CREATE TABLE t2;
63 Table Create Table
64 t2 CREATE TABLE `t2` (
65 `i` int DEFAULT NULL
66 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
67 SHOW CREATE TABLE t3;
68 Table Create Table
69 t3 CREATE TABLE `t3` (
70 `i` int DEFAULT NULL
71 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
72 #
73 # Cleanup and uninstall plugin.
74 #
75 DROP SCHEMA mysqltest_ddl_rewriter;
76 UNINSTALL PLUGIN ddl_rewriter;
77 Warnings:
78 Warning 1620 Plugin is busy and will be uninstalled on shutdown
79 include/sync_slave_sql_with_master.inc
80 include/rpl_end.inc