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

     1  statement ok
     2  CREATE TABLE t (
     3    a INT REFERENCES t,
     4    FAMILY "primary" (a, rowid)
     5  )
     6  
     7  statement ok
     8  CREATE TABLE v (
     9    "'" INT REFERENCES t, s STRING UNIQUE REFERENCES v (s),
    10    FAMILY "primary" ("'", s, rowid)
    11  )
    12  
    13  statement ok
    14  CREATE TABLE c (
    15  	a INT NOT NULL,
    16  	b INT NULL,
    17  	INDEX c_a_b_idx (a ASC, b ASC),
    18  	FAMILY fam_0_a_rowid (a, rowid),
    19  	FAMILY fam_1_b (b)
    20  )
    21  
    22  statement ok
    23  COMMENT ON TABLE c IS 'table'
    24  
    25  statement ok
    26  COMMENT ON COLUMN c.a IS 'column'
    27  
    28  statement ok
    29  COMMENT ON INDEX c_a_b_idx IS 'index'
    30  
    31  query TTTT colnames
    32  SELECT create_statement, create_nofks, alter_statements, validate_statements FROM crdb_internal.create_statements WHERE database_name = 'test'
    33  ----
    34  create_statement  create_nofks  alter_statements  validate_statements
    35  CREATE TABLE t (
    36     a INT8 NULL,
    37     CONSTRAINT fk_a_ref_t FOREIGN KEY (a) REFERENCES t(rowid),
    38     INDEX t_auto_index_fk_a_ref_t (a ASC),
    39     FAMILY "primary" (a, rowid)
    40  )  CREATE TABLE t (
    41     a INT8 NULL,
    42     INDEX t_auto_index_fk_a_ref_t (a ASC),
    43     FAMILY "primary" (a, rowid)
    44  )  {"ALTER TABLE t ADD CONSTRAINT fk_a_ref_t FOREIGN KEY (a) REFERENCES t(rowid)"}  {"ALTER TABLE t VALIDATE CONSTRAINT fk_a_ref_t"}
    45  CREATE TABLE v (
    46     "'" INT8 NULL,
    47     s STRING NULL,
    48     CONSTRAINT "fk_'_ref_t" FOREIGN KEY ("'") REFERENCES t(rowid),
    49     CONSTRAINT fk_s_ref_v FOREIGN KEY (s) REFERENCES v(s),
    50     UNIQUE INDEX v_s_key (s ASC),
    51     INDEX "v_auto_index_fk_'_ref_t" ("'" ASC),
    52     FAMILY "primary" ("'", s, rowid)
    53  )  CREATE TABLE v (
    54     "'" INT8 NULL,
    55     s STRING NULL,
    56     UNIQUE INDEX v_s_key (s ASC),
    57     INDEX "v_auto_index_fk_'_ref_t" ("'" ASC),
    58     FAMILY "primary" ("'", s, rowid)
    59  )  {"ALTER TABLE v ADD CONSTRAINT \"fk_'_ref_t\" FOREIGN KEY (\"'\") REFERENCES t(rowid)","ALTER TABLE v ADD CONSTRAINT fk_s_ref_v FOREIGN KEY (s) REFERENCES v(s)"}  {"ALTER TABLE v VALIDATE CONSTRAINT \"fk_'_ref_t\"","ALTER TABLE v VALIDATE CONSTRAINT fk_s_ref_v"}
    60  CREATE TABLE c (
    61    a INT8 NOT NULL,
    62    b INT8 NULL,
    63    INDEX c_a_b_idx (a ASC, b ASC),
    64    FAMILY fam_0_a_rowid (a, rowid),
    65    FAMILY fam_1_b (b)
    66  );
    67  COMMENT ON TABLE c IS 'table';
    68  COMMENT ON COLUMN c.a IS 'column';
    69  COMMENT ON INDEX c_a_b_idx IS 'index'  CREATE TABLE c (
    70                                         a INT8 NOT NULL,
    71                                         b INT8 NULL,
    72                                         INDEX c_a_b_idx (a ASC, b ASC),
    73                                         FAMILY fam_0_a_rowid (a, rowid),
    74                                         FAMILY fam_1_b (b)
    75  );
    76  COMMENT ON TABLE c IS 'table';
    77  COMMENT ON COLUMN c.a IS 'column';
    78  COMMENT ON INDEX c_a_b_idx IS 'index'  {}  {}
    79  
    80  statement error invalid storage parameter "foo"
    81  CREATE TABLE a (b INT) WITH (foo=100);
    82  
    83  statement error argument of fillfactor must be type int, not type bool
    84  CREATE TABLE a (b INT) WITH (fillfactor=true);
    85  
    86  statement error unimplemented: storage parameter "toast_tuple_target"
    87  CREATE TABLE a (b INT) WITH (toast_tuple_target=100);
    88  
    89  statement ok
    90  CREATE TABLE a (b INT) WITH (fillfactor=100);