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

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