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

     1  drop database if exists test;
     2  create database test;
     3  select `variable_value` from mo_catalog.mo_mysql_compatibility_mode where dat_name ="test";
     4  alter database test set mysql_compatibility_mode = '8.0.30-MatrixOne-v0.7.0';
     5  select `variable_value` from mo_catalog.mo_mysql_compatibility_mode where dat_name ="test";
     6  drop database test;
     7  
     8  drop database if exists test;
     9  create database test;
    10  use test;
    11  select version();
    12  alter database test set mysql_compatibility_mode = '8.0.30-MatrixOne-v0.7.0';
    13  select version();
    14  drop database test;
    15  drop account if exists abc;
    16  create account abc ADMIN_NAME 'admin' IDENTIFIED BY '123456';
    17  -- @session:id=2&user=abc:admin&password=123456
    18  drop database if exists test;
    19  drop database if exists test1;
    20  create database test;
    21  create database test1;
    22  use test;
    23  select version();
    24  alter database test set mysql_compatibility_mode = '8.0.30-MatrixOne-v0.7.0';
    25  select version();
    26  use test1;
    27  select version();
    28  alter account config abc set mysql_compatibility_mode = '8.0.30-MatrixOne-v0.8.0';
    29  select version();
    30  drop database test;
    31  drop database test1;
    32  -- @session
    33  drop account abc;
    34  
    35  show global variables like 'sql_mode';
    36  create account abc ADMIN_NAME 'admin' IDENTIFIED BY '123456';
    37  -- @session:id=5&user=abc:admin&password=123456
    38  show global variables like 'sql_mode';
    39  -- @session
    40  set global sql_mode = "NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES";
    41  show global variables like 'sql_mode';
    42  -- @session:id=6&user=abc:admin&password=123456
    43  show global variables like 'sql_mode';
    44  set global sql_mode = "NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE";
    45  show global variables like 'sql_mode';
    46  -- @session
    47  show global variables like 'sql_mode';
    48  set global sql_mode = "ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES";
    49  drop account abc;
    50  
    51  SELECT @@GLOBAL.sql_mode;
    52  create account abc ADMIN_NAME 'admin' IDENTIFIED BY '123456';
    53  -- @session:id=7&user=abc:admin&password=123456
    54  SELECT @@GLOBAL.sql_mode;
    55  -- @session
    56  set global sql_mode = "STRICT_TRANS_TABLES";
    57  SELECT @@GLOBAL.sql_mode;
    58  -- @session:id=8&user=abc:admin&password=123456
    59  SELECT @@GLOBAL.sql_mode;
    60  set global sql_mode = "NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE";
    61  SELECT @@GLOBAL.sql_mode;
    62  -- @session
    63  SELECT @@GLOBAL.sql_mode;
    64  set global sql_mode = "ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES";
    65  drop account abc;