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

     1  # LogicTest: !3node-tenant
     2  query IBT colnames
     3  SELECT * FROM system.tenants ORDER BY id
     4  ----
     5  id  active  info
     6  
     7  # Create two tenants.
     8  
     9  query I
    10  SELECT crdb_internal.create_tenant(5)
    11  ----
    12  5
    13  
    14  query I
    15  SELECT crdb_internal.create_tenant(10, '{cc_id: 12345}')
    16  ----
    17  10
    18  
    19  query IBT colnames
    20  SELECT * FROM system.tenants ORDER BY id
    21  ----
    22  id  active  info
    23  5   true    NULL
    24  10  true    {cc_id: 12345}
    25  
    26  # Destroy a tenant.
    27  
    28  query I
    29  SELECT crdb_internal.destroy_tenant(5)
    30  ----
    31  5
    32  
    33  query IBT colnames
    34  SELECT * FROM system.tenants ORDER BY id
    35  ----
    36  id  active  info
    37  5   false   NULL
    38  10  true    {cc_id: 12345}
    39  
    40  # Try to recreate an existing tenant.
    41  
    42  query error pgcode 42710 tenant "5" already exists
    43  SELECT crdb_internal.create_tenant(5)
    44  
    45  query error pgcode 42710 tenant "10" already exists
    46  SELECT crdb_internal.create_tenant(10)
    47  
    48  # Try to manipulate system.tenants directly as the root user.
    49  
    50  statement error pgcode 42501 user root does not have INSERT privilege on relation tenants
    51  INSERT INTO system.tenants VALUES (15)
    52  
    53  statement error pgcode 42501 user root does not have INSERT privilege on relation tenants
    54  UPSERT INTO system.tenants VALUES (20)
    55  
    56  statement error pgcode 42501 user root does not have UPDATE privilege on relation tenants
    57  UPDATE system.tenants SET active = false WHERE id = 10
    58  
    59  statement error pgcode 42501 user root does not have DELETE privilege on relation tenants
    60  DELETE FROM system.tenants WHERE id = 10
    61  
    62  # The system tenant cannot be created or destroyed.
    63  
    64  query error pgcode 22023 cannot create tenant "1", ID assigned to system tenant
    65  SELECT crdb_internal.create_tenant(1)
    66  
    67  query error pgcode 22023 cannot destroy tenant "1", ID assigned to system tenant
    68  SELECT crdb_internal.destroy_tenant(1)
    69  
    70  # Verify that tenants are able to set in-memory cluster settings in logic tests.
    71  
    72  statement ok
    73  SET CLUSTER SETTING sql.defaults.vectorize='off'
    74  
    75  query T
    76  SHOW CLUSTER SETTING sql.defaults.vectorize
    77  ----
    78  off
    79  
    80  statement ok
    81  RESET CLUSTER SETTING sql.defaults.vectorize
    82  
    83  query T
    84  SHOW CLUSTER SETTING sql.defaults.vectorize
    85  ----
    86  on