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

     1  -- @suite
     2  -- @setup
     3  drop database if exists test01;
     4  drop database if exists test03;
     5  drop database if exists test04;
     6  drop database if exists test05;
     7  drop database if exists `测试数据库`;
     8  drop database if exists t01234567890123456789012345678901234567890123456789012345678901234567890123456789;
     9  
    10  -- @case
    11  -- @desc:test for create database
    12  -- @label:bvt
    13  create database test01;
    14  create database IF NOT EXISTS test01;
    15  -- @case
    16  -- @desc:test for create database with chinese name
    17  -- @label:bvt
    18  create database `测试数据库`;
    19  -- @case
    20  -- @desc:test for create database with utf-8 charset
    21  -- @label:bvt
    22  #create database test03 default character set utf8 collate utf8_general_ci encryption 'Y';
    23  #create database test04 character set=utf8 collate=utf8_general_ci encryption='N';
    24  -- @case
    25  -- @desc:test for create database with too long name
    26  -- @label:bvt
    27  create database t01234567890123456789012345678901234567890123456789012345678901234567890123456789;
    28  
    29  -- @case
    30  -- @desc:test for show database
    31  -- @label:bvt
    32  show databases;
    33  drop database if exists test01;
    34  drop database if exists test03;
    35  drop database if exists test04;
    36  drop database if exists test05;
    37  drop database if exists `测试数据库`;
    38  drop database if exists t01234567890123456789012345678901234567890123456789012345678901234567890123456789;
    39  drop database if exists `TPCH_0.01G`;
    40  create database if not exists `TPCH_0.01G`;
    41  use `TPCH_0.01G`;
    42  drop database if exists `TPCH_0.01G`;
    43  drop database if exists db1;
    44  create database if not exists db1;
    45  show schemas;
    46  drop database if exists db1;