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

     1  create account default_1 ADMIN_NAME admin IDENTIFIED BY '111111';
     2  create role role1;
     3  grant create database on account * to role1;
     4  create user user1 identified by '123456' default role role1;
     5  create role role2;
     6  grant create database on account * to role2;
     7  create user user2 identified by '123456' default role role2;
     8  create database db1;
     9  alter database db1 set mysql_compatibility_mode = '0.7.0';
    10  alter database db1 set mysql_compatibility_mode = '0.8.0';
    11  internal error: do not have privileges to alter database config
    12  drop account default_1;
    13  drop role if exists role1,role2;
    14  drop user if exists alter_user1,alter_user2,alter_user3,alter_user4;
    15  create database alter_db;
    16  use alter_db;
    17  alter database alter_db set mysql_compatibility_mode = '1.0.0';
    18  alter database alter_db set mysql_compatibility_mode = '0.8.0';
    19  drop database alter_db;
    20  create user alter_user1 identified by '123';
    21  create role role1;
    22  create role role2;
    23  grant all on account * to role1;
    24  grant all on account * to role2;
    25  grant role1 to alter_user1;
    26  create user alter_user2 identified by '123';
    27  grant role2 to alter_user2;
    28  create database alter_db1;
    29  use alter_db1;
    30  alter database alter_db1 set mysql_compatibility_mode = '0.9.0';
    31  use alter_db1;
    32  alter database alter_db1 set mysql_compatibility_mode = '0.9.1';
    33  internal error: do not have privileges to alter database config
    34  drop role role1,role2;
    35  drop user alter_user1,alter_user2;
    36  drop database alter_db1;
    37  create account alter_account ADMIN_NAME admin IDENTIFIED BY '12345';
    38  create database alter_db2;
    39  use alter_db2;
    40  alter database alter_db2 set mysql_compatibility_mode = '1.0.0';
    41  drop database alter_db2;
    42  create user alter_user3 identified by '123';
    43  create role role1;
    44  create role role2;
    45  grant all on account * to role1;
    46  grant all on account * to role2;
    47  grant role1 to alter_user3;
    48  create user alter_user4 identified by '123';
    49  grant role2 to alter_user4;
    50  create database alter_db3;
    51  use alter_db3;
    52  alter database alter_db3 set mysql_compatibility_mode = '1.1.0';
    53  use alter_db3;
    54  alter database alter_db3 set mysql_compatibility_mode = '1.0.1';
    55  internal error: do not have privileges to alter database config
    56  drop account alter_account;