Debian Codegraph @

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