Debian Codegraph @

mysql-test/suite/sql_sequence/slave_nextval.result

raw
1 include/master-slave.inc
2 [connection master]
3 CREATE SEQUENCE s;
4 INSERT INTO s VALUES (1,1,4,1,1,1,0,0);
5 show create sequence s;
6 Table Create Table
7 s CREATE SEQUENCE `s` start with 1 minvalue 1 maxvalue 4 increment by 1 cache 1 nocycle ENGINE=MyISAM
8 SELECT NEXTVAL(s);
9 NEXTVAL(s)
10 1
11 connection slave;
12 SELECT NEXTVAL(s);
13 NEXTVAL(s)
14 2
15 SELECT NEXTVAL(s);
16 NEXTVAL(s)
17 3
18 connection master;
19 SELECT NEXTVAL(s);
20 NEXTVAL(s)
21 2
22 SELECT NEXTVAL(s);
23 NEXTVAL(s)
24 3
25 SELECT NEXTVAL(s);
26 NEXTVAL(s)
27 4
28 select * from s;
29 next_not_cached_value minimum_value maximum_value start_value increment cache_size cycle_option cycle_count
30 5 1 4 1 1 1 0 0
31 connection slave;
32 select * from s;
33 next_not_cached_value minimum_value maximum_value start_value increment cache_size cycle_option cycle_count
34 5 1 4 1 1 1 0 0
35 connection master;
36 DROP SEQUENCE s;
37 CREATE SEQUENCE s;
38 INSERT INTO s VALUES (1,1,3,1,1,1,1,0);
39 show create sequence s;
40 Table Create Table
41 s CREATE SEQUENCE `s` start with 1 minvalue 1 maxvalue 3 increment by 1 cache 1 cycle ENGINE=MyISAM
42 SELECT NEXTVAL(s);
43 NEXTVAL(s)
44 1
45 connection slave;
46 SELECT NEXTVAL(s);
47 NEXTVAL(s)
48 2
49 SELECT NEXTVAL(s);
50 NEXTVAL(s)
51 3
52 connection master;
53 SELECT NEXTVAL(s);
54 NEXTVAL(s)
55 2
56 SELECT NEXTVAL(s);
57 NEXTVAL(s)
58 3
59 SELECT NEXTVAL(s);
60 NEXTVAL(s)
61 1
62 select * from s;
63 next_not_cached_value minimum_value maximum_value start_value increment cache_size cycle_option cycle_count
64 2 1 3 1 1 1 1 1
65 connection slave;
66 select * from s;
67 next_not_cached_value minimum_value maximum_value start_value increment cache_size cycle_option cycle_count
68 2 1 3 1 1 1 1 1
69 connection master;
70 DROP SEQUENCE s;
71 CREATE SEQUENCE s;
72 INSERT INTO s VALUES (1,1,3,1,1,1,1,0);
73 SELECT NEXTVAL(s);
74 NEXTVAL(s)
75 1
76 CREATE PROCEDURE pr(n INT)
77 BEGIN
78 DECLARE i INT DEFAULT 0;
79 WHILE i < n
80 DO
81 SELECT NEXTVAL(s);
82 SELECT NEXTVAL(s);
83 SELECT NEXTVAL(s);
84 SET i= i+1;
85 END WHILE;
86 END $
87 connect con1,localhost,root,,;
88 CALL pr(100);
89 connect con2,localhost,root,,;
90 CALL pr(100);
91 connect con3,localhost,root,,;
92 CALL pr(100);
93 connect con4,localhost,root,,;
94 CALL pr(100);
95 connect con5,localhost,root,,;
96 CALL pr(100);
97 connect con6,localhost,root,,;
98 CALL pr(100);
99 connect con7,localhost,root,,;
100 CALL pr(100);
101 connect con8,localhost,root,,;
102 CALL pr(100);
103 connection master;
104 connection slave;
105 connection master;
106 DROP SEQUENCE s;
107 DROP PROCEDURE pr;
108 include/rpl_end.inc