create sequence s;

select next value for s; # 1

alter sequence s cycle;

select next value for s; # 1001, because the default cache size is 1000 and reserved_until is 1001

drop sequence s;

create sequence s as tinyint;

select next value for s;

alter sequence s maxvalue 63;

select next value for s; # error: ER_SEQUENCE_RUN_OUT, because default cache size 1000 is out of range for tiny int, and no maxvalue will work.

drop sequence s;

create sequence s;

select next value for s; # 1

flush tables;

select next value for s; # 1001

drop sequence s;

create sequence s;

select next value for s; # 1

--source include/restart_mysqld.inc

select next value for s; # 1001

drop sequence s;