49 lines
972 B
Plaintext
49 lines
972 B
Plaintext
--source include/have_binlog_format_row.inc
|
|
|
|
--disable_warnings
|
|
|
|
connection default;
|
|
|
|
create database s_db;
|
|
create user normal_1@'%' identified by 'pass';
|
|
create user normal_2@'%' identified by 'pass';
|
|
|
|
grant all on s_db.* to normal_1@'%' ;
|
|
grant all on s_db.* to normal_2@'%' ;
|
|
|
|
connect(m_normal_1, 127.0.0.1, normal_1, pass, s_db);
|
|
connect(m_normal_2, 127.0.0.1, normal_2, pass, s_db);
|
|
|
|
--echo ####################################
|
|
--echo 1.test batch and skip when first call.
|
|
--echo ####################################
|
|
|
|
connection m_normal_1;
|
|
use s_db;
|
|
create sequence s1 start with 1 maxvalue 10 increment by 1 nocache;
|
|
select nextval(s1);
|
|
select currval(s1);
|
|
drop sequence s1;
|
|
|
|
create sequence s1 start with 1 maxvalue 10 increment by 1 nocache;
|
|
select nextval(s1);
|
|
select currval(s1);
|
|
drop sequence s1;
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
disconnect m_normal_1;
|
|
disconnect m_normal_2;
|
|
|
|
connection default;
|
|
drop database s_db;
|
|
drop user normal_1@'%';
|
|
drop user normal_2@'%';
|
|
|
|
--enable_warnings
|