mirror of
https://github.com/MariaDB/server.git
synced 2025-11-03 20:36:16 +01:00
7aa80ba66b
This also fixes MDEV-16313 Assertion `next_free_value % real_increment == offset' fails upon CREATE SEQUENCE in galera cluster Fixed by adding llabs() to assert. Also adjusted auto_increment_offset to mod auto_increment_increment.
30 lines
627 B
Text
30 lines
627 B
Text
set global auto_increment_increment= 2, auto_increment_offset= 2;
|
|
create sequence s start with -3 minvalue= -1000 increment 0;
|
|
select nextval(s);
|
|
nextval(s)
|
|
-2
|
|
select nextval(s);
|
|
nextval(s)
|
|
0
|
|
flush tables;
|
|
select nextval(s);
|
|
nextval(s)
|
|
1998
|
|
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);
|
|
nextval(s)
|
|
-3
|
|
select nextval(s);
|
|
nextval(s)
|
|
-1
|
|
select nextval(s);
|
|
nextval(s)
|
|
1
|
|
flush tables;
|
|
select nextval(s);
|
|
nextval(s)
|
|
1997
|
|
drop sequence s;
|
|
set global auto_increment_increment= default, auto_increment_offset= default;
|