~ubuntu-branches/ubuntu/wily/mysql-5.6/wily

« back to all changes in this revision

Viewing changes to mysql-test/suite/rpl/r/rpl_mix_found_rows.result

  • Committer: Package Import Robot
  • Author(s): James Page
  • Date: 2014-04-25 08:06:10 UTC
  • mfrom: (1.1.4 experimental)
  • Revision ID: package-import@ubuntu.com-20140425080610-4k2xstl3pagqvsmb
Tags: 5.6.17-1~exp1
* SECURITY UPDATE: New upstream release (Closes: #744970).
  - http://www.oracle.com/technetwork/topics/security/cpuapr2014-1972952.html
  - CVE-2014-0001
  - CVE-2014-2430
  - CVE-2014-2431
  - CVE-2014-2435
  - CVE-2014-2436
  - CVE-2014-2440
* d/p/CVE-2014-0001.patch: Dropped, included in security update.

Show diffs side-by-side

added added

removed removed

Lines of Context:
19
19
CREATE PROCEDURE just_log(sect INT, test INT) BEGIN
20
20
INSERT INTO logtbl VALUES (sect,test,FOUND_ROWS());
21
21
END $$
 
22
include/sync_slave_sql_with_master.inc
22
23
**** On Master 1 ****
23
24
SELECT SQL_CALC_FOUND_ROWS * FROM t1 WHERE a > 5 ORDER BY a LIMIT 1;
24
25
a
34
35
a
35
36
1
36
37
CALL just_log(1,3);
 
38
include/sync_slave_sql_with_master.inc
37
39
**** On Master ****
38
40
SELECT SQL_CALC_FOUND_ROWS * FROM t1 WHERE a > 5 ORDER BY a LIMIT 1;
39
41
a
40
42
7
41
43
CALL just_log(1,4);
 
44
include/sync_slave_sql_with_master.inc
42
45
SELECT * FROM logtbl WHERE sect = 1 ORDER BY sect,test;
43
46
sect    test    count
44
47
1       1       183
46
49
1       3       3
47
50
1       4       183
48
51
**** On Slave ****
 
52
include/sync_slave_sql_with_master.inc
49
53
SELECT * FROM logtbl WHERE sect = 1 ORDER BY sect,test;
50
54
sect    test    count
51
55
1       1       183
118
122
2       6       0
119
123
2       6       183
120
124
2       7       0
 
125
include/sync_slave_sql_with_master.inc
121
126
SELECT * FROM logtbl WHERE sect = 2 ORDER BY sect,test;
122
127
sect    test    count
123
128
2       1       3
135
140
DROP PROCEDURE log_me;
136
141
DROP PROCEDURE log_me_inner;
137
142
DROP FUNCTION log_rows;
 
143
include/sync_slave_sql_with_master.inc
138
144
include/rpl_end.inc