Debian Codegraph @

mysql-test/suite/rpl/r/rpl_mix_found_rows.result

raw
1 include/master-slave.inc
2 [connection master]
3 ==== Initialize ====
4 connection master;
5 CREATE TABLE t1 (a INT);
6 CREATE TABLE logtbl (sect INT, test INT, count INT);
7 INSERT INTO t1 VALUES (1),(2),(3);
8 INSERT INTO t1 SELECT 2*a+3 FROM t1;
9 INSERT INTO t1 SELECT 2*a+3 FROM t1;
10 INSERT INTO t1 SELECT 2*a+3 FROM t1;
11 INSERT INTO t1 SELECT 2*a+3 FROM t1;
12 INSERT INTO t1 SELECT 2*a+3 FROM t1;
13 INSERT INTO t1 SELECT 2*a+3 FROM t1;
14 ==== Checking a procedure ====
15 connection master;
16 CREATE PROCEDURE just_log(sect INT, test INT) BEGIN
17 INSERT INTO logtbl VALUES (sect,test,FOUND_ROWS());
18 END $$
19 connection slave;
20 connection master1;
21 SELECT SQL_CALC_FOUND_ROWS * FROM t1 WHERE a > 5 ORDER BY a LIMIT 1;
22 a
23 7
24 CALL just_log(1,1);
25 connection master;
26 SELECT SQL_CALC_FOUND_ROWS * FROM t1 WHERE a > 5 ORDER BY a LIMIT 1;
27 a
28 7
29 CALL just_log(1,2);
30 connection master1;
31 SELECT SQL_CALC_FOUND_ROWS * FROM t1 WHERE a < 5 ORDER BY a LIMIT 1;
32 a
33 1
34 CALL just_log(1,3);
35 connection slave;
36 connection master;
37 SELECT SQL_CALC_FOUND_ROWS * FROM t1 WHERE a > 5 ORDER BY a LIMIT 1;
38 a
39 7
40 CALL just_log(1,4);
41 connection slave;
42 connection master;
43 SELECT * FROM logtbl WHERE sect = 1 ORDER BY sect,test;
44 sect test count
45 1 1 183
46 1 2 183
47 1 3 3
48 1 4 183
49 connection slave;
50 SELECT * FROM logtbl WHERE sect = 1 ORDER BY sect,test;
51 sect test count
52 1 1 183
53 1 2 183
54 1 3 3
55 1 4 183
56 ==== Checking a stored function ====
57 connection master;
58 CREATE FUNCTION log_rows(sect INT, test INT)
59 RETURNS INT
60 BEGIN
61 DECLARE found_rows INT;
62 SELECT FOUND_ROWS() INTO found_rows;
63 INSERT INTO logtbl VALUES(sect,test,found_rows);
64 RETURN found_rows;
65 END $$
66 SELECT SQL_CALC_FOUND_ROWS * FROM t1 WHERE a < 5 ORDER BY a LIMIT 1;
67 a
68 1
69 SELECT log_rows(2,1), log_rows(2,2);
70 log_rows(2,1) log_rows(2,2)
71 3 3
72 CREATE TABLE t2 (a INT, b INT);
73 CREATE TRIGGER t2_tr BEFORE INSERT ON t2 FOR EACH ROW
74 BEGIN
75 INSERT INTO logtbl VALUES (NEW.a, NEW.b, FOUND_ROWS());
76 END $$
77 SELECT SQL_CALC_FOUND_ROWS * FROM t1 WHERE a < 5 ORDER BY a LIMIT 1;
78 a
79 1
80 INSERT INTO t2 VALUES (2,3), (2,4);
81 DROP TRIGGER t2_tr;
82 CREATE TRIGGER t2_tr BEFORE INSERT ON t2 FOR EACH ROW
83 BEGIN
84 DECLARE dummy INT;
85 SELECT log_rows(NEW.a, NEW.b) INTO dummy;
86 END $$
87 SELECT SQL_CALC_FOUND_ROWS * FROM t1 WHERE a > 5 ORDER BY a LIMIT 1;
88 a
89 7
90 INSERT INTO t2 VALUES (2,5), (2,6);
91 connection master;
92 DROP TRIGGER t2_tr;
93 CREATE PROCEDURE log_me_inner(sect INT, test INT)
94 BEGIN
95 DECLARE dummy INT;
96 SELECT log_rows(sect, test) INTO dummy;
97 SELECT log_rows(sect, test+1) INTO dummy;
98 END $$
99 CREATE PROCEDURE log_me(sect INT, test INT)
100 BEGIN
101 CALL log_me_inner(sect,test);
102 END $$
103 CREATE TRIGGER t2_tr BEFORE INSERT ON t2 FOR EACH ROW
104 BEGIN
105 CALL log_me(NEW.a, NEW.b);
106 END $$
107 SELECT SQL_CALC_FOUND_ROWS * FROM t1 WHERE a > 5 ORDER BY a LIMIT 1;
108 a
109 7
110 INSERT INTO t2 VALUES (2,5), (2,6);
111 SELECT * FROM logtbl WHERE sect = 2 ORDER BY sect,test;
112 sect test count
113 2 1 3
114 2 2 3
115 2 3 3
116 2 4 3
117 2 5 183
118 2 5 183
119 2 6 183
120 2 6 0
121 2 6 183
122 2 7 0
123 connection slave;
124 SELECT * FROM logtbl WHERE sect = 2 ORDER BY sect,test;
125 sect test count
126 2 1 3
127 2 2 3
128 2 3 3
129 2 4 3
130 2 5 183
131 2 5 183
132 2 6 183
133 2 6 0
134 2 6 183
135 2 7 0
136 connection master;
137 DROP TABLE t1, t2, logtbl;
138 DROP PROCEDURE just_log;
139 DROP PROCEDURE log_me;
140 DROP PROCEDURE log_me_inner;
141 DROP FUNCTION log_rows;
142 connection slave;
143 include/rpl_end.inc