mirror of
https://github.com/MariaDB/server.git
synced 2025-02-04 21:02:17 +01:00
9854fb6fa7
This patch adds for "--ps-protocol" second execution of queries "SELECT". Also in this patch it is added ability to disable/enable (--disable_ps2_protocol/--enable_ps2_protocol) second execution for "--ps-prototocol" in testcases.
54 lines
1.3 KiB
Text
54 lines
1.3 KiB
Text
#
|
|
# 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
|