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

_______________________________________________
Mailing list: https://launchpad.net/~maria-developers
Post to     : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp

Reply via email to