Debian Codegraph @

mysql-test/suite/rpl/r/rpl_stm_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 ==== Simple test ====
15 SELECT SQL_CALC_FOUND_ROWS * FROM t1 WHERE a > 5 ORDER BY a LIMIT 1;
16 a
17 7
18 SELECT FOUND_ROWS() INTO @a;
19 INSERT INTO logtbl VALUES(1,1,@a);
20 SELECT SQL_CALC_FOUND_ROWS * FROM t1 WHERE a < 5 ORDER BY a LIMIT 1;
21 a
22 1
23 SELECT FOUND_ROWS() INTO @a;
24 INSERT INTO logtbl VALUES(1,2,@a);
25 SELECT * FROM logtbl WHERE sect = 1 ORDER BY sect,test;
26 sect test count
27 1 1 183
28 1 2 3
29 connection slave;
30 SELECT * FROM logtbl WHERE sect = 1 ORDER BY sect,test;
31 sect test count
32 1 1 183
33 1 2 3
34 ==== Stored procedure ====
35 connection master;
36 CREATE PROCEDURE calc_and_log(sect INT, test INT) BEGIN
37 DECLARE cnt INT;
38 SELECT SQL_CALC_FOUND_ROWS * FROM t1 WHERE a < 5 ORDER BY a LIMIT 1;
39 SELECT FOUND_ROWS() INTO cnt;
40 INSERT INTO logtbl VALUES(sect,test,cnt);
41 SELECT SQL_CALC_FOUND_ROWS * FROM t1 WHERE a > 5 ORDER BY a LIMIT 1;
42 SELECT FOUND_ROWS() INTO cnt;
43 INSERT INTO logtbl VALUES(sect,test+1,cnt);
44 END $$
45 CALL calc_and_log(2,1);
46 a
47 1
48 a
49 7
50 CREATE PROCEDURE just_log(sect INT, test INT, found_rows INT) BEGIN
51 INSERT INTO logtbl VALUES (sect,test,found_rows);
52 END $$
53 SELECT SQL_CALC_FOUND_ROWS * FROM t1 WHERE a > 5 ORDER BY a LIMIT 1;
54 a
55 7
56 SELECT FOUND_ROWS() INTO @found_rows;
57 CALL just_log(2,3,@found_rows);
58 SELECT * FROM logtbl WHERE sect = 2 ORDER BY sect,test;
59 sect test count
60 2 1 3
61 2 2 183
62 2 3 183
63 connection slave;
64 SELECT * FROM logtbl WHERE sect = 2 ORDER BY sect,test;
65 sect test count
66 2 1 3
67 2 2 183
68 2 3 183
69 ==== Stored functions ====
70 connection master;
71 CREATE FUNCTION log_rows(sect INT, test INT, found_rows INT)
72 RETURNS INT
73 BEGIN
74 INSERT INTO logtbl VALUES(sect,test,found_rows);
75 RETURN found_rows;
76 END $$
77 SELECT SQL_CALC_FOUND_ROWS * FROM t1 WHERE a > 5 ORDER BY a LIMIT 1;
78 a
79 7
80 SELECT FOUND_ROWS() INTO @found_rows;
81 SELECT log_rows(3,1,@found_rows), log_rows(3,2,@found_rows);
82 log_rows(3,1,@found_rows) log_rows(3,2,@found_rows)
83 183 183
84 SELECT * FROM logtbl WHERE sect = 3 ORDER BY sect,test;
85 sect test count
86 3 1 183
87 3 2 183
88 connection slave;
89 SELECT * FROM logtbl WHERE sect = 3 ORDER BY sect,test;
90 sect test count
91 3 1 183
92 3 2 183
93 ==== Cleanup ====
94 connection master;
95 DROP TABLE t1, logtbl;
96 DROP PROCEDURE just_log;
97 DROP PROCEDURE calc_and_log;
98 DROP FUNCTION log_rows;
99 include/rpl_end.inc