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

     1  # This file documents operations that are unsupported when running a SQL tenant
     2  # server.
     3  # TODO(tbg): file an issue detailing which ones are Phase 2 blockers.
     4  # LogicTest: 3node-tenant
     5  
     6  statement ok
     7  CREATE TABLE kv (k STRING PRIMARY KEY, v STRING)
     8  
     9  statement ok
    10  INSERT INTO kv VALUES ('foo', 'bar')
    11  
    12  # This isn't actually using DistSQL since it fails during planning (node liveness
    13  # and friends are missing). The work to do here for Phase 2 is to not even try
    14  # DistSQL on tenant SQL servers.
    15  query I
    16  SET distsql = on; SELECT count(*) FROM kv
    17  ----
    18  1
    19  
    20  # This works, but jobs itself will need work as it relies on node liveness and
    21  # having a NodeID.
    22  query I
    23  SELECT job_id FROM [ SHOW JOBS ] WHERE job_id = 0
    24  ----
    25  
    26  # Temp tables work, but the TemporaryObjectCleaner needs some work as it
    27  # relies on the status server.
    28  statement ok
    29  SET experimental_enable_temp_tables = true
    30  
    31  statement ok
    32  CREATE TEMP TABLE users (id UUID, city STRING, CONSTRAINT "primary" PRIMARY KEY (id ASC, city ASC))
    33  
    34  # TODO(asubiotto): Uncomment this test once
    35  # https://github.com/cockroachdb/cockroach/issues/49318 is fixed.
    36  # statement error operation is unsupported
    37  # ALTER TABLE kv CONFIGURE ZONE USING num_replicas = 123
    38  
    39  # Missing status server
    40  
    41  statement error operation is unsupported
    42  SHOW SESSIONS
    43  
    44  statement error operation is unsupported
    45  SHOW QUERIES
    46  
    47  statement error operation is unsupported
    48  CANCEL QUERY ''
    49  
    50  statement error operation is unsupported
    51  CANCEL SESSION ''
    52  
    53  statement error operation is unsupported
    54  SELECT * FROM crdb_internal.node_transactions
    55  
    56  statement error operation is unsupported
    57  SELECT * FROM crdb_internal.node_sessions
    58  
    59  statement error operation is unsupported
    60  SELECT * FROM crdb_internal.node_queries
    61  
    62  statement error operation is unsupported
    63  SELECT * FROM crdb_internal.cluster_sessions
    64  
    65  statement error operation is unsupported
    66  SELECT * FROM crdb_internal.cluster_queries
    67  
    68  statement error operation is unsupported
    69  SELECT * FROM crdb_internal.kv_store_status
    70  
    71  statement error operation is unsupported
    72  SELECT * FROM crdb_internal.kv_node_status