187 lines
4.3 KiB
Plaintext
187 lines
4.3 KiB
Plaintext
*************** Case 1 ***************
|
|
drop database if exists database_test;
|
|
{
|
|
"drop_database_arg":"tenant_id",
|
|
"database_name":"database_test",
|
|
"if_exist":true,
|
|
"to_recyclebin":false
|
|
}
|
|
*************** Case 2 ***************
|
|
create database if not exists database_test;
|
|
{
|
|
"create_database_arg":"database_schema",
|
|
"database_id":-1,
|
|
"schema_version":1,
|
|
"database_name":"database_test",
|
|
"replica_num":0,
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"charset_type":2,
|
|
"collation_type":"utf8mb4_general_ci",
|
|
"name_case_mode":-1,
|
|
"comment":"",
|
|
"read_only":false,
|
|
"default_tablegroup_id":-1,
|
|
"default_tablegroup_name":"",
|
|
"in_recyclebin":false,
|
|
"primary_zone_array": [
|
|
]
|
|
}
|
|
*************** Case 3 ***************
|
|
alter database database_test CHARACTER SET UTF8;
|
|
{
|
|
"alter_database_arg":"database_schema",
|
|
"database_id":-1,
|
|
"schema_version":1,
|
|
"database_name":"database_test",
|
|
"replica_num":0,
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"charset_type":2,
|
|
"collation_type":"invalid_type",
|
|
"name_case_mode":-1,
|
|
"comment":"",
|
|
"read_only":false,
|
|
"default_tablegroup_id":-1,
|
|
"default_tablegroup_name":"",
|
|
"in_recyclebin":false,
|
|
"primary_zone_array": [
|
|
]
|
|
}
|
|
*************** Case 4 ***************
|
|
alter database database_test collate utf8mb4_general_ci;
|
|
{
|
|
"alter_database_arg":"database_schema",
|
|
"database_id":-1,
|
|
"schema_version":1,
|
|
"database_name":"database_test",
|
|
"replica_num":0,
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"charset_type":0,
|
|
"collation_type":"utf8mb4_general_ci",
|
|
"name_case_mode":-1,
|
|
"comment":"",
|
|
"read_only":false,
|
|
"default_tablegroup_id":-1,
|
|
"default_tablegroup_name":"",
|
|
"in_recyclebin":false,
|
|
"primary_zone_array": [
|
|
]
|
|
}
|
|
*************** Case 5 ***************
|
|
alter database database_test CHARACTER SET UTF8 collate utf8mb4_general_ci;
|
|
{
|
|
"alter_database_arg":"database_schema",
|
|
"database_id":-1,
|
|
"schema_version":1,
|
|
"database_name":"database_test",
|
|
"replica_num":0,
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"charset_type":2,
|
|
"collation_type":"utf8mb4_general_ci",
|
|
"name_case_mode":-1,
|
|
"comment":"",
|
|
"read_only":false,
|
|
"default_tablegroup_id":-1,
|
|
"default_tablegroup_name":"",
|
|
"in_recyclebin":false,
|
|
"primary_zone_array": [
|
|
]
|
|
}
|
|
*************** Case 6 ***************
|
|
drop database database_test;
|
|
{
|
|
"drop_database_arg":"tenant_id",
|
|
"database_name":"database_test",
|
|
"if_exist":false,
|
|
"to_recyclebin":false
|
|
}
|
|
*************** Case 7 ***************
|
|
create database database_test CHARACTER SET UTF8;
|
|
{
|
|
"create_database_arg":"database_schema",
|
|
"database_id":-1,
|
|
"schema_version":1,
|
|
"database_name":"database_test",
|
|
"replica_num":0,
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"charset_type":2,
|
|
"collation_type":"invalid_type",
|
|
"name_case_mode":-1,
|
|
"comment":"",
|
|
"read_only":false,
|
|
"default_tablegroup_id":-1,
|
|
"default_tablegroup_name":"",
|
|
"in_recyclebin":false,
|
|
"primary_zone_array": [
|
|
]
|
|
}
|
|
*************** Case 8 ***************
|
|
drop database database_test;
|
|
{
|
|
"drop_database_arg":"tenant_id",
|
|
"database_name":"database_test",
|
|
"if_exist":false,
|
|
"to_recyclebin":false
|
|
}
|
|
*************** Case 9 ***************
|
|
create database database_test collate utf8mb4_general_ci;
|
|
{
|
|
"create_database_arg":"database_schema",
|
|
"database_id":-1,
|
|
"schema_version":1,
|
|
"database_name":"database_test",
|
|
"replica_num":0,
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"charset_type":0,
|
|
"collation_type":"utf8mb4_general_ci",
|
|
"name_case_mode":-1,
|
|
"comment":"",
|
|
"read_only":false,
|
|
"default_tablegroup_id":-1,
|
|
"default_tablegroup_name":"",
|
|
"in_recyclebin":false,
|
|
"primary_zone_array": [
|
|
]
|
|
}
|
|
*************** Case 10 ***************
|
|
drop database database_test;
|
|
{
|
|
"drop_database_arg":"tenant_id",
|
|
"database_name":"database_test",
|
|
"if_exist":false,
|
|
"to_recyclebin":false
|
|
}
|
|
*************** Case 11 ***************
|
|
create database database_test CHARACTER SET UTF8 collate utf8mb4_general_ci;
|
|
{
|
|
"create_database_arg":"database_schema",
|
|
"database_id":-1,
|
|
"schema_version":1,
|
|
"database_name":"database_test",
|
|
"replica_num":0,
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"charset_type":2,
|
|
"collation_type":"utf8mb4_general_ci",
|
|
"name_case_mode":-1,
|
|
"comment":"",
|
|
"read_only":false,
|
|
"default_tablegroup_id":-1,
|
|
"default_tablegroup_name":"",
|
|
"in_recyclebin":false,
|
|
"primary_zone_array": [
|
|
]
|
|
}
|