Debian Codegraph @

mysql-test/suite/rpl_nogtid/r/rpl_invoked_features.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 USE test;
7 DROP VIEW IF EXISTS v11;
8 DROP TABLE IF EXISTS t11,t12,t13;
9 DROP PROCEDURE IF EXISTS p11;
10 DROP FUNCTION IF EXISTS f1;
11 DROP FUNCTION IF EXISTS f2;
12 DROP EVENT IF EXISTS e11;
13 CREATE TABLE t11 (a INT NOT NULL PRIMARY KEY, b INT, c VARCHAR(64)) ENGINE=innodb;
14 INSERT INTO t11 VALUES (1,1,'1');
15 INSERT INTO t11 VALUES (2,2,UUID());
16 CREATE TABLE t12 (a INT UNIQUE, b INT, c VARCHAR(64)) ENGINE=innodb;
17 INSERT INTO t12 VALUES (1,1,'1');
18 INSERT INTO t12 VALUES (2,2,UUID());
19
20 CREATE VIEW v11 AS SELECT * FROM t11;
21 CREATE TRIGGER t11_tr1 BEFORE INSERT ON t11 FOR EACH ROW
22 BEGIN
23 INSERT INTO t12 VALUES (NEW.a, NEW.b, NEW.c);
24 INSERT INTO t13 VALUES (NEW.a, NEW.b, NEW.c);
25 END|
26 CREATE TRIGGER t11_tr2 BEFORE UPDATE ON t11 FOR EACH ROW
27 BEGIN
28 UPDATE t12 SET c = '';
29 UPDATE t13 SET c = '';
30 END|
31 CREATE EVENT e11 ON SCHEDULE EVERY 1 SECOND DISABLE DO
32 BEGIN
33 ALTER EVENT e11 DISABLE;
34 CALL p11(10, '');
35 END|
36 CREATE FUNCTION f1 (x INT) RETURNS VARCHAR(64)
37 BEGIN
38 IF x > 5 THEN
39 RETURN UUID();
40 END IF;
41 RETURN '';
42 END|
43 CREATE FUNCTION f2 (x INT) RETURNS VARCHAR(64)
44 BEGIN
45 RETURN f1(x);
46 END|
47 CREATE PROCEDURE p11 (IN x INT, IN y VARCHAR(64))
48 BEGIN
49 INSERT IGNORE INTO t11 VALUES (x,x,y);
50 END|
51
52 CREATE TABLE t13 SELECT * FROM v11;
53 INSERT INTO t11 VALUES (3,3,'');
54 UPDATE t11 SET c='2' WHERE a = 1;
55 INSERT INTO t11 VALUES(4,4,f1(4));
56 INSERT INTO t11 VALUES (100,100,'');
57 CALL p11(5, UUID());
58 INSERT INTO t11 VALUES (101,101,'');
59 INSERT INTO t11 VALUES(6,6,f1(6));
60 INSERT INTO t11 VALUES (102,102,'');
61 INSERT INTO t11 VALUES(7,7,f2(7));
62 INSERT INTO t11 VALUES (103,103,'');
63
64 SET @old_event_scheduler= @@global.event_scheduler;
65 SET GLOBAL EVENT_SCHEDULER = on;
66 ALTER EVENT e11 ENABLE;
67 SET @@global.event_scheduler= @old_event_scheduler;
68
69 SHOW TABLES LIKE 't%';
70 Tables_in_test (t%)
71 t11
72 t12
73 t13
74 SELECT table_name FROM information_schema.views WHERE table_schema='test';
75 TABLE_NAME
76 v11
77 SELECT trigger_name, event_manipulation, event_object_table FROM information_schema.triggers WHERE trigger_schema='test';
78 TRIGGER_NAME EVENT_MANIPULATION EVENT_OBJECT_TABLE
79 t11_tr1 INSERT t11
80 t11_tr2 UPDATE t11
81 SELECT routine_type, routine_name FROM information_schema.routines WHERE routine_schema='test';
82 ROUTINE_TYPE ROUTINE_NAME
83 FUNCTION f1
84 FUNCTION f2
85 PROCEDURE p11
86 SELECT event_name, status FROM information_schema.events WHERE event_schema='test';
87 EVENT_NAME STATUS
88 e11 DISABLED
89 SELECT COUNT(*) FROM t11;
90 COUNT(*)
91 12
92 SELECT a,b FROM t11 ORDER BY a;
93 a b
94 1 1
95 2 2
96 3 3
97 4 4
98 5 5
99 6 6
100 7 7
101 10 10
102 100 100
103 101 101
104 102 102
105 103 103
106 SELECT COUNT(*) FROM t12;
107 COUNT(*)
108 12
109 SELECT a,b FROM t12 ORDER BY a;
110 a b
111 1 1
112 2 2
113 3 3
114 4 4
115 5 5
116 6 6
117 7 7
118 10 10
119 100 100
120 101 101
121 102 102
122 103 103
123 SELECT COUNT(*) FROM t13;
124 COUNT(*)
125 12
126 SELECT a,b FROM t13 ORDER BY a;
127 a b
128 1 1
129 2 2
130 3 3
131 4 4
132 5 5
133 6 6
134 7 7
135 10 10
136 100 100
137 101 101
138 102 102
139 103 103
140 SELECT a,b FROM v11 ORDER BY a;
141 a b
142 1 1
143 2 2
144 3 3
145 4 4
146 5 5
147 6 6
148 7 7
149 10 10
150 100 100
151 101 101
152 102 102
153 103 103
154 include/sync_slave_sql_with_master.inc
155
156 SHOW TABLES LIKE 't%';
157 Tables_in_test (t%)
158 t11
159 t12
160 t13
161 SELECT table_name FROM information_schema.views WHERE table_schema='test';
162 TABLE_NAME
163 v11
164 SELECT trigger_name, event_manipulation, event_object_table FROM information_schema.triggers WHERE trigger_schema='test';
165 TRIGGER_NAME EVENT_MANIPULATION EVENT_OBJECT_TABLE
166 t11_tr1 INSERT t11
167 t11_tr2 UPDATE t11
168 SELECT routine_type, routine_name FROM information_schema.routines WHERE routine_schema='test';
169 ROUTINE_TYPE ROUTINE_NAME
170 FUNCTION f1
171 FUNCTION f2
172 PROCEDURE p11
173 SELECT event_name, status FROM information_schema.events WHERE event_schema='test';
174 EVENT_NAME STATUS
175 e11 SLAVESIDE_DISABLED
176
177 SELECT COUNT(*) FROM t11;
178 COUNT(*)
179 12
180 SELECT a,b FROM t11 ORDER BY a;
181 a b
182 1 1
183 2 2
184 3 3
185 4 4
186 5 5
187 6 6
188 7 7
189 10 10
190 100 100
191 101 101
192 102 102
193 103 103
194 SELECT COUNT(*) FROM t12;
195 COUNT(*)
196 12
197 SELECT a,b FROM t12 ORDER BY a;
198 a b
199 1 1
200 2 2
201 3 3
202 4 4
203 5 5
204 6 6
205 7 7
206 10 10
207 100 100
208 101 101
209 102 102
210 103 103
211 SELECT COUNT(*) FROM t13;
212 COUNT(*)
213 12
214 SELECT a,b FROM t13 ORDER BY a;
215 a b
216 1 1
217 2 2
218 3 3
219 4 4
220 5 5
221 6 6
222 7 7
223 10 10
224 100 100
225 101 101
226 102 102
227 103 103
228 SELECT a,b FROM v11 ORDER BY a;
229 a b
230 1 1
231 2 2
232 3 3
233 4 4
234 5 5
235 6 6
236 7 7
237 10 10
238 100 100
239 101 101
240 102 102
241 103 103
242
243 UPDATE t11 SET c='';
244 UPDATE t12 SET c='';
245 UPDATE t13 SET c='';
246 ALTER TABLE t13 ORDER BY a;
247 include/sync_slave_sql_with_master.inc
248
249
250
251 DROP VIEW IF EXISTS v11;
252 DROP TABLE IF EXISTS t11,t12,t13;
253 DROP PROCEDURE IF EXISTS p11;
254 DROP FUNCTION IF EXISTS f1;
255 DROP FUNCTION IF EXISTS f2;
256 DROP EVENT IF EXISTS e11;
257 include/sync_slave_sql_with_master.inc
258 include/rpl_end.inc