*************** Case 1 *************** drop database if exists altertable; { "drop_database_arg":"tenant_id", "database_name":"altertable", "if_exist":true, "to_recyclebin":false } *************** Case 2 *************** create database altertable; { "create_database_arg":"database_schema", "database_id":-1, "schema_version":1, "database_name":"altertable", "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 altertable; { "stmt_type":97 } *************** Case 4 *************** create table ta(c1 int primary key, c2 int auto_increment) comment='test', auto_increment= 5; {"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":false, "schema":{"simple_table_schema":{"tenant_id":1, "database_id":18446744073709551615, "tablegroup_id":1099511627777, "table_id":18446744073709551615, "table_name":"ta", "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":"test", "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":17, "auto_increment":5, "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":16, "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":"altertable", "last_replay_log_id":0, "foreign_key_arg_list":[], "vertical_partition_arg_list":[]}, "index_arg_list":[]} *************** Case 5 *************** create table alter_table1(c1 int primary key, c2 varchar(11) not null default 'c2', c3 tinyint default 3, c4 char(11)) partition by hash(c1) partitions 3; {"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":false, "schema":{"simple_table_schema":{"tenant_id":1, "database_id":18446744073709551615, "tablegroup_id":1099511627777, "table_id":18446744073709551615, "table_name":"alter_table1", "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":1, "part_option":{"part_func_type":0, "part_func_expr":"c1", "part_num":3, "partition_cnt_within_partition_table":-1, "max_used_part_id":2}, "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":3, "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}, {"BasePartition":{"tenant_id":18446744073709551615, "table_id":18446744073709551615, "part_id":1, "name":"p1", "high_bound_val":, "list_row_values":[], "part_idx":1}, "mapping_pg_part_id":-1}, {"BasePartition":{"tenant_id":18446744073709551615, "table_id":18446744073709551615, "part_id":2, "name":"p2", "high_bound_val":, "list_row_values":[], "part_idx":2}, "mapping_pg_part_id":-1}], "subpartition_array":null, "index_status":1, "binding":false, "duplicate_scope":0}, "max_used_column_id":19, "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":16, "type":{"type":"INT", "collation":"binary", "coercibility":"NUMERIC"}, "order":0, "fulltext_flag":false}], "capacity":1}, "partition_key_info":{"columns":[{"length":0, "column_id":16, "type":{"type":"INT", "collation":"binary", "coercibility":"NUMERIC"}, "order":0, "fulltext_flag":false}], "capacity":1}, "aux_vp_tid_array":[]}, "index_arg_list":[], "constraint_list":[], "db_name":"altertable", "last_replay_log_id":0, "foreign_key_arg_list":[], "vertical_partition_arg_list":[]}, "index_arg_list":[]} *************** Case 6 *************** create index idx_c1 on alter_table1(c1) LOCAL; { "stmt_type":23, "create_index_arg": { "index_arg": { "tenant_id":1, "session_id":-1, "index_name":"idx_c1", "table_name":"alter_table1", "database_name":"altertable", "index_action_type":2 }, "index_type":1, "index_columns": [ { "column_name":"c1", "prefix_len":0, "order_type":0, "column_id":-1 } ], "fulltext_columns": [ ], "store_columns": [ ], "index_option": { "block_size":16384, "replica_num":0, "index_status":1, "use_bloom_filter":false, "compress_method":"none", "comment":"", "tablegroup_name":"", "progressive_merge_num":0, "primary_zone":"", "parser_name":"TAOBAO_CHN", "index_attributes_set":0, "row_store_type":3, "store_format":0 }, "index_using_type":0, "data_table_id":-1, "index_table_id":-1, "if_not_exist":false, "index_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"", "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":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":"", "row_store_type":1, "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": [ ] } } } *************** Case 7 *************** create table test(c1 int , c2 int, c3 varchar(50), c4 varchar(50), c5 int , c6 double, c7 int, primary key(c1, c2, c3)); {"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":false, "schema":{"simple_table_schema":{"tenant_id":1, "database_id":18446744073709551615, "tablegroup_id":1099511627777, "table_id":18446744073709551615, "table_name":"test", "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":22, "max_used_constraint_id":0, "sess_active_time":0, "rowkey_column_num":3, "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":16, "type":{"type":"INT", "collation":"binary", "coercibility":"NUMERIC"}, "order":0, "fulltext_flag":false}, {"length":0, "column_id":17, "type":{"type":"INT", "collation":"binary", "coercibility":"NUMERIC"}, "order":0, "fulltext_flag":false}, {"length":50, "column_id":18, "type":{"type":"VARCHAR", "collation":"utf8mb4_general_ci", "coercibility":"INVALID"}, "order":0, "fulltext_flag":false}], "capacity":3}, "partition_key_info":{"columns":null, "capacity":0}, "aux_vp_tid_array":[]}, "index_arg_list":[], "constraint_list":[], "db_name":"altertable", "last_replay_log_id":0, "foreign_key_arg_list":[], "vertical_partition_arg_list":[]}, "index_arg_list":[]} *************** Case 8 *************** create index test_indx on test(c4, c5); { "stmt_type":23, "create_index_arg": { "index_arg": { "tenant_id":1, "session_id":-1, "index_name":"test_indx", "table_name":"test", "database_name":"altertable", "index_action_type":2 }, "index_type":3, "index_columns": [ { "column_name":"c4", "prefix_len":0, "order_type":0, "column_id":-1 }, { "column_name":"c5", "prefix_len":0, "order_type":0, "column_id":-1 } ], "fulltext_columns": [ ], "store_columns": [ ], "index_option": { "block_size":16384, "replica_num":0, "index_status":1, "use_bloom_filter":false, "compress_method":"none", "comment":"", "tablegroup_name":"", "progressive_merge_num":0, "primary_zone":"", "parser_name":"TAOBAO_CHN", "index_attributes_set":0, "row_store_type":3, "store_format":0 }, "index_using_type":0, "data_table_id":-1, "index_table_id":-1, "if_not_exist":false, "index_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"", "replica_num":0, "previous_locality_str":"", "min_partition_id":0, "session_id":0, "index_type":3, "table_type":5, "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":20, "max_used_constraint_id":0, "sess_active_time":0, "rowkey_column_num":5, "index_column_num":2, "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":"", "row_store_type":1, "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": [ { "length":50, "column_id":19, "type": { "type":"VARCHAR", "collation":"utf8mb4_general_ci", "coercibility":"INVALID" }, "order":0, "fulltext_flag":false }, { "length":0, "column_id":20, "type": { "type":"INT", "collation":"binary", "coercibility":"NUMERIC" }, "order":0, "fulltext_flag":false }, { "length":0, "column_id":16, "type": { "type":"INT", "collation":"binary", "coercibility":"NUMERIC" }, "order":0, "fulltext_flag":false }, { "length":0, "column_id":17, "type": { "type":"INT", "collation":"binary", "coercibility":"NUMERIC" }, "order":0, "fulltext_flag":false }, { "length":50, "column_id":18, "type": { "type":"VARCHAR", "collation":"utf8mb4_general_ci", "coercibility":"INVALID" }, "order":0, "fulltext_flag":false } ], "capacity":5 }, "partition_key_info": { "columns":null, "capacity":0 }, "aux_vp_tid_array": [ ] } } } *************** Case 9 *************** alter table alter_table1 add column nc3 int null default 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":"alter_table1", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"alter_table1", "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 alter_table1 add (nc3 int null default 0, nc4 varchar(11)) { "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":"alter_table1", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"alter_table1", "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 alter_table1 add key(c2) { "ObTableStmt": { "partition_fun_expr": [ ], "range_values_exprs": [ ], "list_values_exprs": [ ], "index_partition_resolve_results": [ { "partition_fun_expr": [ ], "range_values_exprs": [ ], "list_values_exprs": [ ] } ], "part_type":8 }, "stmt_type":22, "alter_table_arg": { "is_alter_columns":false, "is_alter_indexs":true, "is_alter_options":false, "session_id":-1, "index_arg_list": [ ], "alter_table_schema": { "alter_type":"OB_INVALID_DDL_OP", "origin_table_name":"alter_table1", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"alter_table1", "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": [ { "index_arg": { "tenant_id":1, "session_id":-1, "index_name":"c2", "table_name":"alter_table1", "database_name":"altertable", "index_action_type":2 }, "index_type":3, "index_columns": [ { "column_name":"c2", "prefix_len":0, "order_type":0, "column_id":-1 } ], "fulltext_columns": [ ], "store_columns": [ ], "index_option": { "block_size":16384, "replica_num":0, "index_status":1, "use_bloom_filter":false, "compress_method":"", "comment":"", "tablegroup_name":"", "progressive_merge_num":0, "primary_zone":"", "parser_name":"TAOBAO_CHN", "index_attributes_set":0, "row_store_type":3, "store_format":0 }, "index_using_type":0, "data_table_id":-1, "index_table_id":-1, "if_not_exist":false, "index_schema": { "simple_table_schema": { "tenant_id":-1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"", "replica_num":0, "previous_locality_str":"", "min_partition_id":0, "session_id":0, "index_type":3, "table_type":5, "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":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":"", "row_store_type":1, "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": [ ] } } ] } *************** Case 12 *************** alter table alter_table1 add index(c2) { "ObTableStmt": { "partition_fun_expr": [ ], "range_values_exprs": [ ], "list_values_exprs": [ ], "index_partition_resolve_results": [ { "partition_fun_expr": [ ], "range_values_exprs": [ ], "list_values_exprs": [ ] } ], "part_type":8 }, "stmt_type":22, "alter_table_arg": { "is_alter_columns":false, "is_alter_indexs":true, "is_alter_options":false, "session_id":-1, "index_arg_list": [ ], "alter_table_schema": { "alter_type":"OB_INVALID_DDL_OP", "origin_table_name":"alter_table1", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"alter_table1", "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": [ { "index_arg": { "tenant_id":1, "session_id":-1, "index_name":"c2", "table_name":"alter_table1", "database_name":"altertable", "index_action_type":2 }, "index_type":3, "index_columns": [ { "column_name":"c2", "prefix_len":0, "order_type":0, "column_id":-1 } ], "fulltext_columns": [ ], "store_columns": [ ], "index_option": { "block_size":16384, "replica_num":0, "index_status":1, "use_bloom_filter":false, "compress_method":"", "comment":"", "tablegroup_name":"", "progressive_merge_num":0, "primary_zone":"", "parser_name":"TAOBAO_CHN", "index_attributes_set":0, "row_store_type":3, "store_format":0 }, "index_using_type":0, "data_table_id":-1, "index_table_id":-1, "if_not_exist":false, "index_schema": { "simple_table_schema": { "tenant_id":-1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"", "replica_num":0, "previous_locality_str":"", "min_partition_id":0, "session_id":0, "index_type":3, "table_type":5, "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":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":"", "row_store_type":1, "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": [ ] } } ] } *************** Case 13 *************** alter table alter_table1 add index idx2(c2 DESC) { "ObTableStmt": { "partition_fun_expr": [ ], "range_values_exprs": [ ], "list_values_exprs": [ ], "index_partition_resolve_results": [ { "partition_fun_expr": [ ], "range_values_exprs": [ ], "list_values_exprs": [ ] } ], "part_type":8 }, "stmt_type":22, "alter_table_arg": { "is_alter_columns":false, "is_alter_indexs":true, "is_alter_options":false, "session_id":-1, "index_arg_list": [ ], "alter_table_schema": { "alter_type":"OB_INVALID_DDL_OP", "origin_table_name":"alter_table1", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"alter_table1", "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": [ { "index_arg": { "tenant_id":1, "session_id":-1, "index_name":"idx2", "table_name":"alter_table1", "database_name":"altertable", "index_action_type":2 }, "index_type":3, "index_columns": [ { "column_name":"c2", "prefix_len":0, "order_type":-1, "column_id":-1 } ], "fulltext_columns": [ ], "store_columns": [ ], "index_option": { "block_size":16384, "replica_num":0, "index_status":1, "use_bloom_filter":false, "compress_method":"", "comment":"", "tablegroup_name":"", "progressive_merge_num":0, "primary_zone":"", "parser_name":"TAOBAO_CHN", "index_attributes_set":0, "row_store_type":3, "store_format":0 }, "index_using_type":0, "data_table_id":-1, "index_table_id":-1, "if_not_exist":false, "index_schema": { "simple_table_schema": { "tenant_id":-1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"", "replica_num":0, "previous_locality_str":"", "min_partition_id":0, "session_id":0, "index_type":3, "table_type":5, "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":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":"", "row_store_type":1, "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": [ ] } } ] } *************** Case 14 *************** alter table alter_table1 add index idx1(c1,c2) { "ObTableStmt": { "partition_fun_expr": [ ], "range_values_exprs": [ ], "list_values_exprs": [ ], "index_partition_resolve_results": [ { "partition_fun_expr": [ ], "range_values_exprs": [ ], "list_values_exprs": [ ] } ], "part_type":8 }, "stmt_type":22, "alter_table_arg": { "is_alter_columns":false, "is_alter_indexs":true, "is_alter_options":false, "session_id":-1, "index_arg_list": [ ], "alter_table_schema": { "alter_type":"OB_INVALID_DDL_OP", "origin_table_name":"alter_table1", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"alter_table1", "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": [ { "index_arg": { "tenant_id":1, "session_id":-1, "index_name":"idx1", "table_name":"alter_table1", "database_name":"altertable", "index_action_type":2 }, "index_type":3, "index_columns": [ { "column_name":"c1", "prefix_len":0, "order_type":0, "column_id":-1 }, { "column_name":"c2", "prefix_len":0, "order_type":0, "column_id":-1 } ], "fulltext_columns": [ ], "store_columns": [ ], "index_option": { "block_size":16384, "replica_num":0, "index_status":1, "use_bloom_filter":false, "compress_method":"", "comment":"", "tablegroup_name":"", "progressive_merge_num":0, "primary_zone":"", "parser_name":"TAOBAO_CHN", "index_attributes_set":0, "row_store_type":3, "store_format":0 }, "index_using_type":0, "data_table_id":-1, "index_table_id":-1, "if_not_exist":false, "index_schema": { "simple_table_schema": { "tenant_id":-1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"", "replica_num":0, "previous_locality_str":"", "min_partition_id":0, "session_id":0, "index_type":3, "table_type":5, "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":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":"", "row_store_type":1, "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": [ ] } } ] } *************** Case 15 *************** alter table alter_table1 add index idx1(c1,c2 DESC) { "ObTableStmt": { "partition_fun_expr": [ ], "range_values_exprs": [ ], "list_values_exprs": [ ], "index_partition_resolve_results": [ { "partition_fun_expr": [ ], "range_values_exprs": [ ], "list_values_exprs": [ ] } ], "part_type":8 }, "stmt_type":22, "alter_table_arg": { "is_alter_columns":false, "is_alter_indexs":true, "is_alter_options":false, "session_id":-1, "index_arg_list": [ ], "alter_table_schema": { "alter_type":"OB_INVALID_DDL_OP", "origin_table_name":"alter_table1", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"alter_table1", "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": [ { "index_arg": { "tenant_id":1, "session_id":-1, "index_name":"idx1", "table_name":"alter_table1", "database_name":"altertable", "index_action_type":2 }, "index_type":3, "index_columns": [ { "column_name":"c1", "prefix_len":0, "order_type":0, "column_id":-1 }, { "column_name":"c2", "prefix_len":0, "order_type":-1, "column_id":-1 } ], "fulltext_columns": [ ], "store_columns": [ ], "index_option": { "block_size":16384, "replica_num":0, "index_status":1, "use_bloom_filter":false, "compress_method":"", "comment":"", "tablegroup_name":"", "progressive_merge_num":0, "primary_zone":"", "parser_name":"TAOBAO_CHN", "index_attributes_set":0, "row_store_type":3, "store_format":0 }, "index_using_type":0, "data_table_id":-1, "index_table_id":-1, "if_not_exist":false, "index_schema": { "simple_table_schema": { "tenant_id":-1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"", "replica_num":0, "previous_locality_str":"", "min_partition_id":0, "session_id":0, "index_type":3, "table_type":5, "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":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":"", "row_store_type":1, "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": [ ] } } ] } *************** Case 16 *************** alter table alter_table1 add index idx1(c1 ASC, c2 DESC) { "ObTableStmt": { "partition_fun_expr": [ ], "range_values_exprs": [ ], "list_values_exprs": [ ], "index_partition_resolve_results": [ { "partition_fun_expr": [ ], "range_values_exprs": [ ], "list_values_exprs": [ ] } ], "part_type":8 }, "stmt_type":22, "alter_table_arg": { "is_alter_columns":false, "is_alter_indexs":true, "is_alter_options":false, "session_id":-1, "index_arg_list": [ ], "alter_table_schema": { "alter_type":"OB_INVALID_DDL_OP", "origin_table_name":"alter_table1", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"alter_table1", "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": [ { "index_arg": { "tenant_id":1, "session_id":-1, "index_name":"idx1", "table_name":"alter_table1", "database_name":"altertable", "index_action_type":2 }, "index_type":3, "index_columns": [ { "column_name":"c1", "prefix_len":0, "order_type":0, "column_id":-1 }, { "column_name":"c2", "prefix_len":0, "order_type":-1, "column_id":-1 } ], "fulltext_columns": [ ], "store_columns": [ ], "index_option": { "block_size":16384, "replica_num":0, "index_status":1, "use_bloom_filter":false, "compress_method":"", "comment":"", "tablegroup_name":"", "progressive_merge_num":0, "primary_zone":"", "parser_name":"TAOBAO_CHN", "index_attributes_set":0, "row_store_type":3, "store_format":0 }, "index_using_type":0, "data_table_id":-1, "index_table_id":-1, "if_not_exist":false, "index_schema": { "simple_table_schema": { "tenant_id":-1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"", "replica_num":0, "previous_locality_str":"", "min_partition_id":0, "session_id":0, "index_type":3, "table_type":5, "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":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":"", "row_store_type":1, "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": [ ] } } ] } *************** Case 17 *************** alter table alter_table1 add index idx1(c1), add index idx2(c2) *************** Case 18 *************** alter table alter_table1 add index idx1(c1) GLOBAL COMMENT 'string' BLOCK_SIZE 16384 STORING(c3, c4) { "ObTableStmt": { "partition_fun_expr": [ ], "range_values_exprs": [ ], "list_values_exprs": [ ], "index_partition_resolve_results": [ { "partition_fun_expr": [ ], "range_values_exprs": [ ], "list_values_exprs": [ ] } ], "part_type":8 }, "stmt_type":22, "alter_table_arg": { "is_alter_columns":false, "is_alter_indexs":true, "is_alter_options":false, "session_id":-1, "index_arg_list": [ ], "alter_table_schema": { "alter_type":"OB_INVALID_DDL_OP", "origin_table_name":"alter_table1", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"alter_table1", "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":2, "collation_type":45, "create_mem_version":0, "index_status":1, "partition_status":0, "code_version":1, "last_modified_frozen_version":0, "comment":"string", "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": [ { "index_arg": { "tenant_id":1, "session_id":-1, "index_name":"idx1", "table_name":"alter_table1", "database_name":"altertable", "index_action_type":2 }, "index_type":3, "index_columns": [ { "column_name":"c1", "prefix_len":0, "order_type":0, "column_id":-1 } ], "fulltext_columns": [ ], "store_columns": [ "c3", "c4" ], "index_option": { "block_size":16384, "replica_num":0, "index_status":1, "use_bloom_filter":false, "compress_method":"", "comment":"string", "tablegroup_name":"", "progressive_merge_num":0, "primary_zone":"", "parser_name":"TAOBAO_CHN", "index_attributes_set":0, "row_store_type":3, "store_format":0 }, "index_using_type":0, "data_table_id":-1, "index_table_id":-1, "if_not_exist":false, "index_schema": { "simple_table_schema": { "tenant_id":-1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"", "replica_num":0, "previous_locality_str":"", "min_partition_id":0, "session_id":0, "index_type":3, "table_type":5, "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":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":"", "row_store_type":1, "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": [ ] } } ] } *************** Case 19 *************** alter table alter_table1 add index idx1(c1) GLOBAL COMMENT 'string' BLOCK_SIZE = 16384 STORING(c3, c4) { "ObTableStmt": { "partition_fun_expr": [ ], "range_values_exprs": [ ], "list_values_exprs": [ ], "index_partition_resolve_results": [ { "partition_fun_expr": [ ], "range_values_exprs": [ ], "list_values_exprs": [ ] } ], "part_type":8 }, "stmt_type":22, "alter_table_arg": { "is_alter_columns":false, "is_alter_indexs":true, "is_alter_options":false, "session_id":-1, "index_arg_list": [ ], "alter_table_schema": { "alter_type":"OB_INVALID_DDL_OP", "origin_table_name":"alter_table1", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"alter_table1", "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":2, "collation_type":45, "create_mem_version":0, "index_status":1, "partition_status":0, "code_version":1, "last_modified_frozen_version":0, "comment":"string", "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": [ { "index_arg": { "tenant_id":1, "session_id":-1, "index_name":"idx1", "table_name":"alter_table1", "database_name":"altertable", "index_action_type":2 }, "index_type":3, "index_columns": [ { "column_name":"c1", "prefix_len":0, "order_type":0, "column_id":-1 } ], "fulltext_columns": [ ], "store_columns": [ "c3", "c4" ], "index_option": { "block_size":16384, "replica_num":0, "index_status":1, "use_bloom_filter":false, "compress_method":"", "comment":"string", "tablegroup_name":"", "progressive_merge_num":0, "primary_zone":"", "parser_name":"TAOBAO_CHN", "index_attributes_set":0, "row_store_type":3, "store_format":0 }, "index_using_type":0, "data_table_id":-1, "index_table_id":-1, "if_not_exist":false, "index_schema": { "simple_table_schema": { "tenant_id":-1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"", "replica_num":0, "previous_locality_str":"", "min_partition_id":0, "session_id":0, "index_type":3, "table_type":5, "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":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":"", "row_store_type":1, "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": [ ] } } ] } *************** Case 20 *************** alter table alter_table1 add unique index uidx1(c1) { "ObTableStmt": { "partition_fun_expr": [ ], "range_values_exprs": [ ], "list_values_exprs": [ ], "index_partition_resolve_results": [ { "partition_fun_expr": [ ], "range_values_exprs": [ ], "list_values_exprs": [ ] } ], "part_type":8 }, "stmt_type":22, "alter_table_arg": { "is_alter_columns":false, "is_alter_indexs":true, "is_alter_options":false, "session_id":-1, "index_arg_list": [ ], "alter_table_schema": { "alter_type":"OB_INVALID_DDL_OP", "origin_table_name":"alter_table1", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"alter_table1", "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": [ { "index_arg": { "tenant_id":1, "session_id":-1, "index_name":"uidx1", "table_name":"alter_table1", "database_name":"altertable", "index_action_type":2 }, "index_type":4, "index_columns": [ { "column_name":"c1", "prefix_len":0, "order_type":0, "column_id":-1 } ], "fulltext_columns": [ ], "store_columns": [ ], "index_option": { "block_size":16384, "replica_num":0, "index_status":1, "use_bloom_filter":false, "compress_method":"", "comment":"", "tablegroup_name":"", "progressive_merge_num":0, "primary_zone":"", "parser_name":"TAOBAO_CHN", "index_attributes_set":0, "row_store_type":3, "store_format":0 }, "index_using_type":0, "data_table_id":-1, "index_table_id":-1, "if_not_exist":false, "index_schema": { "simple_table_schema": { "tenant_id":-1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"", "replica_num":0, "previous_locality_str":"", "min_partition_id":0, "session_id":0, "index_type":4, "table_type":5, "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":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":"", "row_store_type":1, "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": [ ] } } ] } *************** Case 21 *************** alter table alter_table1 add unique uidx1(c1) { "ObTableStmt": { "partition_fun_expr": [ ], "range_values_exprs": [ ], "list_values_exprs": [ ], "index_partition_resolve_results": [ { "partition_fun_expr": [ ], "range_values_exprs": [ ], "list_values_exprs": [ ] } ], "part_type":8 }, "stmt_type":22, "alter_table_arg": { "is_alter_columns":false, "is_alter_indexs":true, "is_alter_options":false, "session_id":-1, "index_arg_list": [ ], "alter_table_schema": { "alter_type":"OB_INVALID_DDL_OP", "origin_table_name":"alter_table1", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"alter_table1", "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": [ { "index_arg": { "tenant_id":1, "session_id":-1, "index_name":"uidx1", "table_name":"alter_table1", "database_name":"altertable", "index_action_type":2 }, "index_type":4, "index_columns": [ { "column_name":"c1", "prefix_len":0, "order_type":0, "column_id":-1 } ], "fulltext_columns": [ ], "store_columns": [ ], "index_option": { "block_size":16384, "replica_num":0, "index_status":1, "use_bloom_filter":false, "compress_method":"", "comment":"", "tablegroup_name":"", "progressive_merge_num":0, "primary_zone":"", "parser_name":"TAOBAO_CHN", "index_attributes_set":0, "row_store_type":3, "store_format":0 }, "index_using_type":0, "data_table_id":-1, "index_table_id":-1, "if_not_exist":false, "index_schema": { "simple_table_schema": { "tenant_id":-1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"", "replica_num":0, "previous_locality_str":"", "min_partition_id":0, "session_id":0, "index_type":4, "table_type":5, "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":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":"", "row_store_type":1, "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": [ ] } } ] } *************** Case 22 *************** alter table alter_table1 alter column c3 set default 13 { "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":"alter_table1", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"alter_table1", "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 alter_table1 alter column c3 drop default { "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":"alter_table1", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"alter_table1", "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 alter_table1 change column c4 nc4 char(20) { "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":"alter_table1", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"alter_table1", "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 alter_table1 modify c3 tinyint default 33 { "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":"alter_table1", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"alter_table1", "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 alter_table1 drop column c3 { "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":"alter_table1", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"alter_table1", "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 alter_table1 rename index idx_c1 to idx_2 { "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":false, "is_alter_indexs":true, "is_alter_options":false, "session_id":-1, "index_arg_list": [ { "index_arg": { "tenant_id":1, "session_id":-1, "index_name":"", "table_name":"", "database_name":"", "index_action_type":6 }, "origin_index_name":"idx_c1", "new_index_name":"idx_2" } ], "alter_table_schema": { "alter_type":"OB_INVALID_DDL_OP", "origin_table_name":"alter_table1", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"alter_table1", "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 alter_table1 rename index idx_2 to idx_c1 { "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":false, "is_alter_indexs":true, "is_alter_options":false, "session_id":-1, "index_arg_list": [ { "index_arg": { "tenant_id":1, "session_id":-1, "index_name":"", "table_name":"", "database_name":"", "index_action_type":6 }, "origin_index_name":"idx_2", "new_index_name":"idx_c1" } ], "alter_table_schema": { "alter_type":"OB_INVALID_DDL_OP", "origin_table_name":"alter_table1", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"alter_table1", "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 alter_table1 rename to alter_t1 { "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":false, "is_alter_indexs":false, "is_alter_options":true, "session_id":-1, "index_arg_list": [ ], "alter_table_schema": { "alter_type":"OB_INVALID_DDL_OP", "origin_table_name":"alter_table1", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"alter_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 alter_table1 set comment = 'hahaha' { "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":false, "is_alter_indexs":false, "is_alter_options":true, "session_id":-1, "index_arg_list": [ ], "alter_table_schema": { "alter_type":"OB_INVALID_DDL_OP", "origin_table_name":"alter_table1", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"alter_table1", "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":"hahaha", "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 alter_table1 set compression = 'none' { "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":false, "is_alter_indexs":false, "is_alter_options":true, "session_id":-1, "index_arg_list": [ ], "alter_table_schema": { "alter_type":"OB_INVALID_DDL_OP", "origin_table_name":"alter_table1", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"alter_table1", "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":"none", "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 test SET EXPIRE_INFO (c1 > 9) { "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":false, "is_alter_indexs":false, "is_alter_options":true, "session_id":-1, "index_arg_list": [ ], "alter_table_schema": { "alter_type":"OB_INVALID_DDL_OP", "origin_table_name":"test", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"test", "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 alter_table1 replica_num = 3 { "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":false, "is_alter_indexs":false, "is_alter_options":true, "session_id":-1, "index_arg_list": [ ], "alter_table_schema": { "alter_type":"OB_INVALID_DDL_OP", "origin_table_name":"alter_table1", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"alter_table1", "replica_num":3, "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 alter_table1 set block_size = 16384 { "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":false, "is_alter_indexs":false, "is_alter_options":true, "session_id":-1, "index_arg_list": [ ], "alter_table_schema": { "alter_type":"OB_INVALID_DDL_OP", "origin_table_name":"alter_table1", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"alter_table1", "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 alter_table1 set use_bloom_filter = true { "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":false, "is_alter_indexs":false, "is_alter_options":true, "session_id":-1, "index_arg_list": [ ], "alter_table_schema": { "alter_type":"OB_INVALID_DDL_OP", "origin_table_name":"alter_table1", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"alter_table1", "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":true, "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 alter_table1 set progressive_merge_num = 1 { "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":false, "is_alter_indexs":false, "is_alter_options":true, "session_id":-1, "index_arg_list": [ ], "alter_table_schema": { "alter_type":"OB_INVALID_DDL_OP", "origin_table_name":"alter_table1", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"alter_table1", "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":1, "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 alter_table1 tablegroup = 'tp1' { "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":false, "is_alter_indexs":false, "is_alter_options":true, "session_id":-1, "index_arg_list": [ ], "alter_table_schema": { "alter_type":"OB_INVALID_DDL_OP", "origin_table_name":"alter_table1", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"alter_table1", "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":"tp1", "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 alter_table1 drop tablegroup { "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":false, "is_alter_indexs":false, "is_alter_options":true, "session_id":-1, "index_arg_list": [ ], "alter_table_schema": { "alter_type":"OB_INVALID_DDL_OP", "origin_table_name":"alter_table1", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"alter_table1", "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 alter_table1 primary_zone = 'z1' { "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":false, "is_alter_indexs":false, "is_alter_options":true, "session_id":-1, "index_arg_list": [ ], "alter_table_schema": { "alter_type":"OB_INVALID_DDL_OP", "origin_table_name":"alter_table1", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"alter_table1", "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":"z1", "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 alter_table1 auto_increment = 1 { "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":false, "is_alter_indexs":false, "is_alter_options":true, "session_id":-1, "index_arg_list": [ ], "alter_table_schema": { "alter_type":"OB_INVALID_DDL_OP", "origin_table_name":"alter_table1", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"alter_table1", "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 alter_table1 drop tablegroup { "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":false, "is_alter_indexs":false, "is_alter_options":true, "session_id":-1, "index_arg_list": [ ], "alter_table_schema": { "alter_type":"OB_INVALID_DDL_OP", "origin_table_name":"alter_table1", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"alter_table1", "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 test add unique (c3(0)); *************** Case 43 *************** alter table test add unique (xxx(0)); *************** Case 44 *************** alter table test rename to `` *************** Case 45 *************** alter table test rename to ` ` *************** Case 46 *************** alter table test add index using btree(c1) using hash; { "ObTableStmt": { "partition_fun_expr": [ ], "range_values_exprs": [ ], "list_values_exprs": [ ], "index_partition_resolve_results": [ { "partition_fun_expr": [ ], "range_values_exprs": [ ], "list_values_exprs": [ ] } ], "part_type":8 }, "stmt_type":22, "alter_table_arg": { "is_alter_columns":false, "is_alter_indexs":true, "is_alter_options":false, "session_id":-1, "index_arg_list": [ ], "alter_table_schema": { "alter_type":"OB_INVALID_DDL_OP", "origin_table_name":"test", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"test", "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":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":"", "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": [ { "index_arg": { "tenant_id":1, "session_id":-1, "index_name":"c1", "table_name":"test", "database_name":"altertable", "index_action_type":2 }, "index_type":3, "index_columns": [ { "column_name":"c1", "prefix_len":0, "order_type":0, "column_id":-1 } ], "fulltext_columns": [ ], "store_columns": [ ], "index_option": { "block_size":16384, "replica_num":0, "index_status":1, "use_bloom_filter":false, "compress_method":"", "comment":"", "tablegroup_name":"", "progressive_merge_num":0, "primary_zone":"", "parser_name":"TAOBAO_CHN", "index_attributes_set":0, "row_store_type":3, "store_format":0 }, "index_using_type":1, "data_table_id":-1, "index_table_id":-1, "if_not_exist":false, "index_schema": { "simple_table_schema": { "tenant_id":-1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"", "replica_num":0, "previous_locality_str":"", "min_partition_id":0, "session_id":0, "index_type":3, "table_type":5, "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":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":"", "row_store_type":1, "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": [ ] } } ] } *************** Case 47 *************** alter table test add unique index using btree(c1) using hash; { "ObTableStmt": { "partition_fun_expr": [ ], "range_values_exprs": [ ], "list_values_exprs": [ ], "index_partition_resolve_results": [ { "partition_fun_expr": [ ], "range_values_exprs": [ ], "list_values_exprs": [ ] } ], "part_type":8 }, "stmt_type":22, "alter_table_arg": { "is_alter_columns":false, "is_alter_indexs":true, "is_alter_options":false, "session_id":-1, "index_arg_list": [ ], "alter_table_schema": { "alter_type":"OB_INVALID_DDL_OP", "origin_table_name":"test", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"test", "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":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":"", "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": [ { "index_arg": { "tenant_id":1, "session_id":-1, "index_name":"c1", "table_name":"test", "database_name":"altertable", "index_action_type":2 }, "index_type":4, "index_columns": [ { "column_name":"c1", "prefix_len":0, "order_type":0, "column_id":-1 } ], "fulltext_columns": [ ], "store_columns": [ ], "index_option": { "block_size":16384, "replica_num":0, "index_status":1, "use_bloom_filter":false, "compress_method":"", "comment":"", "tablegroup_name":"", "progressive_merge_num":0, "primary_zone":"", "parser_name":"TAOBAO_CHN", "index_attributes_set":0, "row_store_type":3, "store_format":0 }, "index_using_type":1, "data_table_id":-1, "index_table_id":-1, "if_not_exist":false, "index_schema": { "simple_table_schema": { "tenant_id":-1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"", "replica_num":0, "previous_locality_str":"", "min_partition_id":0, "session_id":0, "index_type":4, "table_type":5, "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":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":"", "row_store_type":1, "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": [ ] } } ] } *************** Case 48 *************** alter table test add index using hash(c1), add index using btree(c2) *************** Case 49 *************** create table wang_01(c1 int, c2 varchar(30), c3 bigint, c4 timestamp, c5 decimal(7,3), c6 varbinary(1024), c7 char(32), c8 tinyint); {"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":false, "schema":{"simple_table_schema":{"tenant_id":1, "database_id":18446744073709551615, "tablegroup_id":1099511627777, "table_id":18446744073709551615, "table_name":"wang_01", "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":23, "max_used_constraint_id":0, "sess_active_time":0, "rowkey_column_num":3, "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":1, "type":{"type":"BIGINT UNSIGNED", "collation":"binary", "coercibility":"NUMERIC"}, "order":0, "fulltext_flag":false}, {"length":0, "column_id":4, "type":{"type":"BIGINT UNSIGNED", "collation":"binary", "coercibility":"NUMERIC"}, "order":0, "fulltext_flag":false}, {"length":0, "column_id":5, "type":{"type":"BIGINT UNSIGNED", "collation":"binary", "coercibility":"NUMERIC"}, "order":0, "fulltext_flag":false}], "capacity":3}, "partition_key_info":{"columns":null, "capacity":0}, "aux_vp_tid_array":[]}, "index_arg_list":[], "constraint_list":[], "db_name":"altertable", "last_replay_log_id":0, "foreign_key_arg_list":[], "vertical_partition_arg_list":[]}, "index_arg_list":[]} *************** Case 50 *************** alter table wang_01 add constraint unique key(c2); { "ObTableStmt": { "partition_fun_expr": [ ], "range_values_exprs": [ ], "list_values_exprs": [ ], "index_partition_resolve_results": [ { "partition_fun_expr": [ ], "range_values_exprs": [ ], "list_values_exprs": [ ] } ], "part_type":8 }, "stmt_type":22, "alter_table_arg": { "is_alter_columns":false, "is_alter_indexs":true, "is_alter_options":false, "session_id":-1, "index_arg_list": [ ], "alter_table_schema": { "alter_type":"OB_INVALID_DDL_OP", "origin_table_name":"wang_01", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"wang_01", "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": [ { "index_arg": { "tenant_id":1, "session_id":-1, "index_name":"c2", "table_name":"wang_01", "database_name":"altertable", "index_action_type":2 }, "index_type":4, "index_columns": [ { "column_name":"c2", "prefix_len":0, "order_type":0, "column_id":-1 } ], "fulltext_columns": [ ], "store_columns": [ ], "index_option": { "block_size":16384, "replica_num":0, "index_status":1, "use_bloom_filter":false, "compress_method":"", "comment":"", "tablegroup_name":"", "progressive_merge_num":0, "primary_zone":"", "parser_name":"TAOBAO_CHN", "index_attributes_set":0, "row_store_type":3, "store_format":0 }, "index_using_type":0, "data_table_id":-1, "index_table_id":-1, "if_not_exist":false, "index_schema": { "simple_table_schema": { "tenant_id":-1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"", "replica_num":0, "previous_locality_str":"", "min_partition_id":0, "session_id":0, "index_type":4, "table_type":5, "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":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":"", "row_store_type":1, "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": [ ] } } ] } *************** Case 51 *************** alter table wang_01 add constraint const_name unique key(c3); { "ObTableStmt": { "partition_fun_expr": [ ], "range_values_exprs": [ ], "list_values_exprs": [ ], "index_partition_resolve_results": [ { "partition_fun_expr": [ ], "range_values_exprs": [ ], "list_values_exprs": [ ] } ], "part_type":8 }, "stmt_type":22, "alter_table_arg": { "is_alter_columns":false, "is_alter_indexs":true, "is_alter_options":false, "session_id":-1, "index_arg_list": [ ], "alter_table_schema": { "alter_type":"OB_INVALID_DDL_OP", "origin_table_name":"wang_01", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"wang_01", "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": [ { "index_arg": { "tenant_id":1, "session_id":-1, "index_name":"const_name", "table_name":"wang_01", "database_name":"altertable", "index_action_type":2 }, "index_type":4, "index_columns": [ { "column_name":"c3", "prefix_len":0, "order_type":0, "column_id":-1 } ], "fulltext_columns": [ ], "store_columns": [ ], "index_option": { "block_size":16384, "replica_num":0, "index_status":1, "use_bloom_filter":false, "compress_method":"", "comment":"", "tablegroup_name":"", "progressive_merge_num":0, "primary_zone":"", "parser_name":"TAOBAO_CHN", "index_attributes_set":0, "row_store_type":3, "store_format":0 }, "index_using_type":0, "data_table_id":-1, "index_table_id":-1, "if_not_exist":false, "index_schema": { "simple_table_schema": { "tenant_id":-1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"", "replica_num":0, "previous_locality_str":"", "min_partition_id":0, "session_id":0, "index_type":4, "table_type":5, "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":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":"", "row_store_type":1, "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": [ ] } } ] } *************** Case 52 *************** alter table wang_01 add constraint const_name unique key uk_name_1(c4); { "ObTableStmt": { "partition_fun_expr": [ ], "range_values_exprs": [ ], "list_values_exprs": [ ], "index_partition_resolve_results": [ { "partition_fun_expr": [ ], "range_values_exprs": [ ], "list_values_exprs": [ ] } ], "part_type":8 }, "stmt_type":22, "alter_table_arg": { "is_alter_columns":false, "is_alter_indexs":true, "is_alter_options":false, "session_id":-1, "index_arg_list": [ ], "alter_table_schema": { "alter_type":"OB_INVALID_DDL_OP", "origin_table_name":"wang_01", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"wang_01", "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": [ { "index_arg": { "tenant_id":1, "session_id":-1, "index_name":"uk_name_1", "table_name":"wang_01", "database_name":"altertable", "index_action_type":2 }, "index_type":4, "index_columns": [ { "column_name":"c4", "prefix_len":0, "order_type":0, "column_id":-1 } ], "fulltext_columns": [ ], "store_columns": [ ], "index_option": { "block_size":16384, "replica_num":0, "index_status":1, "use_bloom_filter":false, "compress_method":"", "comment":"", "tablegroup_name":"", "progressive_merge_num":0, "primary_zone":"", "parser_name":"TAOBAO_CHN", "index_attributes_set":0, "row_store_type":3, "store_format":0 }, "index_using_type":0, "data_table_id":-1, "index_table_id":-1, "if_not_exist":false, "index_schema": { "simple_table_schema": { "tenant_id":-1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"", "replica_num":0, "previous_locality_str":"", "min_partition_id":0, "session_id":0, "index_type":4, "table_type":5, "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":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":"", "row_store_type":1, "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": [ ] } } ] } *************** Case 53 *************** alter table wang_01 add constraint cons_name_1 unique key(c5); { "ObTableStmt": { "partition_fun_expr": [ ], "range_values_exprs": [ ], "list_values_exprs": [ ], "index_partition_resolve_results": [ { "partition_fun_expr": [ ], "range_values_exprs": [ ], "list_values_exprs": [ ] } ], "part_type":8 }, "stmt_type":22, "alter_table_arg": { "is_alter_columns":false, "is_alter_indexs":true, "is_alter_options":false, "session_id":-1, "index_arg_list": [ ], "alter_table_schema": { "alter_type":"OB_INVALID_DDL_OP", "origin_table_name":"wang_01", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"wang_01", "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": [ { "index_arg": { "tenant_id":1, "session_id":-1, "index_name":"cons_name_1", "table_name":"wang_01", "database_name":"altertable", "index_action_type":2 }, "index_type":4, "index_columns": [ { "column_name":"c5", "prefix_len":0, "order_type":0, "column_id":-1 } ], "fulltext_columns": [ ], "store_columns": [ ], "index_option": { "block_size":16384, "replica_num":0, "index_status":1, "use_bloom_filter":false, "compress_method":"", "comment":"", "tablegroup_name":"", "progressive_merge_num":0, "primary_zone":"", "parser_name":"TAOBAO_CHN", "index_attributes_set":0, "row_store_type":3, "store_format":0 }, "index_using_type":0, "data_table_id":-1, "index_table_id":-1, "if_not_exist":false, "index_schema": { "simple_table_schema": { "tenant_id":-1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"", "replica_num":0, "previous_locality_str":"", "min_partition_id":0, "session_id":0, "index_type":4, "table_type":5, "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":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":"", "row_store_type":1, "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": [ ] } } ] } *************** Case 54 *************** alter table wang_01 add constraint unique key uk_name_2(c6); { "ObTableStmt": { "partition_fun_expr": [ ], "range_values_exprs": [ ], "list_values_exprs": [ ], "index_partition_resolve_results": [ { "partition_fun_expr": [ ], "range_values_exprs": [ ], "list_values_exprs": [ ] } ], "part_type":8 }, "stmt_type":22, "alter_table_arg": { "is_alter_columns":false, "is_alter_indexs":true, "is_alter_options":false, "session_id":-1, "index_arg_list": [ ], "alter_table_schema": { "alter_type":"OB_INVALID_DDL_OP", "origin_table_name":"wang_01", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"wang_01", "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": [ { "index_arg": { "tenant_id":1, "session_id":-1, "index_name":"uk_name_2", "table_name":"wang_01", "database_name":"altertable", "index_action_type":2 }, "index_type":4, "index_columns": [ { "column_name":"c6", "prefix_len":0, "order_type":0, "column_id":-1 } ], "fulltext_columns": [ ], "store_columns": [ ], "index_option": { "block_size":16384, "replica_num":0, "index_status":1, "use_bloom_filter":false, "compress_method":"", "comment":"", "tablegroup_name":"", "progressive_merge_num":0, "primary_zone":"", "parser_name":"TAOBAO_CHN", "index_attributes_set":0, "row_store_type":3, "store_format":0 }, "index_using_type":0, "data_table_id":-1, "index_table_id":-1, "if_not_exist":false, "index_schema": { "simple_table_schema": { "tenant_id":-1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"", "replica_num":0, "previous_locality_str":"", "min_partition_id":0, "session_id":0, "index_type":4, "table_type":5, "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":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":"", "row_store_type":1, "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": [ ] } } ] } *************** Case 55 *************** alter table wang_01 add constraint cons_name unique key uk_name_3(c7); { "ObTableStmt": { "partition_fun_expr": [ ], "range_values_exprs": [ ], "list_values_exprs": [ ], "index_partition_resolve_results": [ { "partition_fun_expr": [ ], "range_values_exprs": [ ], "list_values_exprs": [ ] } ], "part_type":8 }, "stmt_type":22, "alter_table_arg": { "is_alter_columns":false, "is_alter_indexs":true, "is_alter_options":false, "session_id":-1, "index_arg_list": [ ], "alter_table_schema": { "alter_type":"OB_INVALID_DDL_OP", "origin_table_name":"wang_01", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"wang_01", "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": [ { "index_arg": { "tenant_id":1, "session_id":-1, "index_name":"uk_name_3", "table_name":"wang_01", "database_name":"altertable", "index_action_type":2 }, "index_type":4, "index_columns": [ { "column_name":"c7", "prefix_len":0, "order_type":0, "column_id":-1 } ], "fulltext_columns": [ ], "store_columns": [ ], "index_option": { "block_size":16384, "replica_num":0, "index_status":1, "use_bloom_filter":false, "compress_method":"", "comment":"", "tablegroup_name":"", "progressive_merge_num":0, "primary_zone":"", "parser_name":"TAOBAO_CHN", "index_attributes_set":0, "row_store_type":3, "store_format":0 }, "index_using_type":0, "data_table_id":-1, "index_table_id":-1, "if_not_exist":false, "index_schema": { "simple_table_schema": { "tenant_id":-1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"", "replica_num":0, "previous_locality_str":"", "min_partition_id":0, "session_id":0, "index_type":4, "table_type":5, "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":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":"", "row_store_type":1, "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": [ ] } } ] } *************** Case 56 *************** alter table wang_01 add constraint unique key uk_name_4(c8); { "ObTableStmt": { "partition_fun_expr": [ ], "range_values_exprs": [ ], "list_values_exprs": [ ], "index_partition_resolve_results": [ { "partition_fun_expr": [ ], "range_values_exprs": [ ], "list_values_exprs": [ ] } ], "part_type":8 }, "stmt_type":22, "alter_table_arg": { "is_alter_columns":false, "is_alter_indexs":true, "is_alter_options":false, "session_id":-1, "index_arg_list": [ ], "alter_table_schema": { "alter_type":"OB_INVALID_DDL_OP", "origin_table_name":"wang_01", "new_database_name":"altertable", "origin_database_name":"altertable", "split_partition_name":"", "alter_table_schema": { "simple_table_schema": { "tenant_id":1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"wang_01", "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": [ { "index_arg": { "tenant_id":1, "session_id":-1, "index_name":"uk_name_4", "table_name":"wang_01", "database_name":"altertable", "index_action_type":2 }, "index_type":4, "index_columns": [ { "column_name":"c8", "prefix_len":0, "order_type":0, "column_id":-1 } ], "fulltext_columns": [ ], "store_columns": [ ], "index_option": { "block_size":16384, "replica_num":0, "index_status":1, "use_bloom_filter":false, "compress_method":"", "comment":"", "tablegroup_name":"", "progressive_merge_num":0, "primary_zone":"", "parser_name":"TAOBAO_CHN", "index_attributes_set":0, "row_store_type":3, "store_format":0 }, "index_using_type":0, "data_table_id":-1, "index_table_id":-1, "if_not_exist":false, "index_schema": { "simple_table_schema": { "tenant_id":-1, "database_id":-1, "tablegroup_id":-1, "table_id":-1, "table_name":"", "replica_num":0, "previous_locality_str":"", "min_partition_id":0, "session_id":0, "index_type":4, "table_type":5, "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":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":"", "row_store_type":1, "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": [ ] } } ] } *************** Case 57 *************** drop database altertable; { "drop_database_arg":"tenant_id", "database_name":"altertable", "if_exist":false, "to_recyclebin":false }