Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3
4 <Begin test section 1 (non deterministic SP)>
5 ---------------------------------------------
6 create table test.t1 (n MEDIUMINT NOT NULL AUTO_INCREMENT, f FLOAT, d DATETIME, PRIMARY KEY(n));
7 create procedure test.p1()
8 begin
9 INSERT INTO test.t1 (f,d) VALUES (RAND(),NOW());
10 end//
11
12 <End test section 1 (non deterministic SP)>
13 -------------------------------------------
14 CREATE TABLE test.t2 (a INT NOT NULL AUTO_INCREMENT, t CHAR(4), PRIMARY KEY(a));
15 CREATE PROCEDURE test.p2(n int)
16 begin
17 CASE n
18 WHEN 1 THEN
19 UPDATE test.t2 set t ='Tex';
20 WHEN 2 THEN
21 UPDATE test.t2 set t ='SQL';
22 ELSE
23 UPDATE test.t2 set t ='NONE';
24 END CASE;
25 end//
26 INSERT INTO test.t2 VALUES(NULL,'NEW'),(NULL,'NEW'),(NULL,'NEW'),(NULL,'NEW');
27 SELECT * FROM t2 ORDER BY a;
28 a t
29 1 NEW
30 2 NEW
31 3 NEW
32 4 NEW
33 connection slave;
34 SELECT * FROM t2 ORDER BY a;
35 a t
36 1 NEW
37 2 NEW
38 3 NEW
39 4 NEW
40 connection master;
41 call test.p2(1);
42 SELECT * FROM t2 ORDER BY a;
43 a t
44 1 Tex
45 2 Tex
46 3 Tex
47 4 Tex
48 connection slave;
49 SELECT * FROM t2 ORDER BY a;
50 a t
51 1 Tex
52 2 Tex
53 3 Tex
54 4 Tex
55 connection master;
56 call test.p2(2);
57 SELECT * FROM t2 ORDER BY a;
58 a t
59 1 SQL
60 2 SQL
61 3 SQL
62 4 SQL
63 connection slave;
64 SELECT * FROM t2 ORDER BY a;
65 a t
66 1 SQL
67 2 SQL
68 3 SQL
69 4 SQL
70 connection master;
71 call test.p2(3);
72 SELECT * FROM t2 ORDER BY a;
73 a t
74 1 NONE
75 2 NONE
76 3 NONE
77 4 NONE
78 connection slave;
79 SELECT * FROM t2 ORDER BY a;
80 a t
81 1 NONE
82 2 NONE
83 3 NONE
84 4 NONE
85 connection master;
86 DROP PROCEDURE test.p1;
87 DROP PROCEDURE test.p2;
88 DROP TABLE test.t1;
89 DROP TABLE test.t2;
90 connection slave;
91 include/rpl_end.inc