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

     1  create sequence alter_seq_01 as smallint increment by 2 minvalue 30 maxvalue 100 cycle;
     2  select * from alter_seq_01;
     3  last_seq_num    min_value    max_value    start_value    increment_value    cycle    is_called
     4  30    30    100    30    2    true    false
     5  alter sequence alter_seq_02 no cycle;
     6  invalid input: no such sequence alter_seq_02
     7  alter sequence alter_seq_01 no cycle;
     8  select * from alter_seq_01;
     9  last_seq_num    min_value    max_value    start_value    increment_value    cycle    is_called
    10  30    30    100    30    2    false    false
    11  alter sequence alter_seq_01 as bigint;
    12  select * from alter_seq_01;
    13  last_seq_num    min_value    max_value    start_value    increment_value    cycle    is_called
    14  30    30    100    30    2    false    false
    15  alter sequence alter_seq_01 as tinyint;
    16  not supported: Unsupported type for sequence
    17  select * from alter_seq_01;
    18  last_seq_num    min_value    max_value    start_value    increment_value    cycle    is_called
    19  30    30    100    30    2    false    false
    20  alter sequence alter_seq_01 increment by 3;
    21  select * from alter_seq_01;
    22  last_seq_num    min_value    max_value    start_value    increment_value    cycle    is_called
    23  30    30    100    30    3    false    false
    24  alter sequence alter_seq_01 start with 40;
    25  select * from alter_seq_01;
    26  last_seq_num    min_value    max_value    start_value    increment_value    cycle    is_called
    27  30    30    100    40    3    false    false
    28  alter sequence alter_seq_01 minvalue 10;
    29  select * from alter_seq_01;
    30  last_seq_num    min_value    max_value    start_value    increment_value    cycle    is_called
    31  30    10    100    30    3    false    false
    32  alter sequence alter_seq_01 maxvalue 1000;
    33  select * from alter_seq_01;
    34  last_seq_num    min_value    max_value    start_value    increment_value    cycle    is_called
    35  30    10    1000    30    3    false    false
    36  alter sequence alter_seq_01 minvalue 10000 maxvalue 10;
    37  invalid input: MAXVALUE (10) of sequence must be bigger than MINVALUE (10000) of it
    38  alter sequence alter_seq_01 minvalue 1 maxvalue 1000000000 cycle;
    39  select * from alter_seq_01;
    40  last_seq_num    min_value    max_value    start_value    increment_value    cycle    is_called
    41  30    1    1000000000    30    3    true    false
    42  drop sequence alter_seq_01;