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

     1  statement ok
     2  CREATE TABLE t (
     3    a INT,
     4    b INT
     5  )
     6  
     7  statement ok
     8  INSERT INTO t VALUES (1, 2)
     9  
    10  statement ok
    11  INSERT INTO t VALUES (1, 2)
    12  
    13  statement ok
    14  INSERT INTO t VALUES (3, 4)
    15  
    16  query II rowsort
    17  SELECT a, b FROM t
    18  ----
    19  1 2
    20  1 2
    21  3 4
    22  
    23  query I
    24  SELECT count(rowid) FROM t
    25  ----
    26  3
    27  
    28  # Make sure column order for insertion is not affected by the rowid column.
    29  
    30  statement ok
    31  ALTER TABLE t ADD c STRING
    32  
    33  statement ok
    34  INSERT INTO t VALUES (5, 6, '7')
    35  
    36  query IIT rowsort
    37  select * from t
    38  ----
    39  1 2 NULL
    40  1 2 NULL
    41  3 4 NULL
    42  5 6 7
    43  
    44  statement ok
    45  SELECT a, b, c, rowid FROM t
    46  
    47  statement ok
    48  INSERT INTO t (a, rowid) VALUES (10, 11)
    49  
    50  query I
    51  SELECT rowid FROM t WHERE a = 10
    52  ----
    53  11
    54  
    55  query TTBTTTB
    56  SHOW COLUMNS FROM t
    57  ----
    58  a      INT8    true   NULL            ·  {}         false
    59  b      INT8    true   NULL            ·  {}         false
    60  rowid  INT8    false  unique_rowid()  ·  {primary}  true
    61  c      STRING  true   NULL            ·  {}         false
    62  
    63  statement ok
    64  CREATE INDEX a_idx ON t (a)
    65  
    66  statement ok
    67  INSERT INTO t DEFAULT VALUES
    68  
    69  statement error syntax error
    70  INSERT INTO t (a, b) DEFAULT VALUES