maria-developers team mailing list archive

[Yuchen Pei <yuchen.pei@xxxxxxxxxxx>]

On Wed 2023-03-15 18:19:16 +1100, Yuchen Pei wrote:

> P.S. While testing with the above, I found something buggy in the
> existing sequence implementation which I may also need to fix:
>
> create sequence s maxvalue 500;
> select next value for s; # 1
> alter sequence s cycle;
> select next value for s; # still 1 (?!)
> drop sequence s;
>

Even worse:

--8<---------------cut here---------------start------------->8---
create sequence s maxvalue 500;
select next value for s; # 1
select next value for s; # 2
alter sequence s cycle;
select next value for s; # 1
drop sequence s;
--8<---------------cut here---------------end--------------->8---

Best,
Yuchen