Debian Codegraph @

mysql-test/suite/rpl/t/sequence.test

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