1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
|
#
# Testing sequences with replication
#
--source include/have_binlog_format_row.inc
--source include/have_aria.inc
--source include/have_sequence.inc
--let $rpl_topology= 1->2->3
--source include/rpl_init.inc
--let $rpl_connection_name= master
--let $rpl_server_number= 1
--source include/rpl_connect.inc
--let $rpl_connection_name= slave
--let $rpl_server_number= 2
--source include/rpl_connect.inc
--let $rpl_connection_name= slave2
--let $rpl_server_number= 3
--source include/rpl_connect.inc
--connection master
set @@default_storage_engine="aria";
CREATE SEQUENCE s1 cache=10;
create table t1 select * from s1;
--disable_ps2_protocol
select NEXT VALUE for s1,seq from seq_1_to_20;
--enable_ps2_protocol
insert into t1 select * from s1;
do setval(s1,5, 1, 0);
insert into t1 select * from s1;
do setval(s1, 5000, 1 ,0);
insert into t1 select * from s1;
alter sequence s1 minvalue=-1 start=-1 restart=-1;
insert into t1 select * from s1;
insert into s1 values(-100,-1000,9223372036854775806,1,1,1000,0,0);
insert into t1 select * from s1;
select * from t1;
--sync_slave_with_master
select * from t1;
--sync_slave_with_master slave2
select * from t1;
--let $binlog_file = LAST
source include/show_binlog_events.inc;
connection master;
drop table s1,t1;
--source include/rpl_end.inc
|
