OceanBase 数据库 V4.2.1 版本中 insert 语句出现非预期报错 ORA-12899: value too large for column xxxx (actual: 2, maximum: 1) 的原因和解决方法

-- SQL 语句。
insert into x select * from（select 0, 0 from dual）v 
insert into x select * from（select 0, 1 from dual）v 
-- SQL 语句执行报错。
ORA-12899: value too large for column "xxxx"."zzzz"."dddd" (actual: 2, maximum: 1)

[2024-10-19 18:56:53.361114] WDIAG [SQL] string_length_check (ob_datum_cast.cpp:9552) [698620][T1050_L0_G0][T1050][xxxxx-xxxxx-xxxxx-xxxxx] [lt=29][errcode=0] char type length is too long(str_len_byte=2, max_len_byte=1)
[2024-10-19 18:56:53.361137] WDIAG [SQL] string_length_check (ob_datum_cast.cpp:9599) [698620][T1050_L0_G0][T1050][xxxxx-xxxxx-xxxxx-xxxxx] [lt=21][errcode=0] string accuracy check failed(cast_ret=-5167, ret=0, warning=-5167, is_oracle=true, meta={type:"CHAR", collation:"utf8mb4_bin", coercibility:"INVALID"})
[2024-10-19 18:56:53.361161] WDIAG [SQL.ENG] column_convert_datum_accuracy_check (ob_expr_column_conv.cpp:346) [698620][T1050_L0_G0][T1050][xxxxx-xxxxx-xxxxx-xxxxx] [lt=20][errcode=-5167] fail to check accuracy(ret=-5167, expr={type:"T_FUN_COLUMN_CONV", datum_meta:{type:"CHAR", cs_type:"utf8mb4_bin", scale:-1, precision:2}, obj_meta:{type:"CHAR", collation:"utf8mb4_bin", coercibility:"IMPLICIT"}, obj_datum_map:1, flag:3, eval_func:0x55f1951de610, eval_batch_func:0x55f19d7c21f0, inner_functions:null, inner_func_cnt:0, arg_cnt:6, parent_cnt:0, frame_idx:2, datum_off:9400, res_buf_off:47684, dyn_buf_header_offset:26132, res_buf_len:1, eval_flags_off:18628, pvt_skip_off:9592, expr_ctx_id:4294967295, extra:0, batch_idx_mask:18446744073709551615, this:0x7f993de6e610}, warning=-5167)