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

     1  drop account if exists test;
     2  create account test ADMIN_NAME 'admin' IDENTIFIED BY '111';
     3  PREPARE alter_ac_1 FROM alter account ? admin_name= ? IDENTIFIED BY ?;
     4  set @a_var = 'test';
     5  set @b_var = 'admin';
     6  set @c_var = '222';
     7  EXECUTE alter_ac_1 USING @a_var, @b_var, @c_var;
     8  DEALLOCATE PREPARE alter_ac_1;
     9  select 1;
    10  1
    11  1
    12  PREPARE alter_ac_2 FROM "alter account ? admin_name 'admin' IDENTIFIED BY ?";
    13  set @a_var = 'test';
    14  set @c_var = '333';
    15  EXECUTE alter_ac_2 USING @a_var, @c_var;
    16  DEALLOCATE PREPARE alter_ac_2;
    17  select 1;
    18  1
    19  1
    20  PREPARE alter_ac_3 FROM "alter account test admin_name 'admin' IDENTIFIED BY ?";
    21  set @c_var = '444';
    22  EXECUTE alter_ac_3 USING @c_var;
    23  DEALLOCATE PREPARE alter_ac_3;
    24  select 1;
    25  1
    26  1
    27  drop account if exists test;