github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/cli/testdata/dump/sequence (about)

     1  sql
     2  CREATE DATABASE d;
     3  CREATE SEQUENCE d.s1 INCREMENT 123; -- test one sequence right at its minval
     4  CREATE SEQUENCE d.s2 INCREMENT 456; -- test another that's been incremented
     5  SELECT nextval('d.s2'); -- 1
     6  SELECT nextval('d.s2'); -- 457
     7  ----
     8  nextval
     9  1
    10  nextval
    11  457
    12  
    13  dump d
    14  ----
    15  ----
    16  CREATE SEQUENCE s1 MINVALUE 1 MAXVALUE 9223372036854775807 INCREMENT 123 START 1;
    17  
    18  CREATE SEQUENCE s2 MINVALUE 1 MAXVALUE 9223372036854775807 INCREMENT 456 START 1;
    19  
    20  SELECT setval('s1', 1, false);
    21  
    22  SELECT setval('s2', 913, false);
    23  ----
    24  ----
    25  
    26  sql
    27  SELECT nextval('tmp.s1');
    28  SELECT nextval('tmp.s2');
    29  ----
    30  nextval
    31  1
    32  nextval
    33  913