github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/sequence/seq_func.sql (about)

     1  -- drop sequence not supported yet, use drop table instead first.
     2  drop sequence if exists s1;
     3  create sequence s1 as smallint increment by -40 minvalue 30 maxvalue 100 cycle; 
     4  select nextval('s1');
     5  select nextval('s1');
     6  select nextval('s1');
     7  select currval('s1');
     8  select lastval();
     9  select setval('s1', 50);
    10  select lastval();
    11  select nextval('s1');