| 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 |