mysql-test/suite/sql_sequence/auto_increment.test


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

--source include/have_sequence.inc

#
# tests with auto_increment_increment and auto_increment_offset
#

set global auto_increment_increment= 2, auto_increment_offset= 2;

create sequence s start with -3 minvalue= -1000 increment 0;

select nextval(s);
select nextval(s);
flush tables;
select nextval(s);
drop sequence s;

set global auto_increment_increment= 2, auto_increment_offset= 1;

create sequence s start with -3 minvalue= -1000 increment 0;

select nextval(s);
select nextval(s);
select nextval(s);
flush tables;
select nextval(s);
drop sequence s;

# Clean up

set global auto_increment_increment= default, auto_increment_offset= default;