Debian Codegraph @

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