github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/tenant/tenant.result (about)

     1  set global enable_privilege_cache = off;
     2  drop account if exists tenant_test;
     3  create account tenant_test admin_name = 'root' identified by '111' open comment 'tenant_test';
     4  create account tenant_test admin_name = 'root' identified by '111' open comment 'tenant_test';
     5  internal error: the tenant tenant_test exists
     6  create account if not exists tenant_test admin_name = 'root' identified by '111' open comment 'tenant_test';
     7  create account tenant_test admin_name = 'root' open comment 'tenant_test';
     8  SQL parser error: You have an error in your SQL syntax; check the manual that corresponds to your MatrixOne server version for the right syntax to use. syntax error at line 1 column 51 near " open comment 'tenant_test';";
     9  show accounts;
    10  account_name    admin_name    created    status    suspended_time    db_count    table_count    size    comment
    11  tenant_test    root    2024-02-27 12:12:51    open    null    5    57    0.0    tenant_test
    12  sys    root    2024-02-27 12:01:43    open    null    8    95    0.0    system account
    13  drop account if exists tenant_test;
    14  select account_id,relname,relkind from mo_catalog.mo_tables where reldatabase = 'mo_catalog' and relname not like '__mo_index_unique__%' order by relname;
    15  account_id    relname    relkind
    16  0    mo_account    r
    17  0    mo_cache    v
    18  0    mo_columns    r
    19  0    mo_configurations    v
    20  0    mo_database    r
    21  0    mo_foreign_keys    r
    22  0    mo_increment_columns
    23  0    mo_indexes    r
    24  0    mo_locks    v
    25  0    mo_mysql_compatibility_mode    r
    26  0    mo_pubs    r
    27  0    mo_role    r
    28  0    mo_role_grant    r
    29  0    mo_role_privs    r
    30  0    mo_sessions    v
    31  0    mo_stages    r
    32  0    mo_stored_procedure    r
    33  0    mo_snapshots    r
    34  0    mo_table_partitions    r
    35  0    mo_tables    r
    36  0    mo_transactions    v
    37  0    mo_upgrade    r
    38  0    mo_upgrade_tenant    r
    39  0    mo_user    r
    40  0    mo_user_defined_function    r
    41  0    mo_user_grant    r
    42  0    mo_variables    v
    43  0    mo_version    r
    44  set global enable_privilege_cache = on;