[MDEV-30866] Sequences with maxvalue <= cache size resets its value on alter sequence ... cycle Created: 2023-03-16  Updated: 2023-05-02

Status: Open
Project: MariaDB Server
Component/s: Sequences
Affects Version/s: 11.0
Fix Version/s: 11.0

Type: Bug Priority: Major
Reporter: Yuchen Pei Assignee: Yuchen Pei
Resolution: Unresolved Votes: 0
Labels: None


 Description   

When creating a sequence with maxvalue no greater than the cache size, altering it with cycle will reset its value. When the sequence is created with maxvalue greater than its cache size (default 1000), altering with cycle skips the cache which is the behaviour in MDEV-30865.

d77aaa6994b 11.0

 
create sequence s maxvalue 1000;
 
select next value for s; # 1
 
select next value for s; # 2
 
alter sequence s cycle;
 
select next value for s; # 1
 
select next value for s; # 2
 
drop sequence s;
 
 
 
create sequence s maxvalue 1001;
 
select next value for s; # 1
 
select next value for s; # 2
 
alter sequence s cycle;
 
select next value for s; # 1001
 
drop sequence s;


Generated at Thu Feb 08 10:19:29 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.