1 include/master-slave.inc
4 DROP VIEW IF EXISTS v1,v11;
5 DROP TABLE IF EXISTS t1,t2,t3,t11,t12,t13;
6 DROP PROCEDURE IF EXISTS p1;
7 DROP PROCEDURE IF EXISTS p11;
8 DROP FUNCTION IF EXISTS f1;
9 DROP FUNCTION IF EXISTS f2;
10 DROP EVENT IF EXISTS e1;
11 DROP EVENT IF EXISTS e11;
13 CREATE TABLE t1 (a INT NOT NULL PRIMARY KEY, b INT, c VARCHAR(64)) ENGINE=myisam;
14 INSERT INTO t1 VALUES (1,1,'1');
15 INSERT INTO t1 VALUES (2,2,UUID());
16 CREATE TABLE t2 (a INT UNIQUE, b INT, c VARCHAR(64)) ENGINE=myisam;
17 INSERT INTO t2 VALUES (1,1,'1');
18 INSERT INTO t2 VALUES (2,2,UUID());
19 CREATE TABLE t11 (a INT NOT NULL PRIMARY KEY, b INT, c VARCHAR(64)) ENGINE=innodb;
20 INSERT INTO t11 VALUES (1,1,'1');
21 INSERT INTO t11 VALUES (2,2,UUID());
22 CREATE TABLE t12 (a INT UNIQUE, b INT, c VARCHAR(64)) ENGINE=innodb;
23 INSERT INTO t12 VALUES (1,1,'1');
24 INSERT INTO t12 VALUES (2,2,UUID());
26 CREATE VIEW v1 AS SELECT * FROM t1;
27 CREATE VIEW v11 AS SELECT * FROM t11;
28 CREATE TRIGGER t1_tr1 BEFORE INSERT ON t1 FOR EACH ROW
30 INSERT INTO t2 VALUES (NEW.a, NEW.b, NEW.c);
31 INSERT INTO t3 VALUES (NEW.a, NEW.b, NEW.c);
33 CREATE TRIGGER t1_tr2 BEFORE UPDATE ON t1 FOR EACH ROW
38 CREATE TRIGGER t11_tr1 BEFORE INSERT ON t11 FOR EACH ROW
40 INSERT INTO t12 VALUES (NEW.a, NEW.b, NEW.c);
41 INSERT INTO t13 VALUES (NEW.a, NEW.b, NEW.c);
43 CREATE TRIGGER t11_tr2 BEFORE UPDATE ON t11 FOR EACH ROW
45 UPDATE t12 SET c = '';
46 UPDATE t13 SET c = '';
48 CREATE EVENT e1 ON SCHEDULE EVERY 1 SECOND DISABLE DO
50 ALTER EVENT e1 DISABLE;
53 CREATE EVENT e11 ON SCHEDULE EVERY 1 SECOND DISABLE DO
55 ALTER EVENT e11 DISABLE;
58 CREATE FUNCTION f1 (x INT) RETURNS VARCHAR(64)
65 CREATE FUNCTION f2 (x INT) RETURNS VARCHAR(64)
69 CREATE PROCEDURE p1 (IN x INT, IN y VARCHAR(64))
71 INSERT IGNORE INTO t1 VALUES (x,x,y);
73 CREATE PROCEDURE p11 (IN x INT, IN y VARCHAR(64))
75 INSERT IGNORE INTO t11 VALUES (x,x,y);
78 CREATE TABLE t3 SELECT * FROM v1;
79 INSERT INTO t1 VALUES (3,3,'');
80 UPDATE t1 SET c='2' WHERE a = 1;
81 INSERT INTO t1 VALUES(4,4,f1(4));
82 INSERT INTO t1 VALUES (100,100,'');
84 INSERT INTO t1 VALUES (101,101,'');
85 INSERT INTO t1 VALUES(6,6,f1(6));
86 INSERT INTO t1 VALUES (102,102,'');
87 INSERT INTO t1 VALUES(7,7,f2(7));
88 INSERT INTO t1 VALUES (103,103,'');
90 CREATE TABLE t13 SELECT * FROM v11;
91 INSERT INTO t11 VALUES (3,3,'');
92 UPDATE t11 SET c='2' WHERE a = 1;
93 INSERT INTO t11 VALUES(4,4,f1(4));
94 INSERT INTO t11 VALUES (100,100,'');
96 INSERT INTO t11 VALUES (101,101,'');
97 INSERT INTO t11 VALUES(6,6,f1(6));
98 INSERT INTO t11 VALUES (102,102,'');
99 INSERT INTO t11 VALUES(7,7,f2(7));
100 INSERT INTO t11 VALUES (103,103,'');
102 SET GLOBAL EVENT_SCHEDULER = on;
103 ALTER EVENT e1 ENABLE;
104 ALTER EVENT e11 ENABLE;
105 SET GLOBAL EVENT_SCHEDULER = off;
107 SHOW TABLES LIKE 't%';
115 SELECT table_name FROM information_schema.views WHERE table_schema='test';
119 SELECT trigger_name, event_manipulation, event_object_table FROM information_schema.triggers WHERE trigger_schema='test';
120 trigger_name event_manipulation event_object_table
125 SELECT routine_type, routine_name FROM information_schema.routines WHERE routine_schema='test';
126 routine_type routine_name
131 SELECT event_name, status FROM information_schema.events WHERE event_schema='test';
136 SELECT COUNT(*) FROM t1;
139 SELECT a,b FROM t1 ORDER BY a;
153 SELECT COUNT(*) FROM t2;
156 SELECT a,b FROM t2 ORDER BY a;
170 SELECT COUNT(*) FROM t3;
173 SELECT a,b FROM t3 ORDER BY a;
187 SELECT a,b FROM v1 ORDER BY a;
201 SELECT COUNT(*) FROM t11;
204 SELECT a,b FROM t11 ORDER BY a;
218 SELECT COUNT(*) FROM t12;
221 SELECT a,b FROM t12 ORDER BY a;
235 SELECT COUNT(*) FROM t13;
238 SELECT a,b FROM t13 ORDER BY a;
252 SELECT a,b FROM v11 ORDER BY a;
267 SHOW TABLES LIKE 't%';
275 SELECT table_name FROM information_schema.views WHERE table_schema='test';
279 SELECT trigger_name, event_manipulation, event_object_table FROM information_schema.triggers WHERE trigger_schema='test';
280 trigger_name event_manipulation event_object_table
285 SELECT routine_type, routine_name FROM information_schema.routines WHERE routine_schema='test';
286 routine_type routine_name
291 SELECT event_name, status FROM information_schema.events WHERE event_schema='test';
293 e1 SLAVESIDE_DISABLED
294 e11 SLAVESIDE_DISABLED
296 SELECT COUNT(*) FROM t1;
299 SELECT a,b FROM t1 ORDER BY a;
313 SELECT COUNT(*) FROM t2;
316 SELECT a,b FROM t2 ORDER BY a;
330 SELECT COUNT(*) FROM t3;
333 SELECT a,b FROM t3 ORDER BY a;
347 SELECT a,b FROM v1 ORDER BY a;
361 SELECT COUNT(*) FROM t11;
364 SELECT a,b FROM t11 ORDER BY a;
378 SELECT COUNT(*) FROM t12;
381 SELECT a,b FROM t12 ORDER BY a;
395 SELECT COUNT(*) FROM t13;
398 SELECT a,b FROM t13 ORDER BY a;
412 SELECT a,b FROM v11 ORDER BY a;
433 ALTER TABLE t3 ORDER BY a;
434 ALTER TABLE t13 ORDER BY a;
438 DROP VIEW IF EXISTS v1,v11;
439 DROP TABLE IF EXISTS t1,t2,t3,t11,t12,t13;
440 DROP PROCEDURE IF EXISTS p1;
441 DROP PROCEDURE IF EXISTS p11;
442 DROP FUNCTION IF EXISTS f1;
443 DROP FUNCTION IF EXISTS f2;
444 DROP EVENT IF EXISTS e1;
445 DROP EVENT IF EXISTS e11;