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

     1  drop sequence if exists s1;
     2  create sequence s1 as smallint increment by -10 minvalue 30 maxvalue 100 cycle; 
     3  select * from s1;
     4  last_seq_num    min_value    max_value    start_value    increment_value    cycle    is_called    
     5  100    30    100    100    -10    true    false
     6  drop sequence if exists s1;
     7  create sequence s1 as bigint unsigned increment by -1000 maxvalue 300;
     8  select * from s1;
     9  last_seq_num    min_value    max_value    start_value    increment_value    cycle    is_called
    10  300    0    300    300    -1000    false    false
    11  drop table s1;
    12  internal error: Should use 'drop sequence' to drop a sequence
    13  show sequences;
    14  Names    Data Type
    15  s1    BIGINT UNSIGNED
    16  create sequence `序列`;
    17  select nextval('序列');
    18  nextval(序列)
    19  1
    20  select nextval('s1'), currval('s1');
    21  nextval(s1)    nextval(s1)
    22  300    300
    23  create sequence s2;
    24  create table t1(a int);
    25  insert into t1 values(nextval('s2'));
    26  select * from t1;
    27  a
    28  1
    29  drop sequence s5;
    30  no such sequence sequence.s5
    31  prepare stmt1 from 'insert into t1 values(?)';
    32  set @a_var = nextval('s2');
    33  execute stmt1 using @a_var;
    34  select * from t1;
    35  a
    36  1
    37  2