Debian Codegraph @

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

raw
1 include/rpl_init.inc [topology=1->2->3]
2 include/rpl_connect.inc [creating master]
3 include/rpl_connect.inc [creating slave]
4 include/rpl_connect.inc [creating slave2]
5 connection master;
6 set @@default_storage_engine="aria";
7 CREATE SEQUENCE s1 cache=10;
8 create table t1 select * from s1;
9 select NEXT VALUE for s1,seq from seq_1_to_20;
10 NEXT VALUE for s1 seq
11 1 1
12 2 2
13 3 3
14 4 4
15 5 5
16 6 6
17 7 7
18 8 8
19 9 9
20 10 10
21 11 11
22 12 12
23 13 13
24 14 14
25 15 15
26 16 16
27 17 17
28 18 18
29 19 19
30 20 20
31 insert into t1 select * from s1;
32 do setval(s1,5, 1, 0);
33 insert into t1 select * from s1;
34 do setval(s1, 5000, 1 ,0);
35 insert into t1 select * from s1;
36 alter sequence s1 minvalue=-1 start=-1 restart=-1;
37 insert into t1 select * from s1;
38 insert into s1 values(-100,-1000,9223372036854775806,1,1,1000,0,0);
39 insert into t1 select * from s1;
40 select * from t1;
41 next_not_cached_value minimum_value maximum_value start_value increment cache_size cycle_option cycle_count
42 1 1 9223372036854775806 1 1 10 0 0
43 21 1 9223372036854775806 1 1 10 0 0
44 21 1 9223372036854775806 1 1 10 0 0
45 5001 1 9223372036854775806 1 1 10 0 0
46 -1 -1 9223372036854775806 -1 1 10 0 0
47 -100 -1000 9223372036854775806 1 1 1000 0 0
48 connection slave;
49 select * from t1;
50 next_not_cached_value minimum_value maximum_value start_value increment cache_size cycle_option cycle_count
51 1 1 9223372036854775806 1 1 10 0 0
52 21 1 9223372036854775806 1 1 10 0 0
53 21 1 9223372036854775806 1 1 10 0 0
54 5001 1 9223372036854775806 1 1 10 0 0
55 -1 -1 9223372036854775806 -1 1 10 0 0
56 -100 -1000 9223372036854775806 1 1 1000 0 0
57 connection slave2;
58 select * from t1;
59 next_not_cached_value minimum_value maximum_value start_value increment cache_size cycle_option cycle_count
60 1 1 9223372036854775806 1 1 10 0 0
61 21 1 9223372036854775806 1 1 10 0 0
62 21 1 9223372036854775806 1 1 10 0 0
63 5001 1 9223372036854775806 1 1 10 0 0
64 -1 -1 9223372036854775806 -1 1 10 0 0
65 -100 -1000 9223372036854775806 1 1 1000 0 0
66 include/show_binlog_events.inc
67 Log_name Pos Event_type Server_id End_log_pos Info
68 master-bin.000001 # Gtid # # GTID #-#-#
69 master-bin.000001 # Query # # use `test`; CREATE SEQUENCE s1 cache=10
70 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
71 master-bin.000001 # Query # # use `test`; CREATE TABLE `t1` (
72 `next_not_cached_value` bigint(21) NOT NULL,
73 `minimum_value` bigint(21) NOT NULL,
74 `maximum_value` bigint(21) NOT NULL,
75 `start_value` bigint(21) NOT NULL COMMENT 'start value when sequences is created or value if RESTART is used',
76 `increment` bigint(21) NOT NULL COMMENT 'increment value',
77 `cache_size` bigint(21) unsigned NOT NULL,
78 `cycle_option` tinyint(1) unsigned NOT NULL COMMENT '0 if no cycles are allowed, 1 if the sequence should begin a new cycle when maximum_value is passed',
79 `cycle_count` bigint(21) NOT NULL COMMENT 'How many cycles have been done'
80 ) PAGE_CHECKSUM=1
81 master-bin.000001 # Annotate_rows # # create table t1 select * from s1
82 master-bin.000001 # Table_map # # table_id: # (test.t1)
83 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
84 master-bin.000001 # Query # # COMMIT
85 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
86 master-bin.000001 # Annotate_rows # # select NEXT VALUE for s1,seq from seq_1_to_20
87 master-bin.000001 # Table_map # # table_id: # (test.s1)
88 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
89 master-bin.000001 # Query # # COMMIT
90 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
91 master-bin.000001 # Annotate_rows # # insert into t1 select * from s1
92 master-bin.000001 # Table_map # # table_id: # (test.t1)
93 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
94 master-bin.000001 # Query # # COMMIT
95 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
96 master-bin.000001 # Annotate_rows # # insert into t1 select * from s1
97 master-bin.000001 # Table_map # # table_id: # (test.t1)
98 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
99 master-bin.000001 # Query # # COMMIT
100 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
101 master-bin.000001 # Annotate_rows # # do setval(s1, 5000, 1 ,0)
102 master-bin.000001 # Table_map # # table_id: # (test.s1)
103 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
104 master-bin.000001 # Query # # COMMIT
105 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
106 master-bin.000001 # Annotate_rows # # insert into t1 select * from s1
107 master-bin.000001 # Table_map # # table_id: # (test.t1)
108 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
109 master-bin.000001 # Query # # COMMIT
110 master-bin.000001 # Gtid # # GTID #-#-#
111 master-bin.000001 # Query # # use `test`; alter sequence s1 minvalue=-1 start=-1 restart=-1
112 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
113 master-bin.000001 # Annotate_rows # # insert into t1 select * from s1
114 master-bin.000001 # Table_map # # table_id: # (test.t1)
115 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
116 master-bin.000001 # Query # # COMMIT
117 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
118 master-bin.000001 # Annotate_rows # # insert into s1 values(-100,-1000,9223372036854775806,1,1,1000,0,0)
119 master-bin.000001 # Table_map # # table_id: # (test.s1)
120 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
121 master-bin.000001 # Query # # COMMIT
122 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
123 master-bin.000001 # Annotate_rows # # insert into t1 select * from s1
124 master-bin.000001 # Table_map # # table_id: # (test.t1)
125 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
126 master-bin.000001 # Query # # COMMIT
127 connection master;
128 drop table s1,t1;
129 include/rpl_end.inc