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

     1  begin;
     2  select sleep(10);
     3  sleep(10)
     4  0
     5  select count(*) > 0 from mo_sessions() t;
     6  count(*) > 0
     7  true
     8  select count(*) > 0 from mo_sessions() as t where txn_id != '';
     9  count(*) > 0
    10  true
    11  select count(*) > 0  from mo_transactions() t join mo_sessions() s on t.txn_id = s.txn_id;
    12  count(*) > 0
    13  true
    14  commit;
    15  select count(*) > 0 from mo_cache() c;
    16  count(*) > 0
    17  true
    18  select count(*) >0 from mo_configurations() t;
    19  count(*) > 0
    20  true
    21  select count(*) >0 from mo_configurations() t where node_type = 'cn';
    22  count(*) > 0
    23  true
    24  select distinct node_type,default_value  from mo_configurations() t where  name like '%frontend.port';
    25  node_type    default_value
    26  cn    6001
    27  select count(*) > 0  from mo_configurations() t where internal = 'advanced';
    28  count(*) > 0
    29  true
    30  select count(*) > 0 from mo_catalog.mo_variables;
    31  count(*) > 0
    32  true
    33  select variable_value from mo_catalog.mo_variables where variable_name = 'port' and account_name = 'sys';
    34  variable_value
    35  6001