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

     1  -- testcase_1:  /*! */  /* */
     2  
     3  /*!40101 -- SET @saved_cs_client = @@character_set_client */;
     4  /*!40101 -- SET character_set_client = utf8 */;
     5  /*!40000 create database if not exists mysql_ddl_test_db_5 */;
     6  /*!40000 show tables in mysql_ddl_test_db_5 */;
     7  /* this is a comment */
     8  /* and this 
     9  is also 
    10  a coment */
    11  
    12  drop database /*!40000 if exists */ mysql_ddl_test_db_1;
    13  create database /*!40000 if not exists */ mysql_ddl_test_db_1;
    14  use mysql_ddl_test_db_1;
    15  select database();
    16  
    17  
    18  
    19  drop database if exists mysql_ddl_test_db_2;
    20  create database if not exists mysql_ddl_test_db_2;
    21  use mysql_ddl_test_db_2;
    22  select database();
    23  
    24  /*!40101 use mysql_ddl_test_db_3; */ 
    25  select database();
    26  create database /* this is another comment */ if not exists mysql_ddl_test_db_3;
    27  use mysql_ddl_test_db_3;
    28  select database();
    29  
    30  -- @bvt:issue#moc 1231
    31  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' */;
    32  /*!40101 use mysql_ddl_test_db_4; */
    33  select database();
    34  -- @bvt:issue
    35  
    36  SET @MYSQLDUMP_TEMP_LOG_BIN = @@SESSION.SQL_LOG_BIN;
    37  select @MYSQLDUMP_TEMP_LOG_BIN;
    38  SET @MYSQLDUMP_TEMP_LOG_BIN = NULL;
    39  
    40  
    41  
    42  SET @@SESSION.SQL_LOG_BIN= 0;                                                                                                          
    43  select @@SESSION.SQL_LOG_BIN;
    44  
    45  SET @@GLOBAL.GTID_PURGED=/*!80000 '+'*/ '65c4c218-d343-11eb-8106-525400f4f901:1-769275';
    46  select @@GLOBAL.GTID_PURGED;
    47  
    48  /*!40103 SET TIME_ZONE='+00:00' */;
    49  select @@TIME_ZONE;
    50  
    51  SET TIME_ZONE='+08:00';
    52  select @@TIME_ZONE;
    53  SET TIME_ZONE='SYSTEM';
    54  select @@TIME_ZONE;
    55  
    56  SET @saved_cs_client = xxx;
    57  select @saved_cs_client;
    58  SET character_set_client  = xxx;
    59  select @@character_set_client;
    60  
    61  drop database if exists mysql_ddl_test_db_1;
    62  drop database if exists mysql_ddl_test_db_2;
    63  drop database if exists mysql_ddl_test_db_3;
    64  drop database if exists mysql_ddl_test_db_4;
    65  drop database if exists mysql_ddl_test_db_5;