16 Mar
2023
16 Mar
'23
3 a.m.
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