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