github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/logictest/testdata/logic_test/alter_sequence (about)

     1  # see also file `sequences`
     2  
     3  statement ok
     4  CREATE SEQUENCE foo
     5  
     6  query I
     7  SELECT nextval('foo')
     8  ----
     9  1
    10  
    11  query I
    12  SELECT nextval('foo')
    13  ----
    14  2
    15  
    16  statement ok
    17  ALTER SEQUENCE foo INCREMENT BY 5
    18  
    19  query I
    20  SELECT nextval('foo')
    21  ----
    22  7