5470 lines
139 KiB
Plaintext
5470 lines
139 KiB
Plaintext
*************** Case 1 ***************
|
|
drop database if exists defaultvalue;
|
|
{
|
|
"drop_database_arg":"tenant_id",
|
|
"database_name":"defaultvalue",
|
|
"if_exist":true,
|
|
"to_recyclebin":false
|
|
}
|
|
*************** Case 2 ***************
|
|
create database defaultvalue;
|
|
{
|
|
"create_database_arg":"database_schema",
|
|
"database_id":-1,
|
|
"schema_version":1,
|
|
"database_name":"defaultvalue",
|
|
"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 ***************
|
|
use defaultvalue;
|
|
{
|
|
"stmt_type":97
|
|
}
|
|
*************** Case 4 ***************
|
|
drop table if exists default_t1;
|
|
{
|
|
"stmt_type":21,
|
|
"drop_table_arg": {
|
|
"tenant_id":1,
|
|
"table_type":3,
|
|
"tables": [
|
|
{
|
|
"database_name":"defaultvalue",
|
|
"table_name":"default_t1"
|
|
}
|
|
],
|
|
"if_exist":true,
|
|
"to_recyclebin":false,
|
|
"session_id":-1,
|
|
"sess_create_time":0
|
|
}
|
|
}
|
|
*************** Case 5 ***************
|
|
create table if not exists default_t1 (a int, b int primary key);
|
|
{"ObTableStmt":{"partition_fun_expr":[], "range_values_exprs":[], "list_values_exprs":[], "index_partition_resolve_results":[], "part_type":8}, "stmt_type":20, "create_table_arg":{"if_not_exist":true, "schema":{"simple_table_schema":{"tenant_id":1, "database_id":18446744073709551615, "tablegroup_id":1099511627777, "table_id":18446744073709551615, "table_name":"default_t1", "replica_num":0, "previous_locality_str":"", "min_partition_id":0, "session_id":0, "index_type":0, "table_type":3, "data_table_id":0, "name_casemode":-1, "schema_version":0, "part_level":0, "part_option":{"part_func_type":0, "part_func_expr":"", "part_num":1, "partition_cnt_within_partition_table":-1, "max_used_part_id":0}, "sub_part_option":{"part_func_type":0, "part_func_expr":"", "part_num":1, "partition_cnt_within_partition_table":-1, "max_used_part_id":-1}, "locality_str":"", "zone_list":[], "primary_zone":"", "part_num":0, "subpart_num":0, "partition_num":1, "subpartition_num":0, "partition_array":[{"BasePartition":{"tenant_id":18446744073709551615, "table_id":18446744073709551615, "part_id":0, "name":"p0", "high_bound_val":, "list_row_values":[], "part_idx":0}, "mapping_pg_part_id":-1}], "subpartition_array":null, "index_status":1, "binding":false, "duplicate_scope":0}, "max_used_column_id":17, "max_used_constraint_id":0, "sess_active_time":0, "rowkey_column_num":1, "index_column_num":0, "rowkey_split_pos":0, "block_size":16384, "is_use_bloomfilter":false, "progressive_merge_num":0, "tablet_size":134217728, "pctfree":10, "load_type":0, "index_using_type":0, "def_type":1, "charset_type":2, "collation_type":45, "create_mem_version":0, "index_status":1, "partition_status":0, "code_version":1, "last_modified_frozen_version":0, "comment":"", "pk_comment":"", "create_host":"", "zone_replica_attr_array":[], "region_replica_num_array":[], "tablegroup_name":"", "compress_func_name":"zstd_1.0", "row_store_type":1, "store_format":3, "expire_info":"", "view_schema":{"view_definition":"", "check_option":"none", "is_updatable":"false", "is_materialized":"false"}, "autoinc_column_id":0, "auto_increment":1, "read_only":false, "primary_zone_array":[], "index_tid_array":[], "mv_tid_array":[], "aux_vp_tid_array":[], "base_table_ids":[], "rowkey_info":{"columns":[{"length":0, "column_id":17, "type":{"type":"INT", "collation":"binary", "coercibility":"NUMERIC"}, "order":0, "fulltext_flag":false}], "capacity":1}, "partition_key_info":{"columns":null, "capacity":0}, "aux_vp_tid_array":[]}, "index_arg_list":[], "constraint_list":[], "db_name":"defaultvalue", "last_replay_log_id":0, "foreign_key_arg_list":[], "vertical_partition_arg_list":[]}, "index_arg_list":[]}
|
|
*************** Case 6 ***************
|
|
ALTER TABLE default_t1 ADD i1 int;
|
|
{
|
|
"ObTableStmt": {
|
|
"partition_fun_expr": [
|
|
],
|
|
"range_values_exprs": [
|
|
],
|
|
"list_values_exprs": [
|
|
],
|
|
"index_partition_resolve_results": [
|
|
],
|
|
"part_type":8
|
|
},
|
|
"stmt_type":22,
|
|
"alter_table_arg": {
|
|
"is_alter_columns":true,
|
|
"is_alter_indexs":false,
|
|
"is_alter_options":false,
|
|
"session_id":-1,
|
|
"index_arg_list": [
|
|
],
|
|
"alter_table_schema": {
|
|
"alter_type":"OB_INVALID_DDL_OP",
|
|
"origin_table_name":"default_t1",
|
|
"new_database_name":"defaultvalue",
|
|
"origin_database_name":"defaultvalue",
|
|
"split_partition_name":"",
|
|
"alter_table_schema": {
|
|
"simple_table_schema": {
|
|
"tenant_id":1,
|
|
"database_id":-1,
|
|
"tablegroup_id":-1,
|
|
"table_id":-1,
|
|
"table_name":"default_t1",
|
|
"replica_num":0,
|
|
"previous_locality_str":"",
|
|
"min_partition_id":0,
|
|
"session_id":0,
|
|
"index_type":0,
|
|
"table_type":3,
|
|
"data_table_id":0,
|
|
"name_casemode":-1,
|
|
"schema_version":0,
|
|
"part_level":0,
|
|
"part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"sub_part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"locality_str":"",
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"part_num":0,
|
|
"subpart_num":0,
|
|
"partition_num":0,
|
|
"subpartition_num":0,
|
|
"partition_array":null,
|
|
"subpartition_array":null,
|
|
"index_status":1,
|
|
"binding":false,
|
|
"duplicate_scope":0
|
|
},
|
|
"max_used_column_id":0,
|
|
"max_used_constraint_id":0,
|
|
"sess_active_time":0,
|
|
"rowkey_column_num":0,
|
|
"index_column_num":0,
|
|
"rowkey_split_pos":0,
|
|
"block_size":16384,
|
|
"is_use_bloomfilter":false,
|
|
"progressive_merge_num":0,
|
|
"tablet_size":-1,
|
|
"pctfree":10,
|
|
"load_type":0,
|
|
"index_using_type":0,
|
|
"def_type":1,
|
|
"charset_type":0,
|
|
"collation_type":0,
|
|
"create_mem_version":0,
|
|
"index_status":1,
|
|
"partition_status":0,
|
|
"code_version":1,
|
|
"last_modified_frozen_version":0,
|
|
"comment":"",
|
|
"pk_comment":"",
|
|
"create_host":"",
|
|
"zone_replica_attr_array": [
|
|
],
|
|
"region_replica_num_array": [
|
|
],
|
|
"tablegroup_name":"",
|
|
"compress_func_name":"",
|
|
"row_store_type":3,
|
|
"store_format":0,
|
|
"expire_info":"",
|
|
"view_schema": {
|
|
"view_definition":"",
|
|
"check_option":"none",
|
|
"is_updatable":"false",
|
|
"is_materialized":"false"
|
|
},
|
|
"autoinc_column_id":0,
|
|
"auto_increment":1,
|
|
"read_only":false,
|
|
"primary_zone_array": [
|
|
],
|
|
"index_tid_array": [
|
|
],
|
|
"mv_tid_array": [
|
|
],
|
|
"aux_vp_tid_array": [
|
|
],
|
|
"base_table_ids": [
|
|
],
|
|
"rowkey_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"partition_key_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"aux_vp_tid_array": [
|
|
]
|
|
}
|
|
},
|
|
"nls_formats": [
|
|
"",
|
|
"",
|
|
""
|
|
]
|
|
},
|
|
"index_arg_list": [
|
|
]
|
|
}
|
|
*************** Case 7 ***************
|
|
ALTER TABLE default_t1 ADD i2 int not null;
|
|
{
|
|
"ObTableStmt": {
|
|
"partition_fun_expr": [
|
|
],
|
|
"range_values_exprs": [
|
|
],
|
|
"list_values_exprs": [
|
|
],
|
|
"index_partition_resolve_results": [
|
|
],
|
|
"part_type":8
|
|
},
|
|
"stmt_type":22,
|
|
"alter_table_arg": {
|
|
"is_alter_columns":true,
|
|
"is_alter_indexs":false,
|
|
"is_alter_options":false,
|
|
"session_id":-1,
|
|
"index_arg_list": [
|
|
],
|
|
"alter_table_schema": {
|
|
"alter_type":"OB_INVALID_DDL_OP",
|
|
"origin_table_name":"default_t1",
|
|
"new_database_name":"defaultvalue",
|
|
"origin_database_name":"defaultvalue",
|
|
"split_partition_name":"",
|
|
"alter_table_schema": {
|
|
"simple_table_schema": {
|
|
"tenant_id":1,
|
|
"database_id":-1,
|
|
"tablegroup_id":-1,
|
|
"table_id":-1,
|
|
"table_name":"default_t1",
|
|
"replica_num":0,
|
|
"previous_locality_str":"",
|
|
"min_partition_id":0,
|
|
"session_id":0,
|
|
"index_type":0,
|
|
"table_type":3,
|
|
"data_table_id":0,
|
|
"name_casemode":-1,
|
|
"schema_version":0,
|
|
"part_level":0,
|
|
"part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"sub_part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"locality_str":"",
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"part_num":0,
|
|
"subpart_num":0,
|
|
"partition_num":0,
|
|
"subpartition_num":0,
|
|
"partition_array":null,
|
|
"subpartition_array":null,
|
|
"index_status":1,
|
|
"binding":false,
|
|
"duplicate_scope":0
|
|
},
|
|
"max_used_column_id":0,
|
|
"max_used_constraint_id":0,
|
|
"sess_active_time":0,
|
|
"rowkey_column_num":0,
|
|
"index_column_num":0,
|
|
"rowkey_split_pos":0,
|
|
"block_size":16384,
|
|
"is_use_bloomfilter":false,
|
|
"progressive_merge_num":0,
|
|
"tablet_size":-1,
|
|
"pctfree":10,
|
|
"load_type":0,
|
|
"index_using_type":0,
|
|
"def_type":1,
|
|
"charset_type":0,
|
|
"collation_type":0,
|
|
"create_mem_version":0,
|
|
"index_status":1,
|
|
"partition_status":0,
|
|
"code_version":1,
|
|
"last_modified_frozen_version":0,
|
|
"comment":"",
|
|
"pk_comment":"",
|
|
"create_host":"",
|
|
"zone_replica_attr_array": [
|
|
],
|
|
"region_replica_num_array": [
|
|
],
|
|
"tablegroup_name":"",
|
|
"compress_func_name":"",
|
|
"row_store_type":3,
|
|
"store_format":0,
|
|
"expire_info":"",
|
|
"view_schema": {
|
|
"view_definition":"",
|
|
"check_option":"none",
|
|
"is_updatable":"false",
|
|
"is_materialized":"false"
|
|
},
|
|
"autoinc_column_id":0,
|
|
"auto_increment":1,
|
|
"read_only":false,
|
|
"primary_zone_array": [
|
|
],
|
|
"index_tid_array": [
|
|
],
|
|
"mv_tid_array": [
|
|
],
|
|
"aux_vp_tid_array": [
|
|
],
|
|
"base_table_ids": [
|
|
],
|
|
"rowkey_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"partition_key_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"aux_vp_tid_array": [
|
|
]
|
|
}
|
|
},
|
|
"nls_formats": [
|
|
"",
|
|
"",
|
|
""
|
|
]
|
|
},
|
|
"index_arg_list": [
|
|
]
|
|
}
|
|
*************** Case 8 ***************
|
|
ALTER TABLE default_t1 ADD i3 int not null default 5;
|
|
{
|
|
"ObTableStmt": {
|
|
"partition_fun_expr": [
|
|
],
|
|
"range_values_exprs": [
|
|
],
|
|
"list_values_exprs": [
|
|
],
|
|
"index_partition_resolve_results": [
|
|
],
|
|
"part_type":8
|
|
},
|
|
"stmt_type":22,
|
|
"alter_table_arg": {
|
|
"is_alter_columns":true,
|
|
"is_alter_indexs":false,
|
|
"is_alter_options":false,
|
|
"session_id":-1,
|
|
"index_arg_list": [
|
|
],
|
|
"alter_table_schema": {
|
|
"alter_type":"OB_INVALID_DDL_OP",
|
|
"origin_table_name":"default_t1",
|
|
"new_database_name":"defaultvalue",
|
|
"origin_database_name":"defaultvalue",
|
|
"split_partition_name":"",
|
|
"alter_table_schema": {
|
|
"simple_table_schema": {
|
|
"tenant_id":1,
|
|
"database_id":-1,
|
|
"tablegroup_id":-1,
|
|
"table_id":-1,
|
|
"table_name":"default_t1",
|
|
"replica_num":0,
|
|
"previous_locality_str":"",
|
|
"min_partition_id":0,
|
|
"session_id":0,
|
|
"index_type":0,
|
|
"table_type":3,
|
|
"data_table_id":0,
|
|
"name_casemode":-1,
|
|
"schema_version":0,
|
|
"part_level":0,
|
|
"part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"sub_part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"locality_str":"",
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"part_num":0,
|
|
"subpart_num":0,
|
|
"partition_num":0,
|
|
"subpartition_num":0,
|
|
"partition_array":null,
|
|
"subpartition_array":null,
|
|
"index_status":1,
|
|
"binding":false,
|
|
"duplicate_scope":0
|
|
},
|
|
"max_used_column_id":0,
|
|
"max_used_constraint_id":0,
|
|
"sess_active_time":0,
|
|
"rowkey_column_num":0,
|
|
"index_column_num":0,
|
|
"rowkey_split_pos":0,
|
|
"block_size":16384,
|
|
"is_use_bloomfilter":false,
|
|
"progressive_merge_num":0,
|
|
"tablet_size":-1,
|
|
"pctfree":10,
|
|
"load_type":0,
|
|
"index_using_type":0,
|
|
"def_type":1,
|
|
"charset_type":0,
|
|
"collation_type":0,
|
|
"create_mem_version":0,
|
|
"index_status":1,
|
|
"partition_status":0,
|
|
"code_version":1,
|
|
"last_modified_frozen_version":0,
|
|
"comment":"",
|
|
"pk_comment":"",
|
|
"create_host":"",
|
|
"zone_replica_attr_array": [
|
|
],
|
|
"region_replica_num_array": [
|
|
],
|
|
"tablegroup_name":"",
|
|
"compress_func_name":"",
|
|
"row_store_type":3,
|
|
"store_format":0,
|
|
"expire_info":"",
|
|
"view_schema": {
|
|
"view_definition":"",
|
|
"check_option":"none",
|
|
"is_updatable":"false",
|
|
"is_materialized":"false"
|
|
},
|
|
"autoinc_column_id":0,
|
|
"auto_increment":1,
|
|
"read_only":false,
|
|
"primary_zone_array": [
|
|
],
|
|
"index_tid_array": [
|
|
],
|
|
"mv_tid_array": [
|
|
],
|
|
"aux_vp_tid_array": [
|
|
],
|
|
"base_table_ids": [
|
|
],
|
|
"rowkey_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"partition_key_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"aux_vp_tid_array": [
|
|
]
|
|
}
|
|
},
|
|
"nls_formats": [
|
|
"",
|
|
"",
|
|
""
|
|
]
|
|
},
|
|
"index_arg_list": [
|
|
]
|
|
}
|
|
*************** Case 9 ***************
|
|
ALTER TABLE default_t1 ADD f1 float;
|
|
{
|
|
"ObTableStmt": {
|
|
"partition_fun_expr": [
|
|
],
|
|
"range_values_exprs": [
|
|
],
|
|
"list_values_exprs": [
|
|
],
|
|
"index_partition_resolve_results": [
|
|
],
|
|
"part_type":8
|
|
},
|
|
"stmt_type":22,
|
|
"alter_table_arg": {
|
|
"is_alter_columns":true,
|
|
"is_alter_indexs":false,
|
|
"is_alter_options":false,
|
|
"session_id":-1,
|
|
"index_arg_list": [
|
|
],
|
|
"alter_table_schema": {
|
|
"alter_type":"OB_INVALID_DDL_OP",
|
|
"origin_table_name":"default_t1",
|
|
"new_database_name":"defaultvalue",
|
|
"origin_database_name":"defaultvalue",
|
|
"split_partition_name":"",
|
|
"alter_table_schema": {
|
|
"simple_table_schema": {
|
|
"tenant_id":1,
|
|
"database_id":-1,
|
|
"tablegroup_id":-1,
|
|
"table_id":-1,
|
|
"table_name":"default_t1",
|
|
"replica_num":0,
|
|
"previous_locality_str":"",
|
|
"min_partition_id":0,
|
|
"session_id":0,
|
|
"index_type":0,
|
|
"table_type":3,
|
|
"data_table_id":0,
|
|
"name_casemode":-1,
|
|
"schema_version":0,
|
|
"part_level":0,
|
|
"part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"sub_part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"locality_str":"",
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"part_num":0,
|
|
"subpart_num":0,
|
|
"partition_num":0,
|
|
"subpartition_num":0,
|
|
"partition_array":null,
|
|
"subpartition_array":null,
|
|
"index_status":1,
|
|
"binding":false,
|
|
"duplicate_scope":0
|
|
},
|
|
"max_used_column_id":0,
|
|
"max_used_constraint_id":0,
|
|
"sess_active_time":0,
|
|
"rowkey_column_num":0,
|
|
"index_column_num":0,
|
|
"rowkey_split_pos":0,
|
|
"block_size":16384,
|
|
"is_use_bloomfilter":false,
|
|
"progressive_merge_num":0,
|
|
"tablet_size":-1,
|
|
"pctfree":10,
|
|
"load_type":0,
|
|
"index_using_type":0,
|
|
"def_type":1,
|
|
"charset_type":0,
|
|
"collation_type":0,
|
|
"create_mem_version":0,
|
|
"index_status":1,
|
|
"partition_status":0,
|
|
"code_version":1,
|
|
"last_modified_frozen_version":0,
|
|
"comment":"",
|
|
"pk_comment":"",
|
|
"create_host":"",
|
|
"zone_replica_attr_array": [
|
|
],
|
|
"region_replica_num_array": [
|
|
],
|
|
"tablegroup_name":"",
|
|
"compress_func_name":"",
|
|
"row_store_type":3,
|
|
"store_format":0,
|
|
"expire_info":"",
|
|
"view_schema": {
|
|
"view_definition":"",
|
|
"check_option":"none",
|
|
"is_updatable":"false",
|
|
"is_materialized":"false"
|
|
},
|
|
"autoinc_column_id":0,
|
|
"auto_increment":1,
|
|
"read_only":false,
|
|
"primary_zone_array": [
|
|
],
|
|
"index_tid_array": [
|
|
],
|
|
"mv_tid_array": [
|
|
],
|
|
"aux_vp_tid_array": [
|
|
],
|
|
"base_table_ids": [
|
|
],
|
|
"rowkey_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"partition_key_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"aux_vp_tid_array": [
|
|
]
|
|
}
|
|
},
|
|
"nls_formats": [
|
|
"",
|
|
"",
|
|
""
|
|
]
|
|
},
|
|
"index_arg_list": [
|
|
]
|
|
}
|
|
*************** Case 10 ***************
|
|
ALTER TABLE default_t1 ADD f2 float not null;
|
|
{
|
|
"ObTableStmt": {
|
|
"partition_fun_expr": [
|
|
],
|
|
"range_values_exprs": [
|
|
],
|
|
"list_values_exprs": [
|
|
],
|
|
"index_partition_resolve_results": [
|
|
],
|
|
"part_type":8
|
|
},
|
|
"stmt_type":22,
|
|
"alter_table_arg": {
|
|
"is_alter_columns":true,
|
|
"is_alter_indexs":false,
|
|
"is_alter_options":false,
|
|
"session_id":-1,
|
|
"index_arg_list": [
|
|
],
|
|
"alter_table_schema": {
|
|
"alter_type":"OB_INVALID_DDL_OP",
|
|
"origin_table_name":"default_t1",
|
|
"new_database_name":"defaultvalue",
|
|
"origin_database_name":"defaultvalue",
|
|
"split_partition_name":"",
|
|
"alter_table_schema": {
|
|
"simple_table_schema": {
|
|
"tenant_id":1,
|
|
"database_id":-1,
|
|
"tablegroup_id":-1,
|
|
"table_id":-1,
|
|
"table_name":"default_t1",
|
|
"replica_num":0,
|
|
"previous_locality_str":"",
|
|
"min_partition_id":0,
|
|
"session_id":0,
|
|
"index_type":0,
|
|
"table_type":3,
|
|
"data_table_id":0,
|
|
"name_casemode":-1,
|
|
"schema_version":0,
|
|
"part_level":0,
|
|
"part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"sub_part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"locality_str":"",
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"part_num":0,
|
|
"subpart_num":0,
|
|
"partition_num":0,
|
|
"subpartition_num":0,
|
|
"partition_array":null,
|
|
"subpartition_array":null,
|
|
"index_status":1,
|
|
"binding":false,
|
|
"duplicate_scope":0
|
|
},
|
|
"max_used_column_id":0,
|
|
"max_used_constraint_id":0,
|
|
"sess_active_time":0,
|
|
"rowkey_column_num":0,
|
|
"index_column_num":0,
|
|
"rowkey_split_pos":0,
|
|
"block_size":16384,
|
|
"is_use_bloomfilter":false,
|
|
"progressive_merge_num":0,
|
|
"tablet_size":-1,
|
|
"pctfree":10,
|
|
"load_type":0,
|
|
"index_using_type":0,
|
|
"def_type":1,
|
|
"charset_type":0,
|
|
"collation_type":0,
|
|
"create_mem_version":0,
|
|
"index_status":1,
|
|
"partition_status":0,
|
|
"code_version":1,
|
|
"last_modified_frozen_version":0,
|
|
"comment":"",
|
|
"pk_comment":"",
|
|
"create_host":"",
|
|
"zone_replica_attr_array": [
|
|
],
|
|
"region_replica_num_array": [
|
|
],
|
|
"tablegroup_name":"",
|
|
"compress_func_name":"",
|
|
"row_store_type":3,
|
|
"store_format":0,
|
|
"expire_info":"",
|
|
"view_schema": {
|
|
"view_definition":"",
|
|
"check_option":"none",
|
|
"is_updatable":"false",
|
|
"is_materialized":"false"
|
|
},
|
|
"autoinc_column_id":0,
|
|
"auto_increment":1,
|
|
"read_only":false,
|
|
"primary_zone_array": [
|
|
],
|
|
"index_tid_array": [
|
|
],
|
|
"mv_tid_array": [
|
|
],
|
|
"aux_vp_tid_array": [
|
|
],
|
|
"base_table_ids": [
|
|
],
|
|
"rowkey_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"partition_key_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"aux_vp_tid_array": [
|
|
]
|
|
}
|
|
},
|
|
"nls_formats": [
|
|
"",
|
|
"",
|
|
""
|
|
]
|
|
},
|
|
"index_arg_list": [
|
|
]
|
|
}
|
|
*************** Case 11 ***************
|
|
ALTER TABLE default_t1 ADD f3 float not null default 5.0;
|
|
{
|
|
"ObTableStmt": {
|
|
"partition_fun_expr": [
|
|
],
|
|
"range_values_exprs": [
|
|
],
|
|
"list_values_exprs": [
|
|
],
|
|
"index_partition_resolve_results": [
|
|
],
|
|
"part_type":8
|
|
},
|
|
"stmt_type":22,
|
|
"alter_table_arg": {
|
|
"is_alter_columns":true,
|
|
"is_alter_indexs":false,
|
|
"is_alter_options":false,
|
|
"session_id":-1,
|
|
"index_arg_list": [
|
|
],
|
|
"alter_table_schema": {
|
|
"alter_type":"OB_INVALID_DDL_OP",
|
|
"origin_table_name":"default_t1",
|
|
"new_database_name":"defaultvalue",
|
|
"origin_database_name":"defaultvalue",
|
|
"split_partition_name":"",
|
|
"alter_table_schema": {
|
|
"simple_table_schema": {
|
|
"tenant_id":1,
|
|
"database_id":-1,
|
|
"tablegroup_id":-1,
|
|
"table_id":-1,
|
|
"table_name":"default_t1",
|
|
"replica_num":0,
|
|
"previous_locality_str":"",
|
|
"min_partition_id":0,
|
|
"session_id":0,
|
|
"index_type":0,
|
|
"table_type":3,
|
|
"data_table_id":0,
|
|
"name_casemode":-1,
|
|
"schema_version":0,
|
|
"part_level":0,
|
|
"part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"sub_part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"locality_str":"",
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"part_num":0,
|
|
"subpart_num":0,
|
|
"partition_num":0,
|
|
"subpartition_num":0,
|
|
"partition_array":null,
|
|
"subpartition_array":null,
|
|
"index_status":1,
|
|
"binding":false,
|
|
"duplicate_scope":0
|
|
},
|
|
"max_used_column_id":0,
|
|
"max_used_constraint_id":0,
|
|
"sess_active_time":0,
|
|
"rowkey_column_num":0,
|
|
"index_column_num":0,
|
|
"rowkey_split_pos":0,
|
|
"block_size":16384,
|
|
"is_use_bloomfilter":false,
|
|
"progressive_merge_num":0,
|
|
"tablet_size":-1,
|
|
"pctfree":10,
|
|
"load_type":0,
|
|
"index_using_type":0,
|
|
"def_type":1,
|
|
"charset_type":0,
|
|
"collation_type":0,
|
|
"create_mem_version":0,
|
|
"index_status":1,
|
|
"partition_status":0,
|
|
"code_version":1,
|
|
"last_modified_frozen_version":0,
|
|
"comment":"",
|
|
"pk_comment":"",
|
|
"create_host":"",
|
|
"zone_replica_attr_array": [
|
|
],
|
|
"region_replica_num_array": [
|
|
],
|
|
"tablegroup_name":"",
|
|
"compress_func_name":"",
|
|
"row_store_type":3,
|
|
"store_format":0,
|
|
"expire_info":"",
|
|
"view_schema": {
|
|
"view_definition":"",
|
|
"check_option":"none",
|
|
"is_updatable":"false",
|
|
"is_materialized":"false"
|
|
},
|
|
"autoinc_column_id":0,
|
|
"auto_increment":1,
|
|
"read_only":false,
|
|
"primary_zone_array": [
|
|
],
|
|
"index_tid_array": [
|
|
],
|
|
"mv_tid_array": [
|
|
],
|
|
"aux_vp_tid_array": [
|
|
],
|
|
"base_table_ids": [
|
|
],
|
|
"rowkey_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"partition_key_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"aux_vp_tid_array": [
|
|
]
|
|
}
|
|
},
|
|
"nls_formats": [
|
|
"",
|
|
"",
|
|
""
|
|
]
|
|
},
|
|
"index_arg_list": [
|
|
]
|
|
}
|
|
*************** Case 12 ***************
|
|
ALTER TABLE default_t1 ADD d1 double;
|
|
{
|
|
"ObTableStmt": {
|
|
"partition_fun_expr": [
|
|
],
|
|
"range_values_exprs": [
|
|
],
|
|
"list_values_exprs": [
|
|
],
|
|
"index_partition_resolve_results": [
|
|
],
|
|
"part_type":8
|
|
},
|
|
"stmt_type":22,
|
|
"alter_table_arg": {
|
|
"is_alter_columns":true,
|
|
"is_alter_indexs":false,
|
|
"is_alter_options":false,
|
|
"session_id":-1,
|
|
"index_arg_list": [
|
|
],
|
|
"alter_table_schema": {
|
|
"alter_type":"OB_INVALID_DDL_OP",
|
|
"origin_table_name":"default_t1",
|
|
"new_database_name":"defaultvalue",
|
|
"origin_database_name":"defaultvalue",
|
|
"split_partition_name":"",
|
|
"alter_table_schema": {
|
|
"simple_table_schema": {
|
|
"tenant_id":1,
|
|
"database_id":-1,
|
|
"tablegroup_id":-1,
|
|
"table_id":-1,
|
|
"table_name":"default_t1",
|
|
"replica_num":0,
|
|
"previous_locality_str":"",
|
|
"min_partition_id":0,
|
|
"session_id":0,
|
|
"index_type":0,
|
|
"table_type":3,
|
|
"data_table_id":0,
|
|
"name_casemode":-1,
|
|
"schema_version":0,
|
|
"part_level":0,
|
|
"part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"sub_part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"locality_str":"",
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"part_num":0,
|
|
"subpart_num":0,
|
|
"partition_num":0,
|
|
"subpartition_num":0,
|
|
"partition_array":null,
|
|
"subpartition_array":null,
|
|
"index_status":1,
|
|
"binding":false,
|
|
"duplicate_scope":0
|
|
},
|
|
"max_used_column_id":0,
|
|
"max_used_constraint_id":0,
|
|
"sess_active_time":0,
|
|
"rowkey_column_num":0,
|
|
"index_column_num":0,
|
|
"rowkey_split_pos":0,
|
|
"block_size":16384,
|
|
"is_use_bloomfilter":false,
|
|
"progressive_merge_num":0,
|
|
"tablet_size":-1,
|
|
"pctfree":10,
|
|
"load_type":0,
|
|
"index_using_type":0,
|
|
"def_type":1,
|
|
"charset_type":0,
|
|
"collation_type":0,
|
|
"create_mem_version":0,
|
|
"index_status":1,
|
|
"partition_status":0,
|
|
"code_version":1,
|
|
"last_modified_frozen_version":0,
|
|
"comment":"",
|
|
"pk_comment":"",
|
|
"create_host":"",
|
|
"zone_replica_attr_array": [
|
|
],
|
|
"region_replica_num_array": [
|
|
],
|
|
"tablegroup_name":"",
|
|
"compress_func_name":"",
|
|
"row_store_type":3,
|
|
"store_format":0,
|
|
"expire_info":"",
|
|
"view_schema": {
|
|
"view_definition":"",
|
|
"check_option":"none",
|
|
"is_updatable":"false",
|
|
"is_materialized":"false"
|
|
},
|
|
"autoinc_column_id":0,
|
|
"auto_increment":1,
|
|
"read_only":false,
|
|
"primary_zone_array": [
|
|
],
|
|
"index_tid_array": [
|
|
],
|
|
"mv_tid_array": [
|
|
],
|
|
"aux_vp_tid_array": [
|
|
],
|
|
"base_table_ids": [
|
|
],
|
|
"rowkey_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"partition_key_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"aux_vp_tid_array": [
|
|
]
|
|
}
|
|
},
|
|
"nls_formats": [
|
|
"",
|
|
"",
|
|
""
|
|
]
|
|
},
|
|
"index_arg_list": [
|
|
]
|
|
}
|
|
*************** Case 13 ***************
|
|
ALTER TABLE default_t1 ADD d2 double not null;
|
|
{
|
|
"ObTableStmt": {
|
|
"partition_fun_expr": [
|
|
],
|
|
"range_values_exprs": [
|
|
],
|
|
"list_values_exprs": [
|
|
],
|
|
"index_partition_resolve_results": [
|
|
],
|
|
"part_type":8
|
|
},
|
|
"stmt_type":22,
|
|
"alter_table_arg": {
|
|
"is_alter_columns":true,
|
|
"is_alter_indexs":false,
|
|
"is_alter_options":false,
|
|
"session_id":-1,
|
|
"index_arg_list": [
|
|
],
|
|
"alter_table_schema": {
|
|
"alter_type":"OB_INVALID_DDL_OP",
|
|
"origin_table_name":"default_t1",
|
|
"new_database_name":"defaultvalue",
|
|
"origin_database_name":"defaultvalue",
|
|
"split_partition_name":"",
|
|
"alter_table_schema": {
|
|
"simple_table_schema": {
|
|
"tenant_id":1,
|
|
"database_id":-1,
|
|
"tablegroup_id":-1,
|
|
"table_id":-1,
|
|
"table_name":"default_t1",
|
|
"replica_num":0,
|
|
"previous_locality_str":"",
|
|
"min_partition_id":0,
|
|
"session_id":0,
|
|
"index_type":0,
|
|
"table_type":3,
|
|
"data_table_id":0,
|
|
"name_casemode":-1,
|
|
"schema_version":0,
|
|
"part_level":0,
|
|
"part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"sub_part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"locality_str":"",
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"part_num":0,
|
|
"subpart_num":0,
|
|
"partition_num":0,
|
|
"subpartition_num":0,
|
|
"partition_array":null,
|
|
"subpartition_array":null,
|
|
"index_status":1,
|
|
"binding":false,
|
|
"duplicate_scope":0
|
|
},
|
|
"max_used_column_id":0,
|
|
"max_used_constraint_id":0,
|
|
"sess_active_time":0,
|
|
"rowkey_column_num":0,
|
|
"index_column_num":0,
|
|
"rowkey_split_pos":0,
|
|
"block_size":16384,
|
|
"is_use_bloomfilter":false,
|
|
"progressive_merge_num":0,
|
|
"tablet_size":-1,
|
|
"pctfree":10,
|
|
"load_type":0,
|
|
"index_using_type":0,
|
|
"def_type":1,
|
|
"charset_type":0,
|
|
"collation_type":0,
|
|
"create_mem_version":0,
|
|
"index_status":1,
|
|
"partition_status":0,
|
|
"code_version":1,
|
|
"last_modified_frozen_version":0,
|
|
"comment":"",
|
|
"pk_comment":"",
|
|
"create_host":"",
|
|
"zone_replica_attr_array": [
|
|
],
|
|
"region_replica_num_array": [
|
|
],
|
|
"tablegroup_name":"",
|
|
"compress_func_name":"",
|
|
"row_store_type":3,
|
|
"store_format":0,
|
|
"expire_info":"",
|
|
"view_schema": {
|
|
"view_definition":"",
|
|
"check_option":"none",
|
|
"is_updatable":"false",
|
|
"is_materialized":"false"
|
|
},
|
|
"autoinc_column_id":0,
|
|
"auto_increment":1,
|
|
"read_only":false,
|
|
"primary_zone_array": [
|
|
],
|
|
"index_tid_array": [
|
|
],
|
|
"mv_tid_array": [
|
|
],
|
|
"aux_vp_tid_array": [
|
|
],
|
|
"base_table_ids": [
|
|
],
|
|
"rowkey_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"partition_key_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"aux_vp_tid_array": [
|
|
]
|
|
}
|
|
},
|
|
"nls_formats": [
|
|
"",
|
|
"",
|
|
""
|
|
]
|
|
},
|
|
"index_arg_list": [
|
|
]
|
|
}
|
|
*************** Case 14 ***************
|
|
ALTER TABLE default_t1 ADD d3 double not null default 5.0000
|
|
{
|
|
"ObTableStmt": {
|
|
"partition_fun_expr": [
|
|
],
|
|
"range_values_exprs": [
|
|
],
|
|
"list_values_exprs": [
|
|
],
|
|
"index_partition_resolve_results": [
|
|
],
|
|
"part_type":8
|
|
},
|
|
"stmt_type":22,
|
|
"alter_table_arg": {
|
|
"is_alter_columns":true,
|
|
"is_alter_indexs":false,
|
|
"is_alter_options":false,
|
|
"session_id":-1,
|
|
"index_arg_list": [
|
|
],
|
|
"alter_table_schema": {
|
|
"alter_type":"OB_INVALID_DDL_OP",
|
|
"origin_table_name":"default_t1",
|
|
"new_database_name":"defaultvalue",
|
|
"origin_database_name":"defaultvalue",
|
|
"split_partition_name":"",
|
|
"alter_table_schema": {
|
|
"simple_table_schema": {
|
|
"tenant_id":1,
|
|
"database_id":-1,
|
|
"tablegroup_id":-1,
|
|
"table_id":-1,
|
|
"table_name":"default_t1",
|
|
"replica_num":0,
|
|
"previous_locality_str":"",
|
|
"min_partition_id":0,
|
|
"session_id":0,
|
|
"index_type":0,
|
|
"table_type":3,
|
|
"data_table_id":0,
|
|
"name_casemode":-1,
|
|
"schema_version":0,
|
|
"part_level":0,
|
|
"part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"sub_part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"locality_str":"",
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"part_num":0,
|
|
"subpart_num":0,
|
|
"partition_num":0,
|
|
"subpartition_num":0,
|
|
"partition_array":null,
|
|
"subpartition_array":null,
|
|
"index_status":1,
|
|
"binding":false,
|
|
"duplicate_scope":0
|
|
},
|
|
"max_used_column_id":0,
|
|
"max_used_constraint_id":0,
|
|
"sess_active_time":0,
|
|
"rowkey_column_num":0,
|
|
"index_column_num":0,
|
|
"rowkey_split_pos":0,
|
|
"block_size":16384,
|
|
"is_use_bloomfilter":false,
|
|
"progressive_merge_num":0,
|
|
"tablet_size":-1,
|
|
"pctfree":10,
|
|
"load_type":0,
|
|
"index_using_type":0,
|
|
"def_type":1,
|
|
"charset_type":0,
|
|
"collation_type":0,
|
|
"create_mem_version":0,
|
|
"index_status":1,
|
|
"partition_status":0,
|
|
"code_version":1,
|
|
"last_modified_frozen_version":0,
|
|
"comment":"",
|
|
"pk_comment":"",
|
|
"create_host":"",
|
|
"zone_replica_attr_array": [
|
|
],
|
|
"region_replica_num_array": [
|
|
],
|
|
"tablegroup_name":"",
|
|
"compress_func_name":"",
|
|
"row_store_type":3,
|
|
"store_format":0,
|
|
"expire_info":"",
|
|
"view_schema": {
|
|
"view_definition":"",
|
|
"check_option":"none",
|
|
"is_updatable":"false",
|
|
"is_materialized":"false"
|
|
},
|
|
"autoinc_column_id":0,
|
|
"auto_increment":1,
|
|
"read_only":false,
|
|
"primary_zone_array": [
|
|
],
|
|
"index_tid_array": [
|
|
],
|
|
"mv_tid_array": [
|
|
],
|
|
"aux_vp_tid_array": [
|
|
],
|
|
"base_table_ids": [
|
|
],
|
|
"rowkey_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"partition_key_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"aux_vp_tid_array": [
|
|
]
|
|
}
|
|
},
|
|
"nls_formats": [
|
|
"",
|
|
"",
|
|
""
|
|
]
|
|
},
|
|
"index_arg_list": [
|
|
]
|
|
}
|
|
*************** Case 15 ***************
|
|
ALTER TABLE default_t1 ADD v1 varchar(500);
|
|
{
|
|
"ObTableStmt": {
|
|
"partition_fun_expr": [
|
|
],
|
|
"range_values_exprs": [
|
|
],
|
|
"list_values_exprs": [
|
|
],
|
|
"index_partition_resolve_results": [
|
|
],
|
|
"part_type":8
|
|
},
|
|
"stmt_type":22,
|
|
"alter_table_arg": {
|
|
"is_alter_columns":true,
|
|
"is_alter_indexs":false,
|
|
"is_alter_options":false,
|
|
"session_id":-1,
|
|
"index_arg_list": [
|
|
],
|
|
"alter_table_schema": {
|
|
"alter_type":"OB_INVALID_DDL_OP",
|
|
"origin_table_name":"default_t1",
|
|
"new_database_name":"defaultvalue",
|
|
"origin_database_name":"defaultvalue",
|
|
"split_partition_name":"",
|
|
"alter_table_schema": {
|
|
"simple_table_schema": {
|
|
"tenant_id":1,
|
|
"database_id":-1,
|
|
"tablegroup_id":-1,
|
|
"table_id":-1,
|
|
"table_name":"default_t1",
|
|
"replica_num":0,
|
|
"previous_locality_str":"",
|
|
"min_partition_id":0,
|
|
"session_id":0,
|
|
"index_type":0,
|
|
"table_type":3,
|
|
"data_table_id":0,
|
|
"name_casemode":-1,
|
|
"schema_version":0,
|
|
"part_level":0,
|
|
"part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"sub_part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"locality_str":"",
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"part_num":0,
|
|
"subpart_num":0,
|
|
"partition_num":0,
|
|
"subpartition_num":0,
|
|
"partition_array":null,
|
|
"subpartition_array":null,
|
|
"index_status":1,
|
|
"binding":false,
|
|
"duplicate_scope":0
|
|
},
|
|
"max_used_column_id":0,
|
|
"max_used_constraint_id":0,
|
|
"sess_active_time":0,
|
|
"rowkey_column_num":0,
|
|
"index_column_num":0,
|
|
"rowkey_split_pos":0,
|
|
"block_size":16384,
|
|
"is_use_bloomfilter":false,
|
|
"progressive_merge_num":0,
|
|
"tablet_size":-1,
|
|
"pctfree":10,
|
|
"load_type":0,
|
|
"index_using_type":0,
|
|
"def_type":1,
|
|
"charset_type":0,
|
|
"collation_type":0,
|
|
"create_mem_version":0,
|
|
"index_status":1,
|
|
"partition_status":0,
|
|
"code_version":1,
|
|
"last_modified_frozen_version":0,
|
|
"comment":"",
|
|
"pk_comment":"",
|
|
"create_host":"",
|
|
"zone_replica_attr_array": [
|
|
],
|
|
"region_replica_num_array": [
|
|
],
|
|
"tablegroup_name":"",
|
|
"compress_func_name":"",
|
|
"row_store_type":3,
|
|
"store_format":0,
|
|
"expire_info":"",
|
|
"view_schema": {
|
|
"view_definition":"",
|
|
"check_option":"none",
|
|
"is_updatable":"false",
|
|
"is_materialized":"false"
|
|
},
|
|
"autoinc_column_id":0,
|
|
"auto_increment":1,
|
|
"read_only":false,
|
|
"primary_zone_array": [
|
|
],
|
|
"index_tid_array": [
|
|
],
|
|
"mv_tid_array": [
|
|
],
|
|
"aux_vp_tid_array": [
|
|
],
|
|
"base_table_ids": [
|
|
],
|
|
"rowkey_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"partition_key_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"aux_vp_tid_array": [
|
|
]
|
|
}
|
|
},
|
|
"nls_formats": [
|
|
"",
|
|
"",
|
|
""
|
|
]
|
|
},
|
|
"index_arg_list": [
|
|
]
|
|
}
|
|
*************** Case 16 ***************
|
|
ALTER TABLE default_t1 ADD v2 varchar(500) not null;
|
|
{
|
|
"ObTableStmt": {
|
|
"partition_fun_expr": [
|
|
],
|
|
"range_values_exprs": [
|
|
],
|
|
"list_values_exprs": [
|
|
],
|
|
"index_partition_resolve_results": [
|
|
],
|
|
"part_type":8
|
|
},
|
|
"stmt_type":22,
|
|
"alter_table_arg": {
|
|
"is_alter_columns":true,
|
|
"is_alter_indexs":false,
|
|
"is_alter_options":false,
|
|
"session_id":-1,
|
|
"index_arg_list": [
|
|
],
|
|
"alter_table_schema": {
|
|
"alter_type":"OB_INVALID_DDL_OP",
|
|
"origin_table_name":"default_t1",
|
|
"new_database_name":"defaultvalue",
|
|
"origin_database_name":"defaultvalue",
|
|
"split_partition_name":"",
|
|
"alter_table_schema": {
|
|
"simple_table_schema": {
|
|
"tenant_id":1,
|
|
"database_id":-1,
|
|
"tablegroup_id":-1,
|
|
"table_id":-1,
|
|
"table_name":"default_t1",
|
|
"replica_num":0,
|
|
"previous_locality_str":"",
|
|
"min_partition_id":0,
|
|
"session_id":0,
|
|
"index_type":0,
|
|
"table_type":3,
|
|
"data_table_id":0,
|
|
"name_casemode":-1,
|
|
"schema_version":0,
|
|
"part_level":0,
|
|
"part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"sub_part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"locality_str":"",
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"part_num":0,
|
|
"subpart_num":0,
|
|
"partition_num":0,
|
|
"subpartition_num":0,
|
|
"partition_array":null,
|
|
"subpartition_array":null,
|
|
"index_status":1,
|
|
"binding":false,
|
|
"duplicate_scope":0
|
|
},
|
|
"max_used_column_id":0,
|
|
"max_used_constraint_id":0,
|
|
"sess_active_time":0,
|
|
"rowkey_column_num":0,
|
|
"index_column_num":0,
|
|
"rowkey_split_pos":0,
|
|
"block_size":16384,
|
|
"is_use_bloomfilter":false,
|
|
"progressive_merge_num":0,
|
|
"tablet_size":-1,
|
|
"pctfree":10,
|
|
"load_type":0,
|
|
"index_using_type":0,
|
|
"def_type":1,
|
|
"charset_type":0,
|
|
"collation_type":0,
|
|
"create_mem_version":0,
|
|
"index_status":1,
|
|
"partition_status":0,
|
|
"code_version":1,
|
|
"last_modified_frozen_version":0,
|
|
"comment":"",
|
|
"pk_comment":"",
|
|
"create_host":"",
|
|
"zone_replica_attr_array": [
|
|
],
|
|
"region_replica_num_array": [
|
|
],
|
|
"tablegroup_name":"",
|
|
"compress_func_name":"",
|
|
"row_store_type":3,
|
|
"store_format":0,
|
|
"expire_info":"",
|
|
"view_schema": {
|
|
"view_definition":"",
|
|
"check_option":"none",
|
|
"is_updatable":"false",
|
|
"is_materialized":"false"
|
|
},
|
|
"autoinc_column_id":0,
|
|
"auto_increment":1,
|
|
"read_only":false,
|
|
"primary_zone_array": [
|
|
],
|
|
"index_tid_array": [
|
|
],
|
|
"mv_tid_array": [
|
|
],
|
|
"aux_vp_tid_array": [
|
|
],
|
|
"base_table_ids": [
|
|
],
|
|
"rowkey_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"partition_key_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"aux_vp_tid_array": [
|
|
]
|
|
}
|
|
},
|
|
"nls_formats": [
|
|
"",
|
|
"",
|
|
""
|
|
]
|
|
},
|
|
"index_arg_list": [
|
|
]
|
|
}
|
|
*************** Case 17 ***************
|
|
ALTER TABLE default_t1 ADD v3 varchar(500) not null default 'xiyu@varchar500';
|
|
{
|
|
"ObTableStmt": {
|
|
"partition_fun_expr": [
|
|
],
|
|
"range_values_exprs": [
|
|
],
|
|
"list_values_exprs": [
|
|
],
|
|
"index_partition_resolve_results": [
|
|
],
|
|
"part_type":8
|
|
},
|
|
"stmt_type":22,
|
|
"alter_table_arg": {
|
|
"is_alter_columns":true,
|
|
"is_alter_indexs":false,
|
|
"is_alter_options":false,
|
|
"session_id":-1,
|
|
"index_arg_list": [
|
|
],
|
|
"alter_table_schema": {
|
|
"alter_type":"OB_INVALID_DDL_OP",
|
|
"origin_table_name":"default_t1",
|
|
"new_database_name":"defaultvalue",
|
|
"origin_database_name":"defaultvalue",
|
|
"split_partition_name":"",
|
|
"alter_table_schema": {
|
|
"simple_table_schema": {
|
|
"tenant_id":1,
|
|
"database_id":-1,
|
|
"tablegroup_id":-1,
|
|
"table_id":-1,
|
|
"table_name":"default_t1",
|
|
"replica_num":0,
|
|
"previous_locality_str":"",
|
|
"min_partition_id":0,
|
|
"session_id":0,
|
|
"index_type":0,
|
|
"table_type":3,
|
|
"data_table_id":0,
|
|
"name_casemode":-1,
|
|
"schema_version":0,
|
|
"part_level":0,
|
|
"part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"sub_part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"locality_str":"",
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"part_num":0,
|
|
"subpart_num":0,
|
|
"partition_num":0,
|
|
"subpartition_num":0,
|
|
"partition_array":null,
|
|
"subpartition_array":null,
|
|
"index_status":1,
|
|
"binding":false,
|
|
"duplicate_scope":0
|
|
},
|
|
"max_used_column_id":0,
|
|
"max_used_constraint_id":0,
|
|
"sess_active_time":0,
|
|
"rowkey_column_num":0,
|
|
"index_column_num":0,
|
|
"rowkey_split_pos":0,
|
|
"block_size":16384,
|
|
"is_use_bloomfilter":false,
|
|
"progressive_merge_num":0,
|
|
"tablet_size":-1,
|
|
"pctfree":10,
|
|
"load_type":0,
|
|
"index_using_type":0,
|
|
"def_type":1,
|
|
"charset_type":0,
|
|
"collation_type":0,
|
|
"create_mem_version":0,
|
|
"index_status":1,
|
|
"partition_status":0,
|
|
"code_version":1,
|
|
"last_modified_frozen_version":0,
|
|
"comment":"",
|
|
"pk_comment":"",
|
|
"create_host":"",
|
|
"zone_replica_attr_array": [
|
|
],
|
|
"region_replica_num_array": [
|
|
],
|
|
"tablegroup_name":"",
|
|
"compress_func_name":"",
|
|
"row_store_type":3,
|
|
"store_format":0,
|
|
"expire_info":"",
|
|
"view_schema": {
|
|
"view_definition":"",
|
|
"check_option":"none",
|
|
"is_updatable":"false",
|
|
"is_materialized":"false"
|
|
},
|
|
"autoinc_column_id":0,
|
|
"auto_increment":1,
|
|
"read_only":false,
|
|
"primary_zone_array": [
|
|
],
|
|
"index_tid_array": [
|
|
],
|
|
"mv_tid_array": [
|
|
],
|
|
"aux_vp_tid_array": [
|
|
],
|
|
"base_table_ids": [
|
|
],
|
|
"rowkey_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"partition_key_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"aux_vp_tid_array": [
|
|
]
|
|
}
|
|
},
|
|
"nls_formats": [
|
|
"",
|
|
"",
|
|
""
|
|
]
|
|
},
|
|
"index_arg_list": [
|
|
]
|
|
}
|
|
*************** Case 18 ***************
|
|
ALTER TABLE default_t1 ADD v3 varchar(500) not null default null;
|
|
*************** Case 19 ***************
|
|
ALTER TABLE default_t1 ADD ts3 timestamp not null default '2015-7-16';
|
|
{
|
|
"ObTableStmt": {
|
|
"partition_fun_expr": [
|
|
],
|
|
"range_values_exprs": [
|
|
],
|
|
"list_values_exprs": [
|
|
],
|
|
"index_partition_resolve_results": [
|
|
],
|
|
"part_type":8
|
|
},
|
|
"stmt_type":22,
|
|
"alter_table_arg": {
|
|
"is_alter_columns":true,
|
|
"is_alter_indexs":false,
|
|
"is_alter_options":false,
|
|
"session_id":-1,
|
|
"index_arg_list": [
|
|
],
|
|
"alter_table_schema": {
|
|
"alter_type":"OB_INVALID_DDL_OP",
|
|
"origin_table_name":"default_t1",
|
|
"new_database_name":"defaultvalue",
|
|
"origin_database_name":"defaultvalue",
|
|
"split_partition_name":"",
|
|
"alter_table_schema": {
|
|
"simple_table_schema": {
|
|
"tenant_id":1,
|
|
"database_id":-1,
|
|
"tablegroup_id":-1,
|
|
"table_id":-1,
|
|
"table_name":"default_t1",
|
|
"replica_num":0,
|
|
"previous_locality_str":"",
|
|
"min_partition_id":0,
|
|
"session_id":0,
|
|
"index_type":0,
|
|
"table_type":3,
|
|
"data_table_id":0,
|
|
"name_casemode":-1,
|
|
"schema_version":0,
|
|
"part_level":0,
|
|
"part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"sub_part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"locality_str":"",
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"part_num":0,
|
|
"subpart_num":0,
|
|
"partition_num":0,
|
|
"subpartition_num":0,
|
|
"partition_array":null,
|
|
"subpartition_array":null,
|
|
"index_status":1,
|
|
"binding":false,
|
|
"duplicate_scope":0
|
|
},
|
|
"max_used_column_id":0,
|
|
"max_used_constraint_id":0,
|
|
"sess_active_time":0,
|
|
"rowkey_column_num":0,
|
|
"index_column_num":0,
|
|
"rowkey_split_pos":0,
|
|
"block_size":16384,
|
|
"is_use_bloomfilter":false,
|
|
"progressive_merge_num":0,
|
|
"tablet_size":-1,
|
|
"pctfree":10,
|
|
"load_type":0,
|
|
"index_using_type":0,
|
|
"def_type":1,
|
|
"charset_type":0,
|
|
"collation_type":0,
|
|
"create_mem_version":0,
|
|
"index_status":1,
|
|
"partition_status":0,
|
|
"code_version":1,
|
|
"last_modified_frozen_version":0,
|
|
"comment":"",
|
|
"pk_comment":"",
|
|
"create_host":"",
|
|
"zone_replica_attr_array": [
|
|
],
|
|
"region_replica_num_array": [
|
|
],
|
|
"tablegroup_name":"",
|
|
"compress_func_name":"",
|
|
"row_store_type":3,
|
|
"store_format":0,
|
|
"expire_info":"",
|
|
"view_schema": {
|
|
"view_definition":"",
|
|
"check_option":"none",
|
|
"is_updatable":"false",
|
|
"is_materialized":"false"
|
|
},
|
|
"autoinc_column_id":0,
|
|
"auto_increment":1,
|
|
"read_only":false,
|
|
"primary_zone_array": [
|
|
],
|
|
"index_tid_array": [
|
|
],
|
|
"mv_tid_array": [
|
|
],
|
|
"aux_vp_tid_array": [
|
|
],
|
|
"base_table_ids": [
|
|
],
|
|
"rowkey_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"partition_key_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"aux_vp_tid_array": [
|
|
]
|
|
}
|
|
},
|
|
"nls_formats": [
|
|
"",
|
|
"",
|
|
""
|
|
]
|
|
},
|
|
"index_arg_list": [
|
|
]
|
|
}
|
|
*************** Case 20 ***************
|
|
ALTER TABLE default_t1 ADD y1 year;
|
|
{
|
|
"ObTableStmt": {
|
|
"partition_fun_expr": [
|
|
],
|
|
"range_values_exprs": [
|
|
],
|
|
"list_values_exprs": [
|
|
],
|
|
"index_partition_resolve_results": [
|
|
],
|
|
"part_type":8
|
|
},
|
|
"stmt_type":22,
|
|
"alter_table_arg": {
|
|
"is_alter_columns":true,
|
|
"is_alter_indexs":false,
|
|
"is_alter_options":false,
|
|
"session_id":-1,
|
|
"index_arg_list": [
|
|
],
|
|
"alter_table_schema": {
|
|
"alter_type":"OB_INVALID_DDL_OP",
|
|
"origin_table_name":"default_t1",
|
|
"new_database_name":"defaultvalue",
|
|
"origin_database_name":"defaultvalue",
|
|
"split_partition_name":"",
|
|
"alter_table_schema": {
|
|
"simple_table_schema": {
|
|
"tenant_id":1,
|
|
"database_id":-1,
|
|
"tablegroup_id":-1,
|
|
"table_id":-1,
|
|
"table_name":"default_t1",
|
|
"replica_num":0,
|
|
"previous_locality_str":"",
|
|
"min_partition_id":0,
|
|
"session_id":0,
|
|
"index_type":0,
|
|
"table_type":3,
|
|
"data_table_id":0,
|
|
"name_casemode":-1,
|
|
"schema_version":0,
|
|
"part_level":0,
|
|
"part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"sub_part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"locality_str":"",
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"part_num":0,
|
|
"subpart_num":0,
|
|
"partition_num":0,
|
|
"subpartition_num":0,
|
|
"partition_array":null,
|
|
"subpartition_array":null,
|
|
"index_status":1,
|
|
"binding":false,
|
|
"duplicate_scope":0
|
|
},
|
|
"max_used_column_id":0,
|
|
"max_used_constraint_id":0,
|
|
"sess_active_time":0,
|
|
"rowkey_column_num":0,
|
|
"index_column_num":0,
|
|
"rowkey_split_pos":0,
|
|
"block_size":16384,
|
|
"is_use_bloomfilter":false,
|
|
"progressive_merge_num":0,
|
|
"tablet_size":-1,
|
|
"pctfree":10,
|
|
"load_type":0,
|
|
"index_using_type":0,
|
|
"def_type":1,
|
|
"charset_type":0,
|
|
"collation_type":0,
|
|
"create_mem_version":0,
|
|
"index_status":1,
|
|
"partition_status":0,
|
|
"code_version":1,
|
|
"last_modified_frozen_version":0,
|
|
"comment":"",
|
|
"pk_comment":"",
|
|
"create_host":"",
|
|
"zone_replica_attr_array": [
|
|
],
|
|
"region_replica_num_array": [
|
|
],
|
|
"tablegroup_name":"",
|
|
"compress_func_name":"",
|
|
"row_store_type":3,
|
|
"store_format":0,
|
|
"expire_info":"",
|
|
"view_schema": {
|
|
"view_definition":"",
|
|
"check_option":"none",
|
|
"is_updatable":"false",
|
|
"is_materialized":"false"
|
|
},
|
|
"autoinc_column_id":0,
|
|
"auto_increment":1,
|
|
"read_only":false,
|
|
"primary_zone_array": [
|
|
],
|
|
"index_tid_array": [
|
|
],
|
|
"mv_tid_array": [
|
|
],
|
|
"aux_vp_tid_array": [
|
|
],
|
|
"base_table_ids": [
|
|
],
|
|
"rowkey_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"partition_key_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"aux_vp_tid_array": [
|
|
]
|
|
}
|
|
},
|
|
"nls_formats": [
|
|
"",
|
|
"",
|
|
""
|
|
]
|
|
},
|
|
"index_arg_list": [
|
|
]
|
|
}
|
|
*************** Case 21 ***************
|
|
ALTER TABLE default_t1 ADD y2 year not null;
|
|
{
|
|
"ObTableStmt": {
|
|
"partition_fun_expr": [
|
|
],
|
|
"range_values_exprs": [
|
|
],
|
|
"list_values_exprs": [
|
|
],
|
|
"index_partition_resolve_results": [
|
|
],
|
|
"part_type":8
|
|
},
|
|
"stmt_type":22,
|
|
"alter_table_arg": {
|
|
"is_alter_columns":true,
|
|
"is_alter_indexs":false,
|
|
"is_alter_options":false,
|
|
"session_id":-1,
|
|
"index_arg_list": [
|
|
],
|
|
"alter_table_schema": {
|
|
"alter_type":"OB_INVALID_DDL_OP",
|
|
"origin_table_name":"default_t1",
|
|
"new_database_name":"defaultvalue",
|
|
"origin_database_name":"defaultvalue",
|
|
"split_partition_name":"",
|
|
"alter_table_schema": {
|
|
"simple_table_schema": {
|
|
"tenant_id":1,
|
|
"database_id":-1,
|
|
"tablegroup_id":-1,
|
|
"table_id":-1,
|
|
"table_name":"default_t1",
|
|
"replica_num":0,
|
|
"previous_locality_str":"",
|
|
"min_partition_id":0,
|
|
"session_id":0,
|
|
"index_type":0,
|
|
"table_type":3,
|
|
"data_table_id":0,
|
|
"name_casemode":-1,
|
|
"schema_version":0,
|
|
"part_level":0,
|
|
"part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"sub_part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"locality_str":"",
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"part_num":0,
|
|
"subpart_num":0,
|
|
"partition_num":0,
|
|
"subpartition_num":0,
|
|
"partition_array":null,
|
|
"subpartition_array":null,
|
|
"index_status":1,
|
|
"binding":false,
|
|
"duplicate_scope":0
|
|
},
|
|
"max_used_column_id":0,
|
|
"max_used_constraint_id":0,
|
|
"sess_active_time":0,
|
|
"rowkey_column_num":0,
|
|
"index_column_num":0,
|
|
"rowkey_split_pos":0,
|
|
"block_size":16384,
|
|
"is_use_bloomfilter":false,
|
|
"progressive_merge_num":0,
|
|
"tablet_size":-1,
|
|
"pctfree":10,
|
|
"load_type":0,
|
|
"index_using_type":0,
|
|
"def_type":1,
|
|
"charset_type":0,
|
|
"collation_type":0,
|
|
"create_mem_version":0,
|
|
"index_status":1,
|
|
"partition_status":0,
|
|
"code_version":1,
|
|
"last_modified_frozen_version":0,
|
|
"comment":"",
|
|
"pk_comment":"",
|
|
"create_host":"",
|
|
"zone_replica_attr_array": [
|
|
],
|
|
"region_replica_num_array": [
|
|
],
|
|
"tablegroup_name":"",
|
|
"compress_func_name":"",
|
|
"row_store_type":3,
|
|
"store_format":0,
|
|
"expire_info":"",
|
|
"view_schema": {
|
|
"view_definition":"",
|
|
"check_option":"none",
|
|
"is_updatable":"false",
|
|
"is_materialized":"false"
|
|
},
|
|
"autoinc_column_id":0,
|
|
"auto_increment":1,
|
|
"read_only":false,
|
|
"primary_zone_array": [
|
|
],
|
|
"index_tid_array": [
|
|
],
|
|
"mv_tid_array": [
|
|
],
|
|
"aux_vp_tid_array": [
|
|
],
|
|
"base_table_ids": [
|
|
],
|
|
"rowkey_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"partition_key_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"aux_vp_tid_array": [
|
|
]
|
|
}
|
|
},
|
|
"nls_formats": [
|
|
"",
|
|
"",
|
|
""
|
|
]
|
|
},
|
|
"index_arg_list": [
|
|
]
|
|
}
|
|
*************** Case 22 ***************
|
|
ALTER TABLE default_t1 ADD y3 year not null default 1983
|
|
{
|
|
"ObTableStmt": {
|
|
"partition_fun_expr": [
|
|
],
|
|
"range_values_exprs": [
|
|
],
|
|
"list_values_exprs": [
|
|
],
|
|
"index_partition_resolve_results": [
|
|
],
|
|
"part_type":8
|
|
},
|
|
"stmt_type":22,
|
|
"alter_table_arg": {
|
|
"is_alter_columns":true,
|
|
"is_alter_indexs":false,
|
|
"is_alter_options":false,
|
|
"session_id":-1,
|
|
"index_arg_list": [
|
|
],
|
|
"alter_table_schema": {
|
|
"alter_type":"OB_INVALID_DDL_OP",
|
|
"origin_table_name":"default_t1",
|
|
"new_database_name":"defaultvalue",
|
|
"origin_database_name":"defaultvalue",
|
|
"split_partition_name":"",
|
|
"alter_table_schema": {
|
|
"simple_table_schema": {
|
|
"tenant_id":1,
|
|
"database_id":-1,
|
|
"tablegroup_id":-1,
|
|
"table_id":-1,
|
|
"table_name":"default_t1",
|
|
"replica_num":0,
|
|
"previous_locality_str":"",
|
|
"min_partition_id":0,
|
|
"session_id":0,
|
|
"index_type":0,
|
|
"table_type":3,
|
|
"data_table_id":0,
|
|
"name_casemode":-1,
|
|
"schema_version":0,
|
|
"part_level":0,
|
|
"part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"sub_part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"locality_str":"",
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"part_num":0,
|
|
"subpart_num":0,
|
|
"partition_num":0,
|
|
"subpartition_num":0,
|
|
"partition_array":null,
|
|
"subpartition_array":null,
|
|
"index_status":1,
|
|
"binding":false,
|
|
"duplicate_scope":0
|
|
},
|
|
"max_used_column_id":0,
|
|
"max_used_constraint_id":0,
|
|
"sess_active_time":0,
|
|
"rowkey_column_num":0,
|
|
"index_column_num":0,
|
|
"rowkey_split_pos":0,
|
|
"block_size":16384,
|
|
"is_use_bloomfilter":false,
|
|
"progressive_merge_num":0,
|
|
"tablet_size":-1,
|
|
"pctfree":10,
|
|
"load_type":0,
|
|
"index_using_type":0,
|
|
"def_type":1,
|
|
"charset_type":0,
|
|
"collation_type":0,
|
|
"create_mem_version":0,
|
|
"index_status":1,
|
|
"partition_status":0,
|
|
"code_version":1,
|
|
"last_modified_frozen_version":0,
|
|
"comment":"",
|
|
"pk_comment":"",
|
|
"create_host":"",
|
|
"zone_replica_attr_array": [
|
|
],
|
|
"region_replica_num_array": [
|
|
],
|
|
"tablegroup_name":"",
|
|
"compress_func_name":"",
|
|
"row_store_type":3,
|
|
"store_format":0,
|
|
"expire_info":"",
|
|
"view_schema": {
|
|
"view_definition":"",
|
|
"check_option":"none",
|
|
"is_updatable":"false",
|
|
"is_materialized":"false"
|
|
},
|
|
"autoinc_column_id":0,
|
|
"auto_increment":1,
|
|
"read_only":false,
|
|
"primary_zone_array": [
|
|
],
|
|
"index_tid_array": [
|
|
],
|
|
"mv_tid_array": [
|
|
],
|
|
"aux_vp_tid_array": [
|
|
],
|
|
"base_table_ids": [
|
|
],
|
|
"rowkey_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"partition_key_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"aux_vp_tid_array": [
|
|
]
|
|
}
|
|
},
|
|
"nls_formats": [
|
|
"",
|
|
"",
|
|
""
|
|
]
|
|
},
|
|
"index_arg_list": [
|
|
]
|
|
}
|
|
*************** Case 23 ***************
|
|
ALTER TABLE default_t1 ADD t1 time;
|
|
{
|
|
"ObTableStmt": {
|
|
"partition_fun_expr": [
|
|
],
|
|
"range_values_exprs": [
|
|
],
|
|
"list_values_exprs": [
|
|
],
|
|
"index_partition_resolve_results": [
|
|
],
|
|
"part_type":8
|
|
},
|
|
"stmt_type":22,
|
|
"alter_table_arg": {
|
|
"is_alter_columns":true,
|
|
"is_alter_indexs":false,
|
|
"is_alter_options":false,
|
|
"session_id":-1,
|
|
"index_arg_list": [
|
|
],
|
|
"alter_table_schema": {
|
|
"alter_type":"OB_INVALID_DDL_OP",
|
|
"origin_table_name":"default_t1",
|
|
"new_database_name":"defaultvalue",
|
|
"origin_database_name":"defaultvalue",
|
|
"split_partition_name":"",
|
|
"alter_table_schema": {
|
|
"simple_table_schema": {
|
|
"tenant_id":1,
|
|
"database_id":-1,
|
|
"tablegroup_id":-1,
|
|
"table_id":-1,
|
|
"table_name":"default_t1",
|
|
"replica_num":0,
|
|
"previous_locality_str":"",
|
|
"min_partition_id":0,
|
|
"session_id":0,
|
|
"index_type":0,
|
|
"table_type":3,
|
|
"data_table_id":0,
|
|
"name_casemode":-1,
|
|
"schema_version":0,
|
|
"part_level":0,
|
|
"part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"sub_part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"locality_str":"",
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"part_num":0,
|
|
"subpart_num":0,
|
|
"partition_num":0,
|
|
"subpartition_num":0,
|
|
"partition_array":null,
|
|
"subpartition_array":null,
|
|
"index_status":1,
|
|
"binding":false,
|
|
"duplicate_scope":0
|
|
},
|
|
"max_used_column_id":0,
|
|
"max_used_constraint_id":0,
|
|
"sess_active_time":0,
|
|
"rowkey_column_num":0,
|
|
"index_column_num":0,
|
|
"rowkey_split_pos":0,
|
|
"block_size":16384,
|
|
"is_use_bloomfilter":false,
|
|
"progressive_merge_num":0,
|
|
"tablet_size":-1,
|
|
"pctfree":10,
|
|
"load_type":0,
|
|
"index_using_type":0,
|
|
"def_type":1,
|
|
"charset_type":0,
|
|
"collation_type":0,
|
|
"create_mem_version":0,
|
|
"index_status":1,
|
|
"partition_status":0,
|
|
"code_version":1,
|
|
"last_modified_frozen_version":0,
|
|
"comment":"",
|
|
"pk_comment":"",
|
|
"create_host":"",
|
|
"zone_replica_attr_array": [
|
|
],
|
|
"region_replica_num_array": [
|
|
],
|
|
"tablegroup_name":"",
|
|
"compress_func_name":"",
|
|
"row_store_type":3,
|
|
"store_format":0,
|
|
"expire_info":"",
|
|
"view_schema": {
|
|
"view_definition":"",
|
|
"check_option":"none",
|
|
"is_updatable":"false",
|
|
"is_materialized":"false"
|
|
},
|
|
"autoinc_column_id":0,
|
|
"auto_increment":1,
|
|
"read_only":false,
|
|
"primary_zone_array": [
|
|
],
|
|
"index_tid_array": [
|
|
],
|
|
"mv_tid_array": [
|
|
],
|
|
"aux_vp_tid_array": [
|
|
],
|
|
"base_table_ids": [
|
|
],
|
|
"rowkey_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"partition_key_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"aux_vp_tid_array": [
|
|
]
|
|
}
|
|
},
|
|
"nls_formats": [
|
|
"",
|
|
"",
|
|
""
|
|
]
|
|
},
|
|
"index_arg_list": [
|
|
]
|
|
}
|
|
*************** Case 24 ***************
|
|
ALTER TABLE default_t1 ADD t2 time not null;
|
|
{
|
|
"ObTableStmt": {
|
|
"partition_fun_expr": [
|
|
],
|
|
"range_values_exprs": [
|
|
],
|
|
"list_values_exprs": [
|
|
],
|
|
"index_partition_resolve_results": [
|
|
],
|
|
"part_type":8
|
|
},
|
|
"stmt_type":22,
|
|
"alter_table_arg": {
|
|
"is_alter_columns":true,
|
|
"is_alter_indexs":false,
|
|
"is_alter_options":false,
|
|
"session_id":-1,
|
|
"index_arg_list": [
|
|
],
|
|
"alter_table_schema": {
|
|
"alter_type":"OB_INVALID_DDL_OP",
|
|
"origin_table_name":"default_t1",
|
|
"new_database_name":"defaultvalue",
|
|
"origin_database_name":"defaultvalue",
|
|
"split_partition_name":"",
|
|
"alter_table_schema": {
|
|
"simple_table_schema": {
|
|
"tenant_id":1,
|
|
"database_id":-1,
|
|
"tablegroup_id":-1,
|
|
"table_id":-1,
|
|
"table_name":"default_t1",
|
|
"replica_num":0,
|
|
"previous_locality_str":"",
|
|
"min_partition_id":0,
|
|
"session_id":0,
|
|
"index_type":0,
|
|
"table_type":3,
|
|
"data_table_id":0,
|
|
"name_casemode":-1,
|
|
"schema_version":0,
|
|
"part_level":0,
|
|
"part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"sub_part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"locality_str":"",
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"part_num":0,
|
|
"subpart_num":0,
|
|
"partition_num":0,
|
|
"subpartition_num":0,
|
|
"partition_array":null,
|
|
"subpartition_array":null,
|
|
"index_status":1,
|
|
"binding":false,
|
|
"duplicate_scope":0
|
|
},
|
|
"max_used_column_id":0,
|
|
"max_used_constraint_id":0,
|
|
"sess_active_time":0,
|
|
"rowkey_column_num":0,
|
|
"index_column_num":0,
|
|
"rowkey_split_pos":0,
|
|
"block_size":16384,
|
|
"is_use_bloomfilter":false,
|
|
"progressive_merge_num":0,
|
|
"tablet_size":-1,
|
|
"pctfree":10,
|
|
"load_type":0,
|
|
"index_using_type":0,
|
|
"def_type":1,
|
|
"charset_type":0,
|
|
"collation_type":0,
|
|
"create_mem_version":0,
|
|
"index_status":1,
|
|
"partition_status":0,
|
|
"code_version":1,
|
|
"last_modified_frozen_version":0,
|
|
"comment":"",
|
|
"pk_comment":"",
|
|
"create_host":"",
|
|
"zone_replica_attr_array": [
|
|
],
|
|
"region_replica_num_array": [
|
|
],
|
|
"tablegroup_name":"",
|
|
"compress_func_name":"",
|
|
"row_store_type":3,
|
|
"store_format":0,
|
|
"expire_info":"",
|
|
"view_schema": {
|
|
"view_definition":"",
|
|
"check_option":"none",
|
|
"is_updatable":"false",
|
|
"is_materialized":"false"
|
|
},
|
|
"autoinc_column_id":0,
|
|
"auto_increment":1,
|
|
"read_only":false,
|
|
"primary_zone_array": [
|
|
],
|
|
"index_tid_array": [
|
|
],
|
|
"mv_tid_array": [
|
|
],
|
|
"aux_vp_tid_array": [
|
|
],
|
|
"base_table_ids": [
|
|
],
|
|
"rowkey_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"partition_key_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"aux_vp_tid_array": [
|
|
]
|
|
}
|
|
},
|
|
"nls_formats": [
|
|
"",
|
|
"",
|
|
""
|
|
]
|
|
},
|
|
"index_arg_list": [
|
|
]
|
|
}
|
|
*************** Case 25 ***************
|
|
ALTER TABLE default_t1 ADD t3 time not null default 10;
|
|
{
|
|
"ObTableStmt": {
|
|
"partition_fun_expr": [
|
|
],
|
|
"range_values_exprs": [
|
|
],
|
|
"list_values_exprs": [
|
|
],
|
|
"index_partition_resolve_results": [
|
|
],
|
|
"part_type":8
|
|
},
|
|
"stmt_type":22,
|
|
"alter_table_arg": {
|
|
"is_alter_columns":true,
|
|
"is_alter_indexs":false,
|
|
"is_alter_options":false,
|
|
"session_id":-1,
|
|
"index_arg_list": [
|
|
],
|
|
"alter_table_schema": {
|
|
"alter_type":"OB_INVALID_DDL_OP",
|
|
"origin_table_name":"default_t1",
|
|
"new_database_name":"defaultvalue",
|
|
"origin_database_name":"defaultvalue",
|
|
"split_partition_name":"",
|
|
"alter_table_schema": {
|
|
"simple_table_schema": {
|
|
"tenant_id":1,
|
|
"database_id":-1,
|
|
"tablegroup_id":-1,
|
|
"table_id":-1,
|
|
"table_name":"default_t1",
|
|
"replica_num":0,
|
|
"previous_locality_str":"",
|
|
"min_partition_id":0,
|
|
"session_id":0,
|
|
"index_type":0,
|
|
"table_type":3,
|
|
"data_table_id":0,
|
|
"name_casemode":-1,
|
|
"schema_version":0,
|
|
"part_level":0,
|
|
"part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"sub_part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"locality_str":"",
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"part_num":0,
|
|
"subpart_num":0,
|
|
"partition_num":0,
|
|
"subpartition_num":0,
|
|
"partition_array":null,
|
|
"subpartition_array":null,
|
|
"index_status":1,
|
|
"binding":false,
|
|
"duplicate_scope":0
|
|
},
|
|
"max_used_column_id":0,
|
|
"max_used_constraint_id":0,
|
|
"sess_active_time":0,
|
|
"rowkey_column_num":0,
|
|
"index_column_num":0,
|
|
"rowkey_split_pos":0,
|
|
"block_size":16384,
|
|
"is_use_bloomfilter":false,
|
|
"progressive_merge_num":0,
|
|
"tablet_size":-1,
|
|
"pctfree":10,
|
|
"load_type":0,
|
|
"index_using_type":0,
|
|
"def_type":1,
|
|
"charset_type":0,
|
|
"collation_type":0,
|
|
"create_mem_version":0,
|
|
"index_status":1,
|
|
"partition_status":0,
|
|
"code_version":1,
|
|
"last_modified_frozen_version":0,
|
|
"comment":"",
|
|
"pk_comment":"",
|
|
"create_host":"",
|
|
"zone_replica_attr_array": [
|
|
],
|
|
"region_replica_num_array": [
|
|
],
|
|
"tablegroup_name":"",
|
|
"compress_func_name":"",
|
|
"row_store_type":3,
|
|
"store_format":0,
|
|
"expire_info":"",
|
|
"view_schema": {
|
|
"view_definition":"",
|
|
"check_option":"none",
|
|
"is_updatable":"false",
|
|
"is_materialized":"false"
|
|
},
|
|
"autoinc_column_id":0,
|
|
"auto_increment":1,
|
|
"read_only":false,
|
|
"primary_zone_array": [
|
|
],
|
|
"index_tid_array": [
|
|
],
|
|
"mv_tid_array": [
|
|
],
|
|
"aux_vp_tid_array": [
|
|
],
|
|
"base_table_ids": [
|
|
],
|
|
"rowkey_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"partition_key_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"aux_vp_tid_array": [
|
|
]
|
|
}
|
|
},
|
|
"nls_formats": [
|
|
"",
|
|
"",
|
|
""
|
|
]
|
|
},
|
|
"index_arg_list": [
|
|
]
|
|
}
|
|
*************** Case 26 ***************
|
|
ALTER TABLE default_t1 ADD d1 date;
|
|
{
|
|
"ObTableStmt": {
|
|
"partition_fun_expr": [
|
|
],
|
|
"range_values_exprs": [
|
|
],
|
|
"list_values_exprs": [
|
|
],
|
|
"index_partition_resolve_results": [
|
|
],
|
|
"part_type":8
|
|
},
|
|
"stmt_type":22,
|
|
"alter_table_arg": {
|
|
"is_alter_columns":true,
|
|
"is_alter_indexs":false,
|
|
"is_alter_options":false,
|
|
"session_id":-1,
|
|
"index_arg_list": [
|
|
],
|
|
"alter_table_schema": {
|
|
"alter_type":"OB_INVALID_DDL_OP",
|
|
"origin_table_name":"default_t1",
|
|
"new_database_name":"defaultvalue",
|
|
"origin_database_name":"defaultvalue",
|
|
"split_partition_name":"",
|
|
"alter_table_schema": {
|
|
"simple_table_schema": {
|
|
"tenant_id":1,
|
|
"database_id":-1,
|
|
"tablegroup_id":-1,
|
|
"table_id":-1,
|
|
"table_name":"default_t1",
|
|
"replica_num":0,
|
|
"previous_locality_str":"",
|
|
"min_partition_id":0,
|
|
"session_id":0,
|
|
"index_type":0,
|
|
"table_type":3,
|
|
"data_table_id":0,
|
|
"name_casemode":-1,
|
|
"schema_version":0,
|
|
"part_level":0,
|
|
"part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"sub_part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"locality_str":"",
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"part_num":0,
|
|
"subpart_num":0,
|
|
"partition_num":0,
|
|
"subpartition_num":0,
|
|
"partition_array":null,
|
|
"subpartition_array":null,
|
|
"index_status":1,
|
|
"binding":false,
|
|
"duplicate_scope":0
|
|
},
|
|
"max_used_column_id":0,
|
|
"max_used_constraint_id":0,
|
|
"sess_active_time":0,
|
|
"rowkey_column_num":0,
|
|
"index_column_num":0,
|
|
"rowkey_split_pos":0,
|
|
"block_size":16384,
|
|
"is_use_bloomfilter":false,
|
|
"progressive_merge_num":0,
|
|
"tablet_size":-1,
|
|
"pctfree":10,
|
|
"load_type":0,
|
|
"index_using_type":0,
|
|
"def_type":1,
|
|
"charset_type":0,
|
|
"collation_type":0,
|
|
"create_mem_version":0,
|
|
"index_status":1,
|
|
"partition_status":0,
|
|
"code_version":1,
|
|
"last_modified_frozen_version":0,
|
|
"comment":"",
|
|
"pk_comment":"",
|
|
"create_host":"",
|
|
"zone_replica_attr_array": [
|
|
],
|
|
"region_replica_num_array": [
|
|
],
|
|
"tablegroup_name":"",
|
|
"compress_func_name":"",
|
|
"row_store_type":3,
|
|
"store_format":0,
|
|
"expire_info":"",
|
|
"view_schema": {
|
|
"view_definition":"",
|
|
"check_option":"none",
|
|
"is_updatable":"false",
|
|
"is_materialized":"false"
|
|
},
|
|
"autoinc_column_id":0,
|
|
"auto_increment":1,
|
|
"read_only":false,
|
|
"primary_zone_array": [
|
|
],
|
|
"index_tid_array": [
|
|
],
|
|
"mv_tid_array": [
|
|
],
|
|
"aux_vp_tid_array": [
|
|
],
|
|
"base_table_ids": [
|
|
],
|
|
"rowkey_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"partition_key_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"aux_vp_tid_array": [
|
|
]
|
|
}
|
|
},
|
|
"nls_formats": [
|
|
"",
|
|
"",
|
|
""
|
|
]
|
|
},
|
|
"index_arg_list": [
|
|
]
|
|
}
|
|
*************** Case 27 ***************
|
|
ALTER TABLE default_t1 ADD d2 date not null;
|
|
{
|
|
"ObTableStmt": {
|
|
"partition_fun_expr": [
|
|
],
|
|
"range_values_exprs": [
|
|
],
|
|
"list_values_exprs": [
|
|
],
|
|
"index_partition_resolve_results": [
|
|
],
|
|
"part_type":8
|
|
},
|
|
"stmt_type":22,
|
|
"alter_table_arg": {
|
|
"is_alter_columns":true,
|
|
"is_alter_indexs":false,
|
|
"is_alter_options":false,
|
|
"session_id":-1,
|
|
"index_arg_list": [
|
|
],
|
|
"alter_table_schema": {
|
|
"alter_type":"OB_INVALID_DDL_OP",
|
|
"origin_table_name":"default_t1",
|
|
"new_database_name":"defaultvalue",
|
|
"origin_database_name":"defaultvalue",
|
|
"split_partition_name":"",
|
|
"alter_table_schema": {
|
|
"simple_table_schema": {
|
|
"tenant_id":1,
|
|
"database_id":-1,
|
|
"tablegroup_id":-1,
|
|
"table_id":-1,
|
|
"table_name":"default_t1",
|
|
"replica_num":0,
|
|
"previous_locality_str":"",
|
|
"min_partition_id":0,
|
|
"session_id":0,
|
|
"index_type":0,
|
|
"table_type":3,
|
|
"data_table_id":0,
|
|
"name_casemode":-1,
|
|
"schema_version":0,
|
|
"part_level":0,
|
|
"part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"sub_part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"locality_str":"",
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"part_num":0,
|
|
"subpart_num":0,
|
|
"partition_num":0,
|
|
"subpartition_num":0,
|
|
"partition_array":null,
|
|
"subpartition_array":null,
|
|
"index_status":1,
|
|
"binding":false,
|
|
"duplicate_scope":0
|
|
},
|
|
"max_used_column_id":0,
|
|
"max_used_constraint_id":0,
|
|
"sess_active_time":0,
|
|
"rowkey_column_num":0,
|
|
"index_column_num":0,
|
|
"rowkey_split_pos":0,
|
|
"block_size":16384,
|
|
"is_use_bloomfilter":false,
|
|
"progressive_merge_num":0,
|
|
"tablet_size":-1,
|
|
"pctfree":10,
|
|
"load_type":0,
|
|
"index_using_type":0,
|
|
"def_type":1,
|
|
"charset_type":0,
|
|
"collation_type":0,
|
|
"create_mem_version":0,
|
|
"index_status":1,
|
|
"partition_status":0,
|
|
"code_version":1,
|
|
"last_modified_frozen_version":0,
|
|
"comment":"",
|
|
"pk_comment":"",
|
|
"create_host":"",
|
|
"zone_replica_attr_array": [
|
|
],
|
|
"region_replica_num_array": [
|
|
],
|
|
"tablegroup_name":"",
|
|
"compress_func_name":"",
|
|
"row_store_type":3,
|
|
"store_format":0,
|
|
"expire_info":"",
|
|
"view_schema": {
|
|
"view_definition":"",
|
|
"check_option":"none",
|
|
"is_updatable":"false",
|
|
"is_materialized":"false"
|
|
},
|
|
"autoinc_column_id":0,
|
|
"auto_increment":1,
|
|
"read_only":false,
|
|
"primary_zone_array": [
|
|
],
|
|
"index_tid_array": [
|
|
],
|
|
"mv_tid_array": [
|
|
],
|
|
"aux_vp_tid_array": [
|
|
],
|
|
"base_table_ids": [
|
|
],
|
|
"rowkey_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"partition_key_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"aux_vp_tid_array": [
|
|
]
|
|
}
|
|
},
|
|
"nls_formats": [
|
|
"",
|
|
"",
|
|
""
|
|
]
|
|
},
|
|
"index_arg_list": [
|
|
]
|
|
}
|
|
*************** Case 28 ***************
|
|
ALTER TABLE default_t1 ADD d3 date not null default '2015-07-16';
|
|
{
|
|
"ObTableStmt": {
|
|
"partition_fun_expr": [
|
|
],
|
|
"range_values_exprs": [
|
|
],
|
|
"list_values_exprs": [
|
|
],
|
|
"index_partition_resolve_results": [
|
|
],
|
|
"part_type":8
|
|
},
|
|
"stmt_type":22,
|
|
"alter_table_arg": {
|
|
"is_alter_columns":true,
|
|
"is_alter_indexs":false,
|
|
"is_alter_options":false,
|
|
"session_id":-1,
|
|
"index_arg_list": [
|
|
],
|
|
"alter_table_schema": {
|
|
"alter_type":"OB_INVALID_DDL_OP",
|
|
"origin_table_name":"default_t1",
|
|
"new_database_name":"defaultvalue",
|
|
"origin_database_name":"defaultvalue",
|
|
"split_partition_name":"",
|
|
"alter_table_schema": {
|
|
"simple_table_schema": {
|
|
"tenant_id":1,
|
|
"database_id":-1,
|
|
"tablegroup_id":-1,
|
|
"table_id":-1,
|
|
"table_name":"default_t1",
|
|
"replica_num":0,
|
|
"previous_locality_str":"",
|
|
"min_partition_id":0,
|
|
"session_id":0,
|
|
"index_type":0,
|
|
"table_type":3,
|
|
"data_table_id":0,
|
|
"name_casemode":-1,
|
|
"schema_version":0,
|
|
"part_level":0,
|
|
"part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"sub_part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"locality_str":"",
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"part_num":0,
|
|
"subpart_num":0,
|
|
"partition_num":0,
|
|
"subpartition_num":0,
|
|
"partition_array":null,
|
|
"subpartition_array":null,
|
|
"index_status":1,
|
|
"binding":false,
|
|
"duplicate_scope":0
|
|
},
|
|
"max_used_column_id":0,
|
|
"max_used_constraint_id":0,
|
|
"sess_active_time":0,
|
|
"rowkey_column_num":0,
|
|
"index_column_num":0,
|
|
"rowkey_split_pos":0,
|
|
"block_size":16384,
|
|
"is_use_bloomfilter":false,
|
|
"progressive_merge_num":0,
|
|
"tablet_size":-1,
|
|
"pctfree":10,
|
|
"load_type":0,
|
|
"index_using_type":0,
|
|
"def_type":1,
|
|
"charset_type":0,
|
|
"collation_type":0,
|
|
"create_mem_version":0,
|
|
"index_status":1,
|
|
"partition_status":0,
|
|
"code_version":1,
|
|
"last_modified_frozen_version":0,
|
|
"comment":"",
|
|
"pk_comment":"",
|
|
"create_host":"",
|
|
"zone_replica_attr_array": [
|
|
],
|
|
"region_replica_num_array": [
|
|
],
|
|
"tablegroup_name":"",
|
|
"compress_func_name":"",
|
|
"row_store_type":3,
|
|
"store_format":0,
|
|
"expire_info":"",
|
|
"view_schema": {
|
|
"view_definition":"",
|
|
"check_option":"none",
|
|
"is_updatable":"false",
|
|
"is_materialized":"false"
|
|
},
|
|
"autoinc_column_id":0,
|
|
"auto_increment":1,
|
|
"read_only":false,
|
|
"primary_zone_array": [
|
|
],
|
|
"index_tid_array": [
|
|
],
|
|
"mv_tid_array": [
|
|
],
|
|
"aux_vp_tid_array": [
|
|
],
|
|
"base_table_ids": [
|
|
],
|
|
"rowkey_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"partition_key_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"aux_vp_tid_array": [
|
|
]
|
|
}
|
|
},
|
|
"nls_formats": [
|
|
"",
|
|
"",
|
|
""
|
|
]
|
|
},
|
|
"index_arg_list": [
|
|
]
|
|
}
|
|
*************** Case 29 ***************
|
|
ALTER TABLE default_t1 ADD dt1 datetime;
|
|
{
|
|
"ObTableStmt": {
|
|
"partition_fun_expr": [
|
|
],
|
|
"range_values_exprs": [
|
|
],
|
|
"list_values_exprs": [
|
|
],
|
|
"index_partition_resolve_results": [
|
|
],
|
|
"part_type":8
|
|
},
|
|
"stmt_type":22,
|
|
"alter_table_arg": {
|
|
"is_alter_columns":true,
|
|
"is_alter_indexs":false,
|
|
"is_alter_options":false,
|
|
"session_id":-1,
|
|
"index_arg_list": [
|
|
],
|
|
"alter_table_schema": {
|
|
"alter_type":"OB_INVALID_DDL_OP",
|
|
"origin_table_name":"default_t1",
|
|
"new_database_name":"defaultvalue",
|
|
"origin_database_name":"defaultvalue",
|
|
"split_partition_name":"",
|
|
"alter_table_schema": {
|
|
"simple_table_schema": {
|
|
"tenant_id":1,
|
|
"database_id":-1,
|
|
"tablegroup_id":-1,
|
|
"table_id":-1,
|
|
"table_name":"default_t1",
|
|
"replica_num":0,
|
|
"previous_locality_str":"",
|
|
"min_partition_id":0,
|
|
"session_id":0,
|
|
"index_type":0,
|
|
"table_type":3,
|
|
"data_table_id":0,
|
|
"name_casemode":-1,
|
|
"schema_version":0,
|
|
"part_level":0,
|
|
"part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"sub_part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"locality_str":"",
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"part_num":0,
|
|
"subpart_num":0,
|
|
"partition_num":0,
|
|
"subpartition_num":0,
|
|
"partition_array":null,
|
|
"subpartition_array":null,
|
|
"index_status":1,
|
|
"binding":false,
|
|
"duplicate_scope":0
|
|
},
|
|
"max_used_column_id":0,
|
|
"max_used_constraint_id":0,
|
|
"sess_active_time":0,
|
|
"rowkey_column_num":0,
|
|
"index_column_num":0,
|
|
"rowkey_split_pos":0,
|
|
"block_size":16384,
|
|
"is_use_bloomfilter":false,
|
|
"progressive_merge_num":0,
|
|
"tablet_size":-1,
|
|
"pctfree":10,
|
|
"load_type":0,
|
|
"index_using_type":0,
|
|
"def_type":1,
|
|
"charset_type":0,
|
|
"collation_type":0,
|
|
"create_mem_version":0,
|
|
"index_status":1,
|
|
"partition_status":0,
|
|
"code_version":1,
|
|
"last_modified_frozen_version":0,
|
|
"comment":"",
|
|
"pk_comment":"",
|
|
"create_host":"",
|
|
"zone_replica_attr_array": [
|
|
],
|
|
"region_replica_num_array": [
|
|
],
|
|
"tablegroup_name":"",
|
|
"compress_func_name":"",
|
|
"row_store_type":3,
|
|
"store_format":0,
|
|
"expire_info":"",
|
|
"view_schema": {
|
|
"view_definition":"",
|
|
"check_option":"none",
|
|
"is_updatable":"false",
|
|
"is_materialized":"false"
|
|
},
|
|
"autoinc_column_id":0,
|
|
"auto_increment":1,
|
|
"read_only":false,
|
|
"primary_zone_array": [
|
|
],
|
|
"index_tid_array": [
|
|
],
|
|
"mv_tid_array": [
|
|
],
|
|
"aux_vp_tid_array": [
|
|
],
|
|
"base_table_ids": [
|
|
],
|
|
"rowkey_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"partition_key_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"aux_vp_tid_array": [
|
|
]
|
|
}
|
|
},
|
|
"nls_formats": [
|
|
"",
|
|
"",
|
|
""
|
|
]
|
|
},
|
|
"index_arg_list": [
|
|
]
|
|
}
|
|
*************** Case 30 ***************
|
|
ALTER TABLE default_t1 ADD dt2 datetime not null;
|
|
{
|
|
"ObTableStmt": {
|
|
"partition_fun_expr": [
|
|
],
|
|
"range_values_exprs": [
|
|
],
|
|
"list_values_exprs": [
|
|
],
|
|
"index_partition_resolve_results": [
|
|
],
|
|
"part_type":8
|
|
},
|
|
"stmt_type":22,
|
|
"alter_table_arg": {
|
|
"is_alter_columns":true,
|
|
"is_alter_indexs":false,
|
|
"is_alter_options":false,
|
|
"session_id":-1,
|
|
"index_arg_list": [
|
|
],
|
|
"alter_table_schema": {
|
|
"alter_type":"OB_INVALID_DDL_OP",
|
|
"origin_table_name":"default_t1",
|
|
"new_database_name":"defaultvalue",
|
|
"origin_database_name":"defaultvalue",
|
|
"split_partition_name":"",
|
|
"alter_table_schema": {
|
|
"simple_table_schema": {
|
|
"tenant_id":1,
|
|
"database_id":-1,
|
|
"tablegroup_id":-1,
|
|
"table_id":-1,
|
|
"table_name":"default_t1",
|
|
"replica_num":0,
|
|
"previous_locality_str":"",
|
|
"min_partition_id":0,
|
|
"session_id":0,
|
|
"index_type":0,
|
|
"table_type":3,
|
|
"data_table_id":0,
|
|
"name_casemode":-1,
|
|
"schema_version":0,
|
|
"part_level":0,
|
|
"part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"sub_part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"locality_str":"",
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"part_num":0,
|
|
"subpart_num":0,
|
|
"partition_num":0,
|
|
"subpartition_num":0,
|
|
"partition_array":null,
|
|
"subpartition_array":null,
|
|
"index_status":1,
|
|
"binding":false,
|
|
"duplicate_scope":0
|
|
},
|
|
"max_used_column_id":0,
|
|
"max_used_constraint_id":0,
|
|
"sess_active_time":0,
|
|
"rowkey_column_num":0,
|
|
"index_column_num":0,
|
|
"rowkey_split_pos":0,
|
|
"block_size":16384,
|
|
"is_use_bloomfilter":false,
|
|
"progressive_merge_num":0,
|
|
"tablet_size":-1,
|
|
"pctfree":10,
|
|
"load_type":0,
|
|
"index_using_type":0,
|
|
"def_type":1,
|
|
"charset_type":0,
|
|
"collation_type":0,
|
|
"create_mem_version":0,
|
|
"index_status":1,
|
|
"partition_status":0,
|
|
"code_version":1,
|
|
"last_modified_frozen_version":0,
|
|
"comment":"",
|
|
"pk_comment":"",
|
|
"create_host":"",
|
|
"zone_replica_attr_array": [
|
|
],
|
|
"region_replica_num_array": [
|
|
],
|
|
"tablegroup_name":"",
|
|
"compress_func_name":"",
|
|
"row_store_type":3,
|
|
"store_format":0,
|
|
"expire_info":"",
|
|
"view_schema": {
|
|
"view_definition":"",
|
|
"check_option":"none",
|
|
"is_updatable":"false",
|
|
"is_materialized":"false"
|
|
},
|
|
"autoinc_column_id":0,
|
|
"auto_increment":1,
|
|
"read_only":false,
|
|
"primary_zone_array": [
|
|
],
|
|
"index_tid_array": [
|
|
],
|
|
"mv_tid_array": [
|
|
],
|
|
"aux_vp_tid_array": [
|
|
],
|
|
"base_table_ids": [
|
|
],
|
|
"rowkey_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"partition_key_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"aux_vp_tid_array": [
|
|
]
|
|
}
|
|
},
|
|
"nls_formats": [
|
|
"",
|
|
"",
|
|
""
|
|
]
|
|
},
|
|
"index_arg_list": [
|
|
]
|
|
}
|
|
*************** Case 31 ***************
|
|
ALTER TABLE default_t1 ADD dt3 datetime not null default '2015-07-16 10:10:30';
|
|
{
|
|
"ObTableStmt": {
|
|
"partition_fun_expr": [
|
|
],
|
|
"range_values_exprs": [
|
|
],
|
|
"list_values_exprs": [
|
|
],
|
|
"index_partition_resolve_results": [
|
|
],
|
|
"part_type":8
|
|
},
|
|
"stmt_type":22,
|
|
"alter_table_arg": {
|
|
"is_alter_columns":true,
|
|
"is_alter_indexs":false,
|
|
"is_alter_options":false,
|
|
"session_id":-1,
|
|
"index_arg_list": [
|
|
],
|
|
"alter_table_schema": {
|
|
"alter_type":"OB_INVALID_DDL_OP",
|
|
"origin_table_name":"default_t1",
|
|
"new_database_name":"defaultvalue",
|
|
"origin_database_name":"defaultvalue",
|
|
"split_partition_name":"",
|
|
"alter_table_schema": {
|
|
"simple_table_schema": {
|
|
"tenant_id":1,
|
|
"database_id":-1,
|
|
"tablegroup_id":-1,
|
|
"table_id":-1,
|
|
"table_name":"default_t1",
|
|
"replica_num":0,
|
|
"previous_locality_str":"",
|
|
"min_partition_id":0,
|
|
"session_id":0,
|
|
"index_type":0,
|
|
"table_type":3,
|
|
"data_table_id":0,
|
|
"name_casemode":-1,
|
|
"schema_version":0,
|
|
"part_level":0,
|
|
"part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"sub_part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"locality_str":"",
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"part_num":0,
|
|
"subpart_num":0,
|
|
"partition_num":0,
|
|
"subpartition_num":0,
|
|
"partition_array":null,
|
|
"subpartition_array":null,
|
|
"index_status":1,
|
|
"binding":false,
|
|
"duplicate_scope":0
|
|
},
|
|
"max_used_column_id":0,
|
|
"max_used_constraint_id":0,
|
|
"sess_active_time":0,
|
|
"rowkey_column_num":0,
|
|
"index_column_num":0,
|
|
"rowkey_split_pos":0,
|
|
"block_size":16384,
|
|
"is_use_bloomfilter":false,
|
|
"progressive_merge_num":0,
|
|
"tablet_size":-1,
|
|
"pctfree":10,
|
|
"load_type":0,
|
|
"index_using_type":0,
|
|
"def_type":1,
|
|
"charset_type":0,
|
|
"collation_type":0,
|
|
"create_mem_version":0,
|
|
"index_status":1,
|
|
"partition_status":0,
|
|
"code_version":1,
|
|
"last_modified_frozen_version":0,
|
|
"comment":"",
|
|
"pk_comment":"",
|
|
"create_host":"",
|
|
"zone_replica_attr_array": [
|
|
],
|
|
"region_replica_num_array": [
|
|
],
|
|
"tablegroup_name":"",
|
|
"compress_func_name":"",
|
|
"row_store_type":3,
|
|
"store_format":0,
|
|
"expire_info":"",
|
|
"view_schema": {
|
|
"view_definition":"",
|
|
"check_option":"none",
|
|
"is_updatable":"false",
|
|
"is_materialized":"false"
|
|
},
|
|
"autoinc_column_id":0,
|
|
"auto_increment":1,
|
|
"read_only":false,
|
|
"primary_zone_array": [
|
|
],
|
|
"index_tid_array": [
|
|
],
|
|
"mv_tid_array": [
|
|
],
|
|
"aux_vp_tid_array": [
|
|
],
|
|
"base_table_ids": [
|
|
],
|
|
"rowkey_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"partition_key_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"aux_vp_tid_array": [
|
|
]
|
|
}
|
|
},
|
|
"nls_formats": [
|
|
"",
|
|
"",
|
|
""
|
|
]
|
|
},
|
|
"index_arg_list": [
|
|
]
|
|
}
|
|
*************** Case 32 ***************
|
|
ALTER TABLE default_t1 ADD n1 number;
|
|
{
|
|
"ObTableStmt": {
|
|
"partition_fun_expr": [
|
|
],
|
|
"range_values_exprs": [
|
|
],
|
|
"list_values_exprs": [
|
|
],
|
|
"index_partition_resolve_results": [
|
|
],
|
|
"part_type":8
|
|
},
|
|
"stmt_type":22,
|
|
"alter_table_arg": {
|
|
"is_alter_columns":true,
|
|
"is_alter_indexs":false,
|
|
"is_alter_options":false,
|
|
"session_id":-1,
|
|
"index_arg_list": [
|
|
],
|
|
"alter_table_schema": {
|
|
"alter_type":"OB_INVALID_DDL_OP",
|
|
"origin_table_name":"default_t1",
|
|
"new_database_name":"defaultvalue",
|
|
"origin_database_name":"defaultvalue",
|
|
"split_partition_name":"",
|
|
"alter_table_schema": {
|
|
"simple_table_schema": {
|
|
"tenant_id":1,
|
|
"database_id":-1,
|
|
"tablegroup_id":-1,
|
|
"table_id":-1,
|
|
"table_name":"default_t1",
|
|
"replica_num":0,
|
|
"previous_locality_str":"",
|
|
"min_partition_id":0,
|
|
"session_id":0,
|
|
"index_type":0,
|
|
"table_type":3,
|
|
"data_table_id":0,
|
|
"name_casemode":-1,
|
|
"schema_version":0,
|
|
"part_level":0,
|
|
"part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"sub_part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"locality_str":"",
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"part_num":0,
|
|
"subpart_num":0,
|
|
"partition_num":0,
|
|
"subpartition_num":0,
|
|
"partition_array":null,
|
|
"subpartition_array":null,
|
|
"index_status":1,
|
|
"binding":false,
|
|
"duplicate_scope":0
|
|
},
|
|
"max_used_column_id":0,
|
|
"max_used_constraint_id":0,
|
|
"sess_active_time":0,
|
|
"rowkey_column_num":0,
|
|
"index_column_num":0,
|
|
"rowkey_split_pos":0,
|
|
"block_size":16384,
|
|
"is_use_bloomfilter":false,
|
|
"progressive_merge_num":0,
|
|
"tablet_size":-1,
|
|
"pctfree":10,
|
|
"load_type":0,
|
|
"index_using_type":0,
|
|
"def_type":1,
|
|
"charset_type":0,
|
|
"collation_type":0,
|
|
"create_mem_version":0,
|
|
"index_status":1,
|
|
"partition_status":0,
|
|
"code_version":1,
|
|
"last_modified_frozen_version":0,
|
|
"comment":"",
|
|
"pk_comment":"",
|
|
"create_host":"",
|
|
"zone_replica_attr_array": [
|
|
],
|
|
"region_replica_num_array": [
|
|
],
|
|
"tablegroup_name":"",
|
|
"compress_func_name":"",
|
|
"row_store_type":3,
|
|
"store_format":0,
|
|
"expire_info":"",
|
|
"view_schema": {
|
|
"view_definition":"",
|
|
"check_option":"none",
|
|
"is_updatable":"false",
|
|
"is_materialized":"false"
|
|
},
|
|
"autoinc_column_id":0,
|
|
"auto_increment":1,
|
|
"read_only":false,
|
|
"primary_zone_array": [
|
|
],
|
|
"index_tid_array": [
|
|
],
|
|
"mv_tid_array": [
|
|
],
|
|
"aux_vp_tid_array": [
|
|
],
|
|
"base_table_ids": [
|
|
],
|
|
"rowkey_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"partition_key_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"aux_vp_tid_array": [
|
|
]
|
|
}
|
|
},
|
|
"nls_formats": [
|
|
"",
|
|
"",
|
|
""
|
|
]
|
|
},
|
|
"index_arg_list": [
|
|
]
|
|
}
|
|
*************** Case 33 ***************
|
|
ALTER TABLE default_t1 ADD n2 number not null;
|
|
{
|
|
"ObTableStmt": {
|
|
"partition_fun_expr": [
|
|
],
|
|
"range_values_exprs": [
|
|
],
|
|
"list_values_exprs": [
|
|
],
|
|
"index_partition_resolve_results": [
|
|
],
|
|
"part_type":8
|
|
},
|
|
"stmt_type":22,
|
|
"alter_table_arg": {
|
|
"is_alter_columns":true,
|
|
"is_alter_indexs":false,
|
|
"is_alter_options":false,
|
|
"session_id":-1,
|
|
"index_arg_list": [
|
|
],
|
|
"alter_table_schema": {
|
|
"alter_type":"OB_INVALID_DDL_OP",
|
|
"origin_table_name":"default_t1",
|
|
"new_database_name":"defaultvalue",
|
|
"origin_database_name":"defaultvalue",
|
|
"split_partition_name":"",
|
|
"alter_table_schema": {
|
|
"simple_table_schema": {
|
|
"tenant_id":1,
|
|
"database_id":-1,
|
|
"tablegroup_id":-1,
|
|
"table_id":-1,
|
|
"table_name":"default_t1",
|
|
"replica_num":0,
|
|
"previous_locality_str":"",
|
|
"min_partition_id":0,
|
|
"session_id":0,
|
|
"index_type":0,
|
|
"table_type":3,
|
|
"data_table_id":0,
|
|
"name_casemode":-1,
|
|
"schema_version":0,
|
|
"part_level":0,
|
|
"part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"sub_part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"locality_str":"",
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"part_num":0,
|
|
"subpart_num":0,
|
|
"partition_num":0,
|
|
"subpartition_num":0,
|
|
"partition_array":null,
|
|
"subpartition_array":null,
|
|
"index_status":1,
|
|
"binding":false,
|
|
"duplicate_scope":0
|
|
},
|
|
"max_used_column_id":0,
|
|
"max_used_constraint_id":0,
|
|
"sess_active_time":0,
|
|
"rowkey_column_num":0,
|
|
"index_column_num":0,
|
|
"rowkey_split_pos":0,
|
|
"block_size":16384,
|
|
"is_use_bloomfilter":false,
|
|
"progressive_merge_num":0,
|
|
"tablet_size":-1,
|
|
"pctfree":10,
|
|
"load_type":0,
|
|
"index_using_type":0,
|
|
"def_type":1,
|
|
"charset_type":0,
|
|
"collation_type":0,
|
|
"create_mem_version":0,
|
|
"index_status":1,
|
|
"partition_status":0,
|
|
"code_version":1,
|
|
"last_modified_frozen_version":0,
|
|
"comment":"",
|
|
"pk_comment":"",
|
|
"create_host":"",
|
|
"zone_replica_attr_array": [
|
|
],
|
|
"region_replica_num_array": [
|
|
],
|
|
"tablegroup_name":"",
|
|
"compress_func_name":"",
|
|
"row_store_type":3,
|
|
"store_format":0,
|
|
"expire_info":"",
|
|
"view_schema": {
|
|
"view_definition":"",
|
|
"check_option":"none",
|
|
"is_updatable":"false",
|
|
"is_materialized":"false"
|
|
},
|
|
"autoinc_column_id":0,
|
|
"auto_increment":1,
|
|
"read_only":false,
|
|
"primary_zone_array": [
|
|
],
|
|
"index_tid_array": [
|
|
],
|
|
"mv_tid_array": [
|
|
],
|
|
"aux_vp_tid_array": [
|
|
],
|
|
"base_table_ids": [
|
|
],
|
|
"rowkey_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"partition_key_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"aux_vp_tid_array": [
|
|
]
|
|
}
|
|
},
|
|
"nls_formats": [
|
|
"",
|
|
"",
|
|
""
|
|
]
|
|
},
|
|
"index_arg_list": [
|
|
]
|
|
}
|
|
*************** Case 34 ***************
|
|
ALTER TABLE default_t1 ADD n3 number not null default 1111;
|
|
{
|
|
"ObTableStmt": {
|
|
"partition_fun_expr": [
|
|
],
|
|
"range_values_exprs": [
|
|
],
|
|
"list_values_exprs": [
|
|
],
|
|
"index_partition_resolve_results": [
|
|
],
|
|
"part_type":8
|
|
},
|
|
"stmt_type":22,
|
|
"alter_table_arg": {
|
|
"is_alter_columns":true,
|
|
"is_alter_indexs":false,
|
|
"is_alter_options":false,
|
|
"session_id":-1,
|
|
"index_arg_list": [
|
|
],
|
|
"alter_table_schema": {
|
|
"alter_type":"OB_INVALID_DDL_OP",
|
|
"origin_table_name":"default_t1",
|
|
"new_database_name":"defaultvalue",
|
|
"origin_database_name":"defaultvalue",
|
|
"split_partition_name":"",
|
|
"alter_table_schema": {
|
|
"simple_table_schema": {
|
|
"tenant_id":1,
|
|
"database_id":-1,
|
|
"tablegroup_id":-1,
|
|
"table_id":-1,
|
|
"table_name":"default_t1",
|
|
"replica_num":0,
|
|
"previous_locality_str":"",
|
|
"min_partition_id":0,
|
|
"session_id":0,
|
|
"index_type":0,
|
|
"table_type":3,
|
|
"data_table_id":0,
|
|
"name_casemode":-1,
|
|
"schema_version":0,
|
|
"part_level":0,
|
|
"part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"sub_part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"locality_str":"",
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"part_num":0,
|
|
"subpart_num":0,
|
|
"partition_num":0,
|
|
"subpartition_num":0,
|
|
"partition_array":null,
|
|
"subpartition_array":null,
|
|
"index_status":1,
|
|
"binding":false,
|
|
"duplicate_scope":0
|
|
},
|
|
"max_used_column_id":0,
|
|
"max_used_constraint_id":0,
|
|
"sess_active_time":0,
|
|
"rowkey_column_num":0,
|
|
"index_column_num":0,
|
|
"rowkey_split_pos":0,
|
|
"block_size":16384,
|
|
"is_use_bloomfilter":false,
|
|
"progressive_merge_num":0,
|
|
"tablet_size":-1,
|
|
"pctfree":10,
|
|
"load_type":0,
|
|
"index_using_type":0,
|
|
"def_type":1,
|
|
"charset_type":0,
|
|
"collation_type":0,
|
|
"create_mem_version":0,
|
|
"index_status":1,
|
|
"partition_status":0,
|
|
"code_version":1,
|
|
"last_modified_frozen_version":0,
|
|
"comment":"",
|
|
"pk_comment":"",
|
|
"create_host":"",
|
|
"zone_replica_attr_array": [
|
|
],
|
|
"region_replica_num_array": [
|
|
],
|
|
"tablegroup_name":"",
|
|
"compress_func_name":"",
|
|
"row_store_type":3,
|
|
"store_format":0,
|
|
"expire_info":"",
|
|
"view_schema": {
|
|
"view_definition":"",
|
|
"check_option":"none",
|
|
"is_updatable":"false",
|
|
"is_materialized":"false"
|
|
},
|
|
"autoinc_column_id":0,
|
|
"auto_increment":1,
|
|
"read_only":false,
|
|
"primary_zone_array": [
|
|
],
|
|
"index_tid_array": [
|
|
],
|
|
"mv_tid_array": [
|
|
],
|
|
"aux_vp_tid_array": [
|
|
],
|
|
"base_table_ids": [
|
|
],
|
|
"rowkey_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"partition_key_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"aux_vp_tid_array": [
|
|
]
|
|
}
|
|
},
|
|
"nls_formats": [
|
|
"",
|
|
"",
|
|
""
|
|
]
|
|
},
|
|
"index_arg_list": [
|
|
]
|
|
}
|
|
*************** Case 35 ***************
|
|
ALTER TABLE default_t1 ADD c1 char;
|
|
{
|
|
"ObTableStmt": {
|
|
"partition_fun_expr": [
|
|
],
|
|
"range_values_exprs": [
|
|
],
|
|
"list_values_exprs": [
|
|
],
|
|
"index_partition_resolve_results": [
|
|
],
|
|
"part_type":8
|
|
},
|
|
"stmt_type":22,
|
|
"alter_table_arg": {
|
|
"is_alter_columns":true,
|
|
"is_alter_indexs":false,
|
|
"is_alter_options":false,
|
|
"session_id":-1,
|
|
"index_arg_list": [
|
|
],
|
|
"alter_table_schema": {
|
|
"alter_type":"OB_INVALID_DDL_OP",
|
|
"origin_table_name":"default_t1",
|
|
"new_database_name":"defaultvalue",
|
|
"origin_database_name":"defaultvalue",
|
|
"split_partition_name":"",
|
|
"alter_table_schema": {
|
|
"simple_table_schema": {
|
|
"tenant_id":1,
|
|
"database_id":-1,
|
|
"tablegroup_id":-1,
|
|
"table_id":-1,
|
|
"table_name":"default_t1",
|
|
"replica_num":0,
|
|
"previous_locality_str":"",
|
|
"min_partition_id":0,
|
|
"session_id":0,
|
|
"index_type":0,
|
|
"table_type":3,
|
|
"data_table_id":0,
|
|
"name_casemode":-1,
|
|
"schema_version":0,
|
|
"part_level":0,
|
|
"part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"sub_part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"locality_str":"",
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"part_num":0,
|
|
"subpart_num":0,
|
|
"partition_num":0,
|
|
"subpartition_num":0,
|
|
"partition_array":null,
|
|
"subpartition_array":null,
|
|
"index_status":1,
|
|
"binding":false,
|
|
"duplicate_scope":0
|
|
},
|
|
"max_used_column_id":0,
|
|
"max_used_constraint_id":0,
|
|
"sess_active_time":0,
|
|
"rowkey_column_num":0,
|
|
"index_column_num":0,
|
|
"rowkey_split_pos":0,
|
|
"block_size":16384,
|
|
"is_use_bloomfilter":false,
|
|
"progressive_merge_num":0,
|
|
"tablet_size":-1,
|
|
"pctfree":10,
|
|
"load_type":0,
|
|
"index_using_type":0,
|
|
"def_type":1,
|
|
"charset_type":0,
|
|
"collation_type":0,
|
|
"create_mem_version":0,
|
|
"index_status":1,
|
|
"partition_status":0,
|
|
"code_version":1,
|
|
"last_modified_frozen_version":0,
|
|
"comment":"",
|
|
"pk_comment":"",
|
|
"create_host":"",
|
|
"zone_replica_attr_array": [
|
|
],
|
|
"region_replica_num_array": [
|
|
],
|
|
"tablegroup_name":"",
|
|
"compress_func_name":"",
|
|
"row_store_type":3,
|
|
"store_format":0,
|
|
"expire_info":"",
|
|
"view_schema": {
|
|
"view_definition":"",
|
|
"check_option":"none",
|
|
"is_updatable":"false",
|
|
"is_materialized":"false"
|
|
},
|
|
"autoinc_column_id":0,
|
|
"auto_increment":1,
|
|
"read_only":false,
|
|
"primary_zone_array": [
|
|
],
|
|
"index_tid_array": [
|
|
],
|
|
"mv_tid_array": [
|
|
],
|
|
"aux_vp_tid_array": [
|
|
],
|
|
"base_table_ids": [
|
|
],
|
|
"rowkey_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"partition_key_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"aux_vp_tid_array": [
|
|
]
|
|
}
|
|
},
|
|
"nls_formats": [
|
|
"",
|
|
"",
|
|
""
|
|
]
|
|
},
|
|
"index_arg_list": [
|
|
]
|
|
}
|
|
*************** Case 36 ***************
|
|
ALTER TABLE default_t1 ADD c2 char not null;
|
|
{
|
|
"ObTableStmt": {
|
|
"partition_fun_expr": [
|
|
],
|
|
"range_values_exprs": [
|
|
],
|
|
"list_values_exprs": [
|
|
],
|
|
"index_partition_resolve_results": [
|
|
],
|
|
"part_type":8
|
|
},
|
|
"stmt_type":22,
|
|
"alter_table_arg": {
|
|
"is_alter_columns":true,
|
|
"is_alter_indexs":false,
|
|
"is_alter_options":false,
|
|
"session_id":-1,
|
|
"index_arg_list": [
|
|
],
|
|
"alter_table_schema": {
|
|
"alter_type":"OB_INVALID_DDL_OP",
|
|
"origin_table_name":"default_t1",
|
|
"new_database_name":"defaultvalue",
|
|
"origin_database_name":"defaultvalue",
|
|
"split_partition_name":"",
|
|
"alter_table_schema": {
|
|
"simple_table_schema": {
|
|
"tenant_id":1,
|
|
"database_id":-1,
|
|
"tablegroup_id":-1,
|
|
"table_id":-1,
|
|
"table_name":"default_t1",
|
|
"replica_num":0,
|
|
"previous_locality_str":"",
|
|
"min_partition_id":0,
|
|
"session_id":0,
|
|
"index_type":0,
|
|
"table_type":3,
|
|
"data_table_id":0,
|
|
"name_casemode":-1,
|
|
"schema_version":0,
|
|
"part_level":0,
|
|
"part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"sub_part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"locality_str":"",
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"part_num":0,
|
|
"subpart_num":0,
|
|
"partition_num":0,
|
|
"subpartition_num":0,
|
|
"partition_array":null,
|
|
"subpartition_array":null,
|
|
"index_status":1,
|
|
"binding":false,
|
|
"duplicate_scope":0
|
|
},
|
|
"max_used_column_id":0,
|
|
"max_used_constraint_id":0,
|
|
"sess_active_time":0,
|
|
"rowkey_column_num":0,
|
|
"index_column_num":0,
|
|
"rowkey_split_pos":0,
|
|
"block_size":16384,
|
|
"is_use_bloomfilter":false,
|
|
"progressive_merge_num":0,
|
|
"tablet_size":-1,
|
|
"pctfree":10,
|
|
"load_type":0,
|
|
"index_using_type":0,
|
|
"def_type":1,
|
|
"charset_type":0,
|
|
"collation_type":0,
|
|
"create_mem_version":0,
|
|
"index_status":1,
|
|
"partition_status":0,
|
|
"code_version":1,
|
|
"last_modified_frozen_version":0,
|
|
"comment":"",
|
|
"pk_comment":"",
|
|
"create_host":"",
|
|
"zone_replica_attr_array": [
|
|
],
|
|
"region_replica_num_array": [
|
|
],
|
|
"tablegroup_name":"",
|
|
"compress_func_name":"",
|
|
"row_store_type":3,
|
|
"store_format":0,
|
|
"expire_info":"",
|
|
"view_schema": {
|
|
"view_definition":"",
|
|
"check_option":"none",
|
|
"is_updatable":"false",
|
|
"is_materialized":"false"
|
|
},
|
|
"autoinc_column_id":0,
|
|
"auto_increment":1,
|
|
"read_only":false,
|
|
"primary_zone_array": [
|
|
],
|
|
"index_tid_array": [
|
|
],
|
|
"mv_tid_array": [
|
|
],
|
|
"aux_vp_tid_array": [
|
|
],
|
|
"base_table_ids": [
|
|
],
|
|
"rowkey_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"partition_key_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"aux_vp_tid_array": [
|
|
]
|
|
}
|
|
},
|
|
"nls_formats": [
|
|
"",
|
|
"",
|
|
""
|
|
]
|
|
},
|
|
"index_arg_list": [
|
|
]
|
|
}
|
|
*************** Case 37 ***************
|
|
ALTER TABLE default_t1 ADD c3 char not null default 'x';
|
|
{
|
|
"ObTableStmt": {
|
|
"partition_fun_expr": [
|
|
],
|
|
"range_values_exprs": [
|
|
],
|
|
"list_values_exprs": [
|
|
],
|
|
"index_partition_resolve_results": [
|
|
],
|
|
"part_type":8
|
|
},
|
|
"stmt_type":22,
|
|
"alter_table_arg": {
|
|
"is_alter_columns":true,
|
|
"is_alter_indexs":false,
|
|
"is_alter_options":false,
|
|
"session_id":-1,
|
|
"index_arg_list": [
|
|
],
|
|
"alter_table_schema": {
|
|
"alter_type":"OB_INVALID_DDL_OP",
|
|
"origin_table_name":"default_t1",
|
|
"new_database_name":"defaultvalue",
|
|
"origin_database_name":"defaultvalue",
|
|
"split_partition_name":"",
|
|
"alter_table_schema": {
|
|
"simple_table_schema": {
|
|
"tenant_id":1,
|
|
"database_id":-1,
|
|
"tablegroup_id":-1,
|
|
"table_id":-1,
|
|
"table_name":"default_t1",
|
|
"replica_num":0,
|
|
"previous_locality_str":"",
|
|
"min_partition_id":0,
|
|
"session_id":0,
|
|
"index_type":0,
|
|
"table_type":3,
|
|
"data_table_id":0,
|
|
"name_casemode":-1,
|
|
"schema_version":0,
|
|
"part_level":0,
|
|
"part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"sub_part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"locality_str":"",
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"part_num":0,
|
|
"subpart_num":0,
|
|
"partition_num":0,
|
|
"subpartition_num":0,
|
|
"partition_array":null,
|
|
"subpartition_array":null,
|
|
"index_status":1,
|
|
"binding":false,
|
|
"duplicate_scope":0
|
|
},
|
|
"max_used_column_id":0,
|
|
"max_used_constraint_id":0,
|
|
"sess_active_time":0,
|
|
"rowkey_column_num":0,
|
|
"index_column_num":0,
|
|
"rowkey_split_pos":0,
|
|
"block_size":16384,
|
|
"is_use_bloomfilter":false,
|
|
"progressive_merge_num":0,
|
|
"tablet_size":-1,
|
|
"pctfree":10,
|
|
"load_type":0,
|
|
"index_using_type":0,
|
|
"def_type":1,
|
|
"charset_type":0,
|
|
"collation_type":0,
|
|
"create_mem_version":0,
|
|
"index_status":1,
|
|
"partition_status":0,
|
|
"code_version":1,
|
|
"last_modified_frozen_version":0,
|
|
"comment":"",
|
|
"pk_comment":"",
|
|
"create_host":"",
|
|
"zone_replica_attr_array": [
|
|
],
|
|
"region_replica_num_array": [
|
|
],
|
|
"tablegroup_name":"",
|
|
"compress_func_name":"",
|
|
"row_store_type":3,
|
|
"store_format":0,
|
|
"expire_info":"",
|
|
"view_schema": {
|
|
"view_definition":"",
|
|
"check_option":"none",
|
|
"is_updatable":"false",
|
|
"is_materialized":"false"
|
|
},
|
|
"autoinc_column_id":0,
|
|
"auto_increment":1,
|
|
"read_only":false,
|
|
"primary_zone_array": [
|
|
],
|
|
"index_tid_array": [
|
|
],
|
|
"mv_tid_array": [
|
|
],
|
|
"aux_vp_tid_array": [
|
|
],
|
|
"base_table_ids": [
|
|
],
|
|
"rowkey_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"partition_key_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"aux_vp_tid_array": [
|
|
]
|
|
}
|
|
},
|
|
"nls_formats": [
|
|
"",
|
|
"",
|
|
""
|
|
]
|
|
},
|
|
"index_arg_list": [
|
|
]
|
|
}
|
|
*************** Case 38 ***************
|
|
ALTER TABLE default_t1 ADD b1 binary;
|
|
{
|
|
"ObTableStmt": {
|
|
"partition_fun_expr": [
|
|
],
|
|
"range_values_exprs": [
|
|
],
|
|
"list_values_exprs": [
|
|
],
|
|
"index_partition_resolve_results": [
|
|
],
|
|
"part_type":8
|
|
},
|
|
"stmt_type":22,
|
|
"alter_table_arg": {
|
|
"is_alter_columns":true,
|
|
"is_alter_indexs":false,
|
|
"is_alter_options":false,
|
|
"session_id":-1,
|
|
"index_arg_list": [
|
|
],
|
|
"alter_table_schema": {
|
|
"alter_type":"OB_INVALID_DDL_OP",
|
|
"origin_table_name":"default_t1",
|
|
"new_database_name":"defaultvalue",
|
|
"origin_database_name":"defaultvalue",
|
|
"split_partition_name":"",
|
|
"alter_table_schema": {
|
|
"simple_table_schema": {
|
|
"tenant_id":1,
|
|
"database_id":-1,
|
|
"tablegroup_id":-1,
|
|
"table_id":-1,
|
|
"table_name":"default_t1",
|
|
"replica_num":0,
|
|
"previous_locality_str":"",
|
|
"min_partition_id":0,
|
|
"session_id":0,
|
|
"index_type":0,
|
|
"table_type":3,
|
|
"data_table_id":0,
|
|
"name_casemode":-1,
|
|
"schema_version":0,
|
|
"part_level":0,
|
|
"part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"sub_part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"locality_str":"",
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"part_num":0,
|
|
"subpart_num":0,
|
|
"partition_num":0,
|
|
"subpartition_num":0,
|
|
"partition_array":null,
|
|
"subpartition_array":null,
|
|
"index_status":1,
|
|
"binding":false,
|
|
"duplicate_scope":0
|
|
},
|
|
"max_used_column_id":0,
|
|
"max_used_constraint_id":0,
|
|
"sess_active_time":0,
|
|
"rowkey_column_num":0,
|
|
"index_column_num":0,
|
|
"rowkey_split_pos":0,
|
|
"block_size":16384,
|
|
"is_use_bloomfilter":false,
|
|
"progressive_merge_num":0,
|
|
"tablet_size":-1,
|
|
"pctfree":10,
|
|
"load_type":0,
|
|
"index_using_type":0,
|
|
"def_type":1,
|
|
"charset_type":0,
|
|
"collation_type":0,
|
|
"create_mem_version":0,
|
|
"index_status":1,
|
|
"partition_status":0,
|
|
"code_version":1,
|
|
"last_modified_frozen_version":0,
|
|
"comment":"",
|
|
"pk_comment":"",
|
|
"create_host":"",
|
|
"zone_replica_attr_array": [
|
|
],
|
|
"region_replica_num_array": [
|
|
],
|
|
"tablegroup_name":"",
|
|
"compress_func_name":"",
|
|
"row_store_type":3,
|
|
"store_format":0,
|
|
"expire_info":"",
|
|
"view_schema": {
|
|
"view_definition":"",
|
|
"check_option":"none",
|
|
"is_updatable":"false",
|
|
"is_materialized":"false"
|
|
},
|
|
"autoinc_column_id":0,
|
|
"auto_increment":1,
|
|
"read_only":false,
|
|
"primary_zone_array": [
|
|
],
|
|
"index_tid_array": [
|
|
],
|
|
"mv_tid_array": [
|
|
],
|
|
"aux_vp_tid_array": [
|
|
],
|
|
"base_table_ids": [
|
|
],
|
|
"rowkey_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"partition_key_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"aux_vp_tid_array": [
|
|
]
|
|
}
|
|
},
|
|
"nls_formats": [
|
|
"",
|
|
"",
|
|
""
|
|
]
|
|
},
|
|
"index_arg_list": [
|
|
]
|
|
}
|
|
*************** Case 39 ***************
|
|
ALTER TABLE default_t1 ADD b2 binary not null;
|
|
{
|
|
"ObTableStmt": {
|
|
"partition_fun_expr": [
|
|
],
|
|
"range_values_exprs": [
|
|
],
|
|
"list_values_exprs": [
|
|
],
|
|
"index_partition_resolve_results": [
|
|
],
|
|
"part_type":8
|
|
},
|
|
"stmt_type":22,
|
|
"alter_table_arg": {
|
|
"is_alter_columns":true,
|
|
"is_alter_indexs":false,
|
|
"is_alter_options":false,
|
|
"session_id":-1,
|
|
"index_arg_list": [
|
|
],
|
|
"alter_table_schema": {
|
|
"alter_type":"OB_INVALID_DDL_OP",
|
|
"origin_table_name":"default_t1",
|
|
"new_database_name":"defaultvalue",
|
|
"origin_database_name":"defaultvalue",
|
|
"split_partition_name":"",
|
|
"alter_table_schema": {
|
|
"simple_table_schema": {
|
|
"tenant_id":1,
|
|
"database_id":-1,
|
|
"tablegroup_id":-1,
|
|
"table_id":-1,
|
|
"table_name":"default_t1",
|
|
"replica_num":0,
|
|
"previous_locality_str":"",
|
|
"min_partition_id":0,
|
|
"session_id":0,
|
|
"index_type":0,
|
|
"table_type":3,
|
|
"data_table_id":0,
|
|
"name_casemode":-1,
|
|
"schema_version":0,
|
|
"part_level":0,
|
|
"part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"sub_part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"locality_str":"",
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"part_num":0,
|
|
"subpart_num":0,
|
|
"partition_num":0,
|
|
"subpartition_num":0,
|
|
"partition_array":null,
|
|
"subpartition_array":null,
|
|
"index_status":1,
|
|
"binding":false,
|
|
"duplicate_scope":0
|
|
},
|
|
"max_used_column_id":0,
|
|
"max_used_constraint_id":0,
|
|
"sess_active_time":0,
|
|
"rowkey_column_num":0,
|
|
"index_column_num":0,
|
|
"rowkey_split_pos":0,
|
|
"block_size":16384,
|
|
"is_use_bloomfilter":false,
|
|
"progressive_merge_num":0,
|
|
"tablet_size":-1,
|
|
"pctfree":10,
|
|
"load_type":0,
|
|
"index_using_type":0,
|
|
"def_type":1,
|
|
"charset_type":0,
|
|
"collation_type":0,
|
|
"create_mem_version":0,
|
|
"index_status":1,
|
|
"partition_status":0,
|
|
"code_version":1,
|
|
"last_modified_frozen_version":0,
|
|
"comment":"",
|
|
"pk_comment":"",
|
|
"create_host":"",
|
|
"zone_replica_attr_array": [
|
|
],
|
|
"region_replica_num_array": [
|
|
],
|
|
"tablegroup_name":"",
|
|
"compress_func_name":"",
|
|
"row_store_type":3,
|
|
"store_format":0,
|
|
"expire_info":"",
|
|
"view_schema": {
|
|
"view_definition":"",
|
|
"check_option":"none",
|
|
"is_updatable":"false",
|
|
"is_materialized":"false"
|
|
},
|
|
"autoinc_column_id":0,
|
|
"auto_increment":1,
|
|
"read_only":false,
|
|
"primary_zone_array": [
|
|
],
|
|
"index_tid_array": [
|
|
],
|
|
"mv_tid_array": [
|
|
],
|
|
"aux_vp_tid_array": [
|
|
],
|
|
"base_table_ids": [
|
|
],
|
|
"rowkey_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"partition_key_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"aux_vp_tid_array": [
|
|
]
|
|
}
|
|
},
|
|
"nls_formats": [
|
|
"",
|
|
"",
|
|
""
|
|
]
|
|
},
|
|
"index_arg_list": [
|
|
]
|
|
}
|
|
*************** Case 40 ***************
|
|
ALTER TABLE default_t1 ADD b3 binary not null default 'xiyu@binary'
|
|
{
|
|
"ObTableStmt": {
|
|
"partition_fun_expr": [
|
|
],
|
|
"range_values_exprs": [
|
|
],
|
|
"list_values_exprs": [
|
|
],
|
|
"index_partition_resolve_results": [
|
|
],
|
|
"part_type":8
|
|
},
|
|
"stmt_type":22,
|
|
"alter_table_arg": {
|
|
"is_alter_columns":true,
|
|
"is_alter_indexs":false,
|
|
"is_alter_options":false,
|
|
"session_id":-1,
|
|
"index_arg_list": [
|
|
],
|
|
"alter_table_schema": {
|
|
"alter_type":"OB_INVALID_DDL_OP",
|
|
"origin_table_name":"default_t1",
|
|
"new_database_name":"defaultvalue",
|
|
"origin_database_name":"defaultvalue",
|
|
"split_partition_name":"",
|
|
"alter_table_schema": {
|
|
"simple_table_schema": {
|
|
"tenant_id":1,
|
|
"database_id":-1,
|
|
"tablegroup_id":-1,
|
|
"table_id":-1,
|
|
"table_name":"default_t1",
|
|
"replica_num":0,
|
|
"previous_locality_str":"",
|
|
"min_partition_id":0,
|
|
"session_id":0,
|
|
"index_type":0,
|
|
"table_type":3,
|
|
"data_table_id":0,
|
|
"name_casemode":-1,
|
|
"schema_version":0,
|
|
"part_level":0,
|
|
"part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"sub_part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"locality_str":"",
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"part_num":0,
|
|
"subpart_num":0,
|
|
"partition_num":0,
|
|
"subpartition_num":0,
|
|
"partition_array":null,
|
|
"subpartition_array":null,
|
|
"index_status":1,
|
|
"binding":false,
|
|
"duplicate_scope":0
|
|
},
|
|
"max_used_column_id":0,
|
|
"max_used_constraint_id":0,
|
|
"sess_active_time":0,
|
|
"rowkey_column_num":0,
|
|
"index_column_num":0,
|
|
"rowkey_split_pos":0,
|
|
"block_size":16384,
|
|
"is_use_bloomfilter":false,
|
|
"progressive_merge_num":0,
|
|
"tablet_size":-1,
|
|
"pctfree":10,
|
|
"load_type":0,
|
|
"index_using_type":0,
|
|
"def_type":1,
|
|
"charset_type":0,
|
|
"collation_type":0,
|
|
"create_mem_version":0,
|
|
"index_status":1,
|
|
"partition_status":0,
|
|
"code_version":1,
|
|
"last_modified_frozen_version":0,
|
|
"comment":"",
|
|
"pk_comment":"",
|
|
"create_host":"",
|
|
"zone_replica_attr_array": [
|
|
],
|
|
"region_replica_num_array": [
|
|
],
|
|
"tablegroup_name":"",
|
|
"compress_func_name":"",
|
|
"row_store_type":3,
|
|
"store_format":0,
|
|
"expire_info":"",
|
|
"view_schema": {
|
|
"view_definition":"",
|
|
"check_option":"none",
|
|
"is_updatable":"false",
|
|
"is_materialized":"false"
|
|
},
|
|
"autoinc_column_id":0,
|
|
"auto_increment":1,
|
|
"read_only":false,
|
|
"primary_zone_array": [
|
|
],
|
|
"index_tid_array": [
|
|
],
|
|
"mv_tid_array": [
|
|
],
|
|
"aux_vp_tid_array": [
|
|
],
|
|
"base_table_ids": [
|
|
],
|
|
"rowkey_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"partition_key_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"aux_vp_tid_array": [
|
|
]
|
|
}
|
|
},
|
|
"nls_formats": [
|
|
"",
|
|
"",
|
|
""
|
|
]
|
|
},
|
|
"index_arg_list": [
|
|
]
|
|
}
|
|
*************** Case 41 ***************
|
|
ALTER TABLE default_t1 ADD vb1 varbinary(1000);
|
|
{
|
|
"ObTableStmt": {
|
|
"partition_fun_expr": [
|
|
],
|
|
"range_values_exprs": [
|
|
],
|
|
"list_values_exprs": [
|
|
],
|
|
"index_partition_resolve_results": [
|
|
],
|
|
"part_type":8
|
|
},
|
|
"stmt_type":22,
|
|
"alter_table_arg": {
|
|
"is_alter_columns":true,
|
|
"is_alter_indexs":false,
|
|
"is_alter_options":false,
|
|
"session_id":-1,
|
|
"index_arg_list": [
|
|
],
|
|
"alter_table_schema": {
|
|
"alter_type":"OB_INVALID_DDL_OP",
|
|
"origin_table_name":"default_t1",
|
|
"new_database_name":"defaultvalue",
|
|
"origin_database_name":"defaultvalue",
|
|
"split_partition_name":"",
|
|
"alter_table_schema": {
|
|
"simple_table_schema": {
|
|
"tenant_id":1,
|
|
"database_id":-1,
|
|
"tablegroup_id":-1,
|
|
"table_id":-1,
|
|
"table_name":"default_t1",
|
|
"replica_num":0,
|
|
"previous_locality_str":"",
|
|
"min_partition_id":0,
|
|
"session_id":0,
|
|
"index_type":0,
|
|
"table_type":3,
|
|
"data_table_id":0,
|
|
"name_casemode":-1,
|
|
"schema_version":0,
|
|
"part_level":0,
|
|
"part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"sub_part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"locality_str":"",
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"part_num":0,
|
|
"subpart_num":0,
|
|
"partition_num":0,
|
|
"subpartition_num":0,
|
|
"partition_array":null,
|
|
"subpartition_array":null,
|
|
"index_status":1,
|
|
"binding":false,
|
|
"duplicate_scope":0
|
|
},
|
|
"max_used_column_id":0,
|
|
"max_used_constraint_id":0,
|
|
"sess_active_time":0,
|
|
"rowkey_column_num":0,
|
|
"index_column_num":0,
|
|
"rowkey_split_pos":0,
|
|
"block_size":16384,
|
|
"is_use_bloomfilter":false,
|
|
"progressive_merge_num":0,
|
|
"tablet_size":-1,
|
|
"pctfree":10,
|
|
"load_type":0,
|
|
"index_using_type":0,
|
|
"def_type":1,
|
|
"charset_type":0,
|
|
"collation_type":0,
|
|
"create_mem_version":0,
|
|
"index_status":1,
|
|
"partition_status":0,
|
|
"code_version":1,
|
|
"last_modified_frozen_version":0,
|
|
"comment":"",
|
|
"pk_comment":"",
|
|
"create_host":"",
|
|
"zone_replica_attr_array": [
|
|
],
|
|
"region_replica_num_array": [
|
|
],
|
|
"tablegroup_name":"",
|
|
"compress_func_name":"",
|
|
"row_store_type":3,
|
|
"store_format":0,
|
|
"expire_info":"",
|
|
"view_schema": {
|
|
"view_definition":"",
|
|
"check_option":"none",
|
|
"is_updatable":"false",
|
|
"is_materialized":"false"
|
|
},
|
|
"autoinc_column_id":0,
|
|
"auto_increment":1,
|
|
"read_only":false,
|
|
"primary_zone_array": [
|
|
],
|
|
"index_tid_array": [
|
|
],
|
|
"mv_tid_array": [
|
|
],
|
|
"aux_vp_tid_array": [
|
|
],
|
|
"base_table_ids": [
|
|
],
|
|
"rowkey_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"partition_key_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"aux_vp_tid_array": [
|
|
]
|
|
}
|
|
},
|
|
"nls_formats": [
|
|
"",
|
|
"",
|
|
""
|
|
]
|
|
},
|
|
"index_arg_list": [
|
|
]
|
|
}
|
|
*************** Case 42 ***************
|
|
ALTER TABLE default_t1 ADD vb2 varbinary(1000) not null;
|
|
{
|
|
"ObTableStmt": {
|
|
"partition_fun_expr": [
|
|
],
|
|
"range_values_exprs": [
|
|
],
|
|
"list_values_exprs": [
|
|
],
|
|
"index_partition_resolve_results": [
|
|
],
|
|
"part_type":8
|
|
},
|
|
"stmt_type":22,
|
|
"alter_table_arg": {
|
|
"is_alter_columns":true,
|
|
"is_alter_indexs":false,
|
|
"is_alter_options":false,
|
|
"session_id":-1,
|
|
"index_arg_list": [
|
|
],
|
|
"alter_table_schema": {
|
|
"alter_type":"OB_INVALID_DDL_OP",
|
|
"origin_table_name":"default_t1",
|
|
"new_database_name":"defaultvalue",
|
|
"origin_database_name":"defaultvalue",
|
|
"split_partition_name":"",
|
|
"alter_table_schema": {
|
|
"simple_table_schema": {
|
|
"tenant_id":1,
|
|
"database_id":-1,
|
|
"tablegroup_id":-1,
|
|
"table_id":-1,
|
|
"table_name":"default_t1",
|
|
"replica_num":0,
|
|
"previous_locality_str":"",
|
|
"min_partition_id":0,
|
|
"session_id":0,
|
|
"index_type":0,
|
|
"table_type":3,
|
|
"data_table_id":0,
|
|
"name_casemode":-1,
|
|
"schema_version":0,
|
|
"part_level":0,
|
|
"part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"sub_part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"locality_str":"",
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"part_num":0,
|
|
"subpart_num":0,
|
|
"partition_num":0,
|
|
"subpartition_num":0,
|
|
"partition_array":null,
|
|
"subpartition_array":null,
|
|
"index_status":1,
|
|
"binding":false,
|
|
"duplicate_scope":0
|
|
},
|
|
"max_used_column_id":0,
|
|
"max_used_constraint_id":0,
|
|
"sess_active_time":0,
|
|
"rowkey_column_num":0,
|
|
"index_column_num":0,
|
|
"rowkey_split_pos":0,
|
|
"block_size":16384,
|
|
"is_use_bloomfilter":false,
|
|
"progressive_merge_num":0,
|
|
"tablet_size":-1,
|
|
"pctfree":10,
|
|
"load_type":0,
|
|
"index_using_type":0,
|
|
"def_type":1,
|
|
"charset_type":0,
|
|
"collation_type":0,
|
|
"create_mem_version":0,
|
|
"index_status":1,
|
|
"partition_status":0,
|
|
"code_version":1,
|
|
"last_modified_frozen_version":0,
|
|
"comment":"",
|
|
"pk_comment":"",
|
|
"create_host":"",
|
|
"zone_replica_attr_array": [
|
|
],
|
|
"region_replica_num_array": [
|
|
],
|
|
"tablegroup_name":"",
|
|
"compress_func_name":"",
|
|
"row_store_type":3,
|
|
"store_format":0,
|
|
"expire_info":"",
|
|
"view_schema": {
|
|
"view_definition":"",
|
|
"check_option":"none",
|
|
"is_updatable":"false",
|
|
"is_materialized":"false"
|
|
},
|
|
"autoinc_column_id":0,
|
|
"auto_increment":1,
|
|
"read_only":false,
|
|
"primary_zone_array": [
|
|
],
|
|
"index_tid_array": [
|
|
],
|
|
"mv_tid_array": [
|
|
],
|
|
"aux_vp_tid_array": [
|
|
],
|
|
"base_table_ids": [
|
|
],
|
|
"rowkey_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"partition_key_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"aux_vp_tid_array": [
|
|
]
|
|
}
|
|
},
|
|
"nls_formats": [
|
|
"",
|
|
"",
|
|
""
|
|
]
|
|
},
|
|
"index_arg_list": [
|
|
]
|
|
}
|
|
*************** Case 43 ***************
|
|
ALTER TABLE default_t1 ADD vb3 varbinary(1000) not null default 'xiyu@varbinary@1000';
|
|
{
|
|
"ObTableStmt": {
|
|
"partition_fun_expr": [
|
|
],
|
|
"range_values_exprs": [
|
|
],
|
|
"list_values_exprs": [
|
|
],
|
|
"index_partition_resolve_results": [
|
|
],
|
|
"part_type":8
|
|
},
|
|
"stmt_type":22,
|
|
"alter_table_arg": {
|
|
"is_alter_columns":true,
|
|
"is_alter_indexs":false,
|
|
"is_alter_options":false,
|
|
"session_id":-1,
|
|
"index_arg_list": [
|
|
],
|
|
"alter_table_schema": {
|
|
"alter_type":"OB_INVALID_DDL_OP",
|
|
"origin_table_name":"default_t1",
|
|
"new_database_name":"defaultvalue",
|
|
"origin_database_name":"defaultvalue",
|
|
"split_partition_name":"",
|
|
"alter_table_schema": {
|
|
"simple_table_schema": {
|
|
"tenant_id":1,
|
|
"database_id":-1,
|
|
"tablegroup_id":-1,
|
|
"table_id":-1,
|
|
"table_name":"default_t1",
|
|
"replica_num":0,
|
|
"previous_locality_str":"",
|
|
"min_partition_id":0,
|
|
"session_id":0,
|
|
"index_type":0,
|
|
"table_type":3,
|
|
"data_table_id":0,
|
|
"name_casemode":-1,
|
|
"schema_version":0,
|
|
"part_level":0,
|
|
"part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"sub_part_option": {
|
|
"part_func_type":0,
|
|
"part_func_expr":"",
|
|
"part_num":1,
|
|
"partition_cnt_within_partition_table":-1,
|
|
"max_used_part_id":-1
|
|
},
|
|
"locality_str":"",
|
|
"zone_list": [
|
|
],
|
|
"primary_zone":"",
|
|
"part_num":0,
|
|
"subpart_num":0,
|
|
"partition_num":0,
|
|
"subpartition_num":0,
|
|
"partition_array":null,
|
|
"subpartition_array":null,
|
|
"index_status":1,
|
|
"binding":false,
|
|
"duplicate_scope":0
|
|
},
|
|
"max_used_column_id":0,
|
|
"max_used_constraint_id":0,
|
|
"sess_active_time":0,
|
|
"rowkey_column_num":0,
|
|
"index_column_num":0,
|
|
"rowkey_split_pos":0,
|
|
"block_size":16384,
|
|
"is_use_bloomfilter":false,
|
|
"progressive_merge_num":0,
|
|
"tablet_size":-1,
|
|
"pctfree":10,
|
|
"load_type":0,
|
|
"index_using_type":0,
|
|
"def_type":1,
|
|
"charset_type":0,
|
|
"collation_type":0,
|
|
"create_mem_version":0,
|
|
"index_status":1,
|
|
"partition_status":0,
|
|
"code_version":1,
|
|
"last_modified_frozen_version":0,
|
|
"comment":"",
|
|
"pk_comment":"",
|
|
"create_host":"",
|
|
"zone_replica_attr_array": [
|
|
],
|
|
"region_replica_num_array": [
|
|
],
|
|
"tablegroup_name":"",
|
|
"compress_func_name":"",
|
|
"row_store_type":3,
|
|
"store_format":0,
|
|
"expire_info":"",
|
|
"view_schema": {
|
|
"view_definition":"",
|
|
"check_option":"none",
|
|
"is_updatable":"false",
|
|
"is_materialized":"false"
|
|
},
|
|
"autoinc_column_id":0,
|
|
"auto_increment":1,
|
|
"read_only":false,
|
|
"primary_zone_array": [
|
|
],
|
|
"index_tid_array": [
|
|
],
|
|
"mv_tid_array": [
|
|
],
|
|
"aux_vp_tid_array": [
|
|
],
|
|
"base_table_ids": [
|
|
],
|
|
"rowkey_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"partition_key_info": {
|
|
"columns":null,
|
|
"capacity":0
|
|
},
|
|
"aux_vp_tid_array": [
|
|
]
|
|
}
|
|
},
|
|
"nls_formats": [
|
|
"",
|
|
"",
|
|
""
|
|
]
|
|
},
|
|
"index_arg_list": [
|
|
]
|
|
}
|
|
*************** Case 44 ***************
|
|
drop database defaultvalue;
|
|
{
|
|
"drop_database_arg":"tenant_id",
|
|
"database_name":"defaultvalue",
|
|
"if_exist":false,
|
|
"to_recyclebin":false
|
|
}
|