Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
11.0
-
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; |