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

     1  select current_account_name();
     2  select current_account_id();
     3  select current_user_name();
     4  select current_user_id();
     5  select current_role_name();
     6  select current_role_id();
     7  select * from current_account() as t;
     8  
     9  drop account if exists abc;
    10  create account abc ADMIN_NAME 'admin' IDENTIFIED BY '123456';
    11  -- @session:id=1&user=abc:admin&password=123456
    12  drop role if exists test_role;
    13  create role test_role;
    14  grant test_role to admin;
    15  set role test_role;
    16  
    17  select current_account_name();
    18  -- account_id is auto_increment column, execute current_account_id() function return result error;
    19  -- select current_account_id();
    20  select current_user_name();
    21  select current_user_id();
    22  select current_role_name();
    23  -- select * from current_account() as t;
    24  -- @session
    25  drop account if exists abc;