Files
oceanbase/unittest/sql/resolver/result/test_resolver_database.result
oceanbase-admin cea7de1475 init push
2021-05-31 22:56:52 +08:00

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": [
]
}