Debian Codegraph @

mysql-test/suite/rpl_nogtid/r/rpl_ignore_table.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 **** Test case for BUG#16487 ****
7 **** Master ****
8 CREATE TABLE test.t4 (a int);
9 CREATE TABLE test.t1 (a int);
10 UPDATE test.t4 NATURAL JOIN test.t1 SET t1.a=5;
11 **** Slave ****
12 SELECT * FROM t4;
13 a
14 DROP TABLE t1;
15 DROP TABLE t4;
16 **** Test case for BUG#25482 ****
17 **** Adding GRANTS on master ****
18 create table test.t1(a int);
19 create table test.t4(a int);
20 CREATE USER mysqltest1@localhost;
21 GRANT SELECT ON test.t1 TO mysqltest1@localhost;
22 CREATE USER mysqltest2@localhost;
23 GRANT INSERT ON test.t4 TO mysqltest2@localhost;
24 GRANT select, update, insert, references on t1
25 to mysqltest2@localhost;
26 CREATE USER mysqltest3@localhost;
27 GRANT SELECT ON test.* TO mysqltest3@localhost;
28 GRANT INSERT ON test.t4 TO mysqltest3@localhost;
29 GRANT select(a), update(a), insert(a), references(a) on t4
30 to mysqltest3@localhost;
31 create database mysqltest2;
32 create table mysqltest2.t2 (id int);
33 CREATE USER mysqltest4@localhost IDENTIFIED BY 'pass';
34 GRANT SELECT ON mysqltest2.t2 TO mysqltest4@localhost;
35 insert ignore into mysql.user (user, host) values ("mysqltest5", "somehost");
36 Warnings:
37 Warning 1364 Field 'ssl_cipher' doesn't have a default value
38 Warning 1364 Field 'x509_issuer' doesn't have a default value
39 Warning 1364 Field 'x509_subject' doesn't have a default value
40 CREATE USER mysqltest6@localhost;
41 GRANT SELECT ON *.* TO mysqltest6@localhost;
42 GRANT INSERT ON *.* TO mysqltest6@localhost;
43 GRANT INSERT ON test.* TO mysqltest6@localhost;
44 GRANT INSERT ON test.t1 TO mysqltest6@localhost;
45 show grants for mysqltest1@localhost;
46 Grants for mysqltest1@localhost
47 GRANT SELECT ON `test`.`t1` TO `mysqltest1`@`localhost`
48 GRANT USAGE ON *.* TO `mysqltest1`@`localhost`
49 show grants for mysqltest2@localhost;
50 Grants for mysqltest2@localhost
51 GRANT INSERT ON `test`.`t4` TO `mysqltest2`@`localhost`
52 GRANT SELECT, INSERT, UPDATE, REFERENCES ON `test`.`t1` TO `mysqltest2`@`localhost`
53 GRANT USAGE ON *.* TO `mysqltest2`@`localhost`
54 show grants for mysqltest3@localhost;
55 Grants for mysqltest3@localhost
56 GRANT SELECT (`a`), INSERT, INSERT (`a`), UPDATE (`a`), REFERENCES (`a`) ON `test`.`t4` TO `mysqltest3`@`localhost`
57 GRANT SELECT ON `test`.* TO `mysqltest3`@`localhost`
58 GRANT USAGE ON *.* TO `mysqltest3`@`localhost`
59 show grants for mysqltest4@localhost;
60 Grants for mysqltest4@localhost
61 GRANT SELECT ON `mysqltest2`.`t2` TO `mysqltest4`@`localhost`
62 GRANT USAGE ON *.* TO `mysqltest4`@`localhost`
63 show grants for mysqltest6@localhost;
64 Grants for mysqltest6@localhost
65 GRANT INSERT ON `test`.* TO `mysqltest6`@`localhost`
66 GRANT INSERT ON `test`.`t1` TO `mysqltest6`@`localhost`
67 GRANT SELECT, INSERT ON *.* TO `mysqltest6`@`localhost`
68 flush privileges;
69 show grants for mysqltest5@somehost;
70 Grants for mysqltest5@somehost
71 GRANT USAGE ON *.* TO `mysqltest5`@`somehost`
72 **** Checking grants on slave ****
73 show grants for mysqltest2@localhost;
74 Grants for mysqltest2@localhost
75 GRANT USAGE ON *.* TO `mysqltest2`@`localhost`
76 GRANT INSERT ON `test`.`t4` TO `mysqltest2`@`localhost`
77 show grants for mysqltest3@localhost;
78 Grants for mysqltest3@localhost
79 GRANT USAGE ON *.* TO `mysqltest3`@`localhost`
80 GRANT SELECT ON `test`.* TO `mysqltest3`@`localhost`
81 GRANT SELECT (`a`), INSERT, INSERT (`a`), UPDATE (`a`), REFERENCES (`a`) ON `test`.`t4` TO `mysqltest3`@`localhost`
82 show grants for mysqltest4@localhost;
83 Grants for mysqltest4@localhost
84 GRANT USAGE ON *.* TO `mysqltest4`@`localhost`
85 GRANT SELECT ON `mysqltest2`.`t2` TO `mysqltest4`@`localhost`
86 show grants for mysqltest5@somehost;
87 Grants for mysqltest5@somehost
88 GRANT USAGE ON *.* TO `mysqltest5`@`somehost`
89 show grants for mysqltest6@localhost;
90 Grants for mysqltest6@localhost
91 GRANT SELECT, INSERT ON *.* TO `mysqltest6`@`localhost`
92 GRANT INSERT ON `test`.* TO `mysqltest6`@`localhost`
93 show grants for mysqltest1@localhost;
94 Grants for mysqltest1@localhost
95 GRANT USAGE ON *.* TO `mysqltest1`@`localhost`
96 **** Revoking grants on master ****
97 REVOKE SELECT ON test.t1 FROM mysqltest1@localhost;
98 REVOKE SELECT ON mysqltest2.t2 FROM mysqltest4@localhost;
99 REVOKE select(a) on t4
100 from mysqltest3@localhost;
101 show grants for mysqltest1@localhost;
102 Grants for mysqltest1@localhost
103 GRANT USAGE ON *.* TO `mysqltest1`@`localhost`
104 show grants for mysqltest3@localhost;
105 Grants for mysqltest3@localhost
106 GRANT USAGE ON *.* TO `mysqltest3`@`localhost`
107 GRANT SELECT ON `test`.* TO `mysqltest3`@`localhost`
108 GRANT INSERT, INSERT (`a`), UPDATE (`a`), REFERENCES (`a`) ON `test`.`t4` TO `mysqltest3`@`localhost`
109 show grants for mysqltest4@localhost;
110 Grants for mysqltest4@localhost
111 GRANT USAGE ON *.* TO `mysqltest4`@`localhost`
112 **** Checking grants on slave ****
113 show grants for mysqltest1@localhost;
114 Grants for mysqltest1@localhost
115 GRANT USAGE ON *.* TO `mysqltest1`@`localhost`
116 show grants for mysqltest3@localhost;
117 Grants for mysqltest3@localhost
118 GRANT USAGE ON *.* TO `mysqltest3`@`localhost`
119 GRANT SELECT ON `test`.* TO `mysqltest3`@`localhost`
120 GRANT INSERT, INSERT (`a`), UPDATE (`a`), REFERENCES (`a`) ON `test`.`t4` TO `mysqltest3`@`localhost`
121 show grants for mysqltest4@localhost;
122 Grants for mysqltest4@localhost
123 GRANT USAGE ON *.* TO `mysqltest4`@`localhost`
124 set global replica_exec_mode='IDEMPOTENT';
125 call mtr.add_suppression("Replica SQL.*Could not execute Delete_rows event on table mysql.* Error_code: 1032");
126 drop table t1, mysqltest2.t2;
127 drop table t4;
128 drop database mysqltest2;
129 delete from mysql.user where user like "mysqltest%";
130 delete from mysql.db where user like "mysqltest%";
131 delete from mysql.columns_priv where user like "mysqltest%";
132 delete from mysql.tables_priv where user like "mysqltest%";
133 delete from mysql.tables_priv where user like "mysqltest%";
134 DROP TABLE IF EXISTS t5;
135 CREATE TABLE t5 (
136 word varchar(50) collate utf8_unicode_ci NOT NULL default ''
137 ) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
138 Warnings:
139 Warning 3778 'utf8mb3_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
140 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
141 Warning 3778 'utf8mb3_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
142 SET @@session.character_set_client=33,@@session.collation_connection=192;
143 Warnings:
144 Warning 1287 'utf8mb3' is deprecated and will be removed in a future release. Please use utf8mb4 instead
145 Warning 3778 'utf8mb3_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
146 CREATE TEMPORARY TABLE tmptbl504451f4258$1 (id INT NOT NULL) ENGINE=MEMORY;
147 INSERT INTO t5 (word) VALUES ('TEST’');
148 SELECT HEX(word) FROM t5;
149 HEX(word)
150 54455354E28099
151 set @@global.replica_exec_mode= default;
152 SELECT HEX(word) FROM t5;
153 HEX(word)
154 54455354E28099
155 SELECT * FROM tmptbl504451f4258$1;
156 ERROR 42S02: Table 'test.tmptbl504451f4258$1' doesn't exist
157 DROP TABLE t5;
158 include/rpl_end.inc