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

     1  /*!40101 -- SET @saved_cs_client = @@character_set_client */;
     2  /*!40101 -- SET character_set_client = utf8 */;
     3  /*!40000 create database if not exists mysql_ddl_test_db_5 */;
     4  /*!40000 show tables in mysql_ddl_test_db_5 */;
     5  Tables_in_mysql_ddl_test_db_5
     6  /* this is a comment */
     7  /* and this
     8  is also
     9  a coment */
    10  drop database /*!40000 if exists */ mysql_ddl_test_db_1;
    11  create database /*!40000 if not exists */ mysql_ddl_test_db_1;
    12  use mysql_ddl_test_db_1;
    13  select database();
    14  database()
    15  mysql_ddl_test_db_1
    16  drop database if exists mysql_ddl_test_db_2;
    17  create database if not exists mysql_ddl_test_db_2;
    18  use mysql_ddl_test_db_2;
    19  select database();
    20  database()
    21  mysql_ddl_test_db_2
    22  /*!40101 use mysql_ddl_test_db_3; */
    23  invalid database mysql_ddl_test_db_3
    24  select database();
    25  database()
    26  mysql_ddl_test_db_2
    27  create database /* this is another comment */ if not exists mysql_ddl_test_db_3;
    28  use mysql_ddl_test_db_3;
    29  select database();
    30  database()
    31  mysql_ddl_test_db_3
    32  CREATE DATABASE /*!32312 IF NOT EXISTS*/ `mysql_ddl_test_db_4` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
    33  [unknown result because it is related to issue#moc 1231]
    34  /*!40101 use mysql_ddl_test_db_4; */
    35  [unknown result because it is related to issue#moc 1231]
    36  select database();
    37  [unknown result because it is related to issue#moc 1231]
    38  SET @MYSQLDUMP_TEMP_LOG_BIN = @@SESSION.SQL_LOG_BIN;
    39  select @MYSQLDUMP_TEMP_LOG_BIN;
    40  @MYSQLDUMP_TEMP_LOG_BIN
    41  0
    42  SET @MYSQLDUMP_TEMP_LOG_BIN = NULL;
    43  SET @@SESSION.SQL_LOG_BIN= 0;
    44  select @@SESSION.SQL_LOG_BIN;
    45  @@SQL_LOG_BIN
    46  0
    47  SET @@GLOBAL.GTID_PURGED=/*!80000 '+'*/ '65c4c218-d343-11eb-8106-525400f4f901:1-769275';
    48  select @@GLOBAL.GTID_PURGED;
    49  internal error: can not resolve global system variable GTID_PURGED
    50  /*!40103 SET TIME_ZONE='+00:00' */;
    51  select @@TIME_ZONE;
    52  @@TIME_ZONE
    53  +00:00
    54  SET TIME_ZONE='+08:00';
    55  select @@TIME_ZONE;
    56  @@TIME_ZONE
    57  +08:00
    58  SET TIME_ZONE='SYSTEM';
    59  select @@TIME_ZONE;
    60  @@TIME_ZONE
    61  SYSTEM
    62  SET @saved_cs_client = xxx;
    63  select @saved_cs_client;
    64  @saved_cs_client
    65  xxx
    66  SET character_set_client  = xxx;
    67  select @@character_set_client;
    68  @@character_set_client
    69  xxx
    70  drop database if exists mysql_ddl_test_db_1;
    71  drop database if exists mysql_ddl_test_db_2;
    72  drop database if exists mysql_ddl_test_db_3;
    73  drop database if exists mysql_ddl_test_db_4;
    74  drop database if exists mysql_ddl_test_db_5;