Debian Codegraph @

mysql-test/suite/sql_sequence/slave_nextval.test

raw
1 --source include/master-slave.inc
2 --source include/have_binlog_format_row.inc
3
4 #
5 # MDEV-14092 NEXTVAL() fails on slave
6 #
7
8 --disable_ps2_protocol
9 CREATE SEQUENCE s;
10 INSERT INTO s VALUES (1,1,4,1,1,1,0,0);
11 show create sequence s;
12 SELECT NEXTVAL(s);
13
14 --sync_slave_with_master
15 SELECT NEXTVAL(s);
16 SELECT NEXTVAL(s);
17
18 --connection master
19 SELECT NEXTVAL(s);
20 SELECT NEXTVAL(s);
21 SELECT NEXTVAL(s);
22
23 select * from s;
24
25 --sync_slave_with_master
26
27 select * from s;
28 --connection master
29 DROP SEQUENCE s;
30
31 #
32 # Same as above, but with cycles
33 #
34
35 CREATE SEQUENCE s;
36 INSERT INTO s VALUES (1,1,3,1,1,1,1,0);
37 show create sequence s;
38 SELECT NEXTVAL(s);
39
40 --sync_slave_with_master
41 SELECT NEXTVAL(s);
42 SELECT NEXTVAL(s);
43
44 --connection master
45 SELECT NEXTVAL(s);
46 SELECT NEXTVAL(s);
47 SELECT NEXTVAL(s);
48
49 select * from s;
50
51 --sync_slave_with_master
52
53 select * from s;
54
55 --connection master
56 DROP SEQUENCE s;
57
58 # Here is a bit more complicated concurrent scenario that
59 # causes the same effect without any updates on the slave. You might
60 # need to replace 100 with a bigger value if it doesn't happen on your
61 # machine right away.
62
63 CREATE SEQUENCE s;
64 INSERT INTO s VALUES (1,1,3,1,1,1,1,0);
65 SELECT NEXTVAL(s);
66
67 --delimiter $
68 CREATE PROCEDURE pr(n INT)
69 BEGIN
70 DECLARE i INT DEFAULT 0;
71 WHILE i < n
72 DO
73 SELECT NEXTVAL(s);
74 SELECT NEXTVAL(s);
75 SELECT NEXTVAL(s);
76 SET i= i+1;
77 END WHILE;
78 END $
79 --delimiter ;
80
81 --connect (con1,localhost,root,,)
82 --send CALL pr(100)
83 --connect (con2,localhost,root,,)
84 --send CALL pr(100)
85 --connect (con3,localhost,root,,)
86 --send CALL pr(100)
87 --connect (con4,localhost,root,,)
88 --send CALL pr(100)
89 --connect (con5,localhost,root,,)
90 --send CALL pr(100)
91 --connect (con6,localhost,root,,)
92 --send CALL pr(100)
93 --connect (con7,localhost,root,,)
94 --send CALL pr(100)
95 --connect (con8,localhost,root,,)
96 --send CALL pr(100)
97
98
99 --disable_query_log
100 --disable_result_log
101
102 --connection con1
103 --reap
104 --connection con2
105 --reap
106 --connection con3
107 --reap
108 --connection con4
109 --reap
110 --connection con5
111 --reap
112 --connection con6
113 --reap
114 --connection con7
115 --reap
116 --connection con8
117 --reap
118
119 --enable_query_log
120 --enable_result_log
121
122 --connection master
123
124 --sync_slave_with_master
125
126 --connection master
127 DROP SEQUENCE s;
128 DROP PROCEDURE pr;
129 --enable_ps2_protocol
130
131 #
132 # Cleanup
133 #
134 --source include/rpl_end.inc