Debian Codegraph @

mysql-test/suite/engines/funcs/r/rpl_row_sp011.result

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 DROP PROCEDURE IF EXISTS test.p1;
5 DROP PROCEDURE IF EXISTS test.p2;
6 DROP PROCEDURE IF EXISTS test.p3;
7 DROP PROCEDURE IF EXISTS test.p4;
8 DROP PROCEDURE IF EXISTS test.p5;
9 DROP PROCEDURE IF EXISTS test.p6;
10 DROP PROCEDURE IF EXISTS test.p7;
11 DROP TABLE IF EXISTS test.t1;
12 DROP TABLE IF EXISTS test.t2;
13 CREATE TABLE test.t1 (a int, PRIMARY KEY(a));
14 INSERT INTO test.t1 VALUES (1);
15 CREATE PROCEDURE test.p1()
16 BEGIN
17 ALTER TABLE test.t1 ADD COLUMN b CHAR(4) AFTER a;
18 UPDATE test.t1 SET b = 'rbr' WHERE a = 1;
19 CALL test.p2();
20 END|
21 CREATE PROCEDURE test.p2()
22 BEGIN
23 ALTER TABLE test.t1 ADD COLUMN f FLOAT AFTER b;
24 UPDATE test.t1 SET f = RAND() WHERE a = 1;
25 CALL test.p3();
26 END|
27 CREATE PROCEDURE test.p3()
28 BEGIN
29 ALTER TABLE test.t1 RENAME test.t2;
30 CALL test.p4();
31 END|
32 CREATE PROCEDURE test.p4()
33 BEGIN
34 ALTER TABLE test.t2 ADD INDEX (f);
35 ALTER TABLE test.t2 CHANGE a a INT UNSIGNED NOT NULL AUTO_INCREMENT;
36 INSERT INTO test.t2 VALUES (NULL,'TEST',RAND());
37 CALL test.p5();
38 END|
39 CREATE PROCEDURE test.p5()
40 BEGIN
41 ALTER TABLE test.t2 ORDER BY f;
42 INSERT INTO test.t2 VALUES (NULL,'STM',RAND());
43 CALL test.p6();
44 END|
45 CREATE PROCEDURE test.p6()
46 BEGIN
47 ALTER TABLE test.t2 ADD COLUMN b2 CHAR(4) FIRST;
48 ALTER TABLE test.t2 ADD COLUMN to_drop BIT(8) AFTER b2;
49 INSERT INTO test.t2 VALUES ('new',1,NULL,'STM',RAND());
50 CALL test.p7();
51 END|
52 CREATE PROCEDURE test.p7()
53 BEGIN
54 ALTER TABLE test.t2 DROP COLUMN to_drop;
55 INSERT INTO test.t2 VALUES ('gone',NULL,'STM',RAND());
56 END|
57 CALL test.p1();
58 connection slave;
59 connection master;
60 DROP PROCEDURE IF EXISTS test.p1;
61 DROP PROCEDURE IF EXISTS test.p2;
62 DROP PROCEDURE IF EXISTS test.p3;
63 DROP PROCEDURE IF EXISTS test.p4;
64 DROP PROCEDURE IF EXISTS test.p5;
65 DROP PROCEDURE IF EXISTS test.p6;
66 DROP PROCEDURE IF EXISTS test.p7;
67 DROP TABLE IF EXISTS test.t1;
68 DROP TABLE IF EXISTS test.t2;
69 connection slave;
70 include/rpl_end.inc