github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/database/config.result (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  variable_value
     5  8.0.30-MatrixOne-v1.0.0
     6  alter database test set mysql_compatibility_mode = '8.0.30-MatrixOne-v0.7.0';
     7  select `variable_value` from mo_catalog.mo_mysql_compatibility_mode where dat_name ="test";
     8  variable_value
     9  8.0.30-MatrixOne-v0.7.0
    10  drop database test;
    11  drop database if exists test;
    12  create database test;
    13  use test;
    14  select version();
    15  version()
    16  8.0.30-MatrixOne-v1.0.0
    17  alter database test set mysql_compatibility_mode = '8.0.30-MatrixOne-v0.7.0';
    18  select version();
    19  version()
    20  8.0.30-MatrixOne-v0.7.0
    21  drop database test;
    22  drop account if exists abc;
    23  create account abc ADMIN_NAME 'admin' IDENTIFIED BY '123456';
    24  drop database if exists test;
    25  drop database if exists test1;
    26  create database test;
    27  create database test1;
    28  use test;
    29  select version();
    30  version()
    31  8.0.30-MatrixOne-v1.0.0
    32  alter database test set mysql_compatibility_mode = '8.0.30-MatrixOne-v0.7.0';
    33  select version();
    34  version()
    35  8.0.30-MatrixOne-v0.7.0
    36  use test1;
    37  select version();
    38  version()
    39  8.0.30-MatrixOne-v1.0.0
    40  alter account config abc set mysql_compatibility_mode = '8.0.30-MatrixOne-v0.8.0';
    41  internal error: do not have privileges to alter account config
    42  select version();
    43  version()
    44  8.0.30-MatrixOne-v1.0.0
    45  drop database test;
    46  drop database test1;
    47  drop account abc;
    48  show global variables like 'sql_mode';
    49  Variable_name    Value
    50  sql_mode    ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES
    51  create account abc ADMIN_NAME 'admin' IDENTIFIED BY '123456';
    52  show global variables like 'sql_mode';
    53  Variable_name    Value
    54  sql_mode    ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES
    55  set global sql_mode = "NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES";
    56  show global variables like 'sql_mode';
    57  Variable_name    Value
    58  sql_mode    NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES
    59  show global variables like 'sql_mode';
    60  Variable_name    Value
    61  sql_mode    ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES
    62  set global sql_mode = "NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE";
    63  show global variables like 'sql_mode';
    64  Variable_name    Value
    65  sql_mode    NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE
    66  show global variables like 'sql_mode';
    67  Variable_name    Value
    68  sql_mode    NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES
    69  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";
    70  drop account abc;
    71  SELECT @@GLOBAL.sql_mode;
    72  @@sql_mode
    73  ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES
    74  create account abc ADMIN_NAME 'admin' IDENTIFIED BY '123456';
    75  SELECT @@GLOBAL.sql_mode;
    76  @@sql_mode
    77  ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES
    78  set global sql_mode = "STRICT_TRANS_TABLES";
    79  SELECT @@GLOBAL.sql_mode;
    80  @@sql_mode
    81  STRICT_TRANS_TABLES
    82  SELECT @@GLOBAL.sql_mode;
    83  @@sql_mode
    84  ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES
    85  set global sql_mode = "NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE";
    86  SELECT @@GLOBAL.sql_mode;
    87  @@sql_mode
    88  NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE
    89  SELECT @@GLOBAL.sql_mode;
    90  @@sql_mode
    91  STRICT_TRANS_TABLES
    92  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";
    93  drop account abc;