首批通过分布式安全可靠测评，为关键业务系统打造
划线反馈
SQL 执行报 ErrorCode = 4016, SQLState = HY000, Details = Internal error
更新时间：2024-01-22 01:56
分享
适用版本：V2.1.x、V2.2.x、V3.1.x、V3.2.x内容类型：Troubleshoot
问题现象
创建一个空表，执行 SQL 报错 ErrorCode = 4016, SQLState = HY000, Details = Internal error。
建表语句如下。
CREATE TABLE `ccam_para_doc_log` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`RECORD_ID` varchar(30) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '日志流水编号',
`FILE_ID` varchar(8) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '文件类别ID',
`FILE_LEVEL` varchar(2) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '文件归属层级',
`PARENT_FILE_ID` varchar(8) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '归属父级ID',
`FILE_TYPE` varchar(2) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '文件类型, 1-信用卡申请补件, 2-调整额度补件',
`NEW_FILE_NAME_US` varchar(300) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '文件类别名称',
`NEW_FILE_NAME_CN` varchar(300) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '文件类别名称',
`NEW_FILE_NAME_HK` varchar(300) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '文件类别名称',
`OLD_FILE_NAME_US` varchar(300) CHARACTER SET utf8mb4 DEFAULT NULL,
`OLD_FILE_NAME_CN` varchar(300) CHARACTER SET utf8mb4 DEFAULT NULL,
`OLD_FILE_NAME_HK` varchar(300) CHARACTER SET utf8mb4 DEFAULT NULL,
`DOC_TYPE_EN` varchar(300) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '文件類型',
`DOC_TYPE_CN` varchar(300) CHARACTER SET utf8mb4 DEFAULT NULL,
`DOC_TYPE_HK` varchar(300) CHARACTER SET utf8mb4 DEFAULT NULL,
`OPERATION_TYPE` varchar(6) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '操作类型, ADD-新增, UPD-修改',
`CREATE_TIME` varchar(19) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建日期',
`CREATOR_ID` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建人ID',
`CREATOR_NAME` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建人名称',
`CREATOR_DEPT` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建人归属部门',
`CREATOR_EMAIL` varchar(500) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '创建人電郵',
`APPROVE_TIME` varchar(19) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '审批时间',
`APPROVER_ID` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '审批人ID',
`APPROVER_NAME` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '审批人名称',
`APPROVER_DEPT` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '审批人归属部门',
`APPROVER_EMAIL` varchar(500) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '审批人電郵',
`STATE` varchar(2) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '当前状态, 0-待审批, 1-审批通过, 2-审批不通过',
`FLAG` varchar(1) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '是否启用, Y-启用, N-禁用',
`REASON` varchar(300) CHARACTER SET utf8mb4 DEFAULT NULL,
PRIMARY KEY (`ID`)
);
报错 SQL 如下。
select date_format(Now(), '%Y%m%d%H%i%s'), '123', creator_email, '', '',
concat('[Credit Card Application Management System] ', 'Parameter of ',
case when parent_file_id is not null and parent_file_id != '' then 'Document' else 'Document Type' end,
' (', new_file_name_us, ') was approved by ', approver_name),
case when parent_file_id is not null and parent_file_id != '' then concat('Dear ', creator_name, ',', CHAR(13), CHAR(13),
'The following Parameter of Document was approved by ', approver_name, ' at ',
approve_time, ', you can access the details via the link, thank you. ',
CHAR(13), CHAR(13), 'Supplementary Document Type: ', get_dict_value('en_US', 'SMS_TYPE', file_type), CHAR(13),
'Document Type: ', doc_type_en, CHAR(13), 'Document (Eng.): ', new_file_name_us, CHAR(13),
'Document (Simp. Chinese): ', new_file_name_cn, CHAR(13), 'Document (Trad. Chinese): ', new_file_name_hk, CHAR(13),
'Status: ', case when flag = 'Y' then 'Active' when flag = 'N' then 'Frozen' end, CHAR(13),
'Action: ', case when operation_type = 'ADD' then 'New' when operation_type = 'UPD' then 'Update' end, CHAR(13),
'Reason: ', '1232', CHAR(13), CHAR(13), '343', CHAR(13), CHAR(13), 'Best Regards,', CHAR(13), CHAR(13),
'Credit Card Application Management System', CHAR(13), CHAR(13),
'*** This is an automatically generated email, please do not reply *** ')
else concat('Dear ', creator_name, ',', CHAR(13), CHAR(13),
'The following Parameter of Document Type was approved by ', approver_name, ' at ', approve_time,
', you can access the details via the link, thank you. ', CHAR(13), CHAR(13),
'Document Type (Eng.): ', new_file_name_us, CHAR(13), 'Document Type (Simp. Chinese): ',
new_file_name_cn, CHAR(13), 'Document Type (Trad. Chinese): ', new_file_name_hk, CHAR(13),
'Status: ', case when flag = 'Y' then 'Active' when flag = 'N' then 'Frozen' end, CHAR(13),
'Action: ', case when operation_type = 'ADD' then 'New' when operation_type = 'UPD' then 'Update' end, CHAR(13),
'Reason: ', '565', CHAR(13), CHAR(13), '676', CHAR(13), CHAR(13), 'Best Regards,', CHAR(13), CHAR(13),
'Credit Card Application Management System', CHAR(13), CHAR(13), '*** This is an automatically generated email, please do not reply *** ')
end,
'2', concat(date_format(Now(), '%Y%m%d%H%i%s'), record_id), '11', '', '0'
from ccam_para_doc_log where record_id = '20220922175335000817836';
报错日志如下。
[2022-09-23 14:52:31.508001] ERROR [SQL.ENG] aggregate_max_length_for_string_result (ob_expr_operator.cpp:1186) [20290][2304][YB427B230D33-0005E544A0DFD904] [lt=9] [dc=0] unexpected max length.(ret=-4016, max_length=-1, param_num=2, len_in_byte=false) BACKTRACE:0xd6bc498 0xd6a43d9 0x34fef81 0x9c53822 0x9c53f77 0xae4fff6 0xae7d723 0xae85515 0xae8572e 0xb01a952 0xc8fe0f5 0xc8ffd62 0x3410a6b 0x3410d95 0x3410bf4 0xc7dd416 0xc858fed 0xc85a581 0xca1f6c3 0x340c4b6 0x3405549 0x340367f 0x3338d8f 0x32d58af 0x32d4fef 0x328ebac 0x32886e9 0x32860c1 0x3280dd4 0xa882fea 0x3c1a7e7 0xd451786 0xd44edaf 0xd44cb6e
[2022-09-23 14:52:31.508156] WARN [SQL.ENG] aggregate_result_type_for_case (ob_expr_operator.cpp:1014) [20290][2304][YB427B230D33-0005E544A0DFD904] [lt=154] [dc=0] fail to aggregate result type(ret=-4016)
[2022-09-23 14:52:31.508160] WARN [SQL.ENG] calc_result_typeN (ob_expr_case.cpp:73) [20290][2304][YB427B230D33-0005E544A0DFD904] [lt=4] [dc=0] failed to aggregate result type
[2022-09-23 14:52:31.508165] WARN [SQL.RESV] postorder_accept (ob_raw_expr.cpp:441) [20290][2304][YB427B230D33-0005E544A0DFD904] [lt=3] [dc=0] visit failed(ret=-4016, type=139, name="T_OP_CASE")
[2022-09-23 14:52:31.508172] WARN [SQL.RESV] deduce_type (ob_raw_expr.cpp:337) [20290][2304][YB427B230D33-0005E544A0DFD904] [lt=6] [dc=0] fail to deduce(ret=-4016)
[2022-09-23 14:52:31.508175] WARN [SQL.RESV] formalize (ob_raw_expr.cpp:349) [20290][2304][YB427B230D33-0005E544A0DFD904] [lt=2] [dc=0] failed to deduce type(*this={item_type:"T_OP_CASE", result_type:{meta:{type:"", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["CNT_CONST_EXPR", "CNT_CONST", "CNT_COLUMN", "CNT_PARAM", "CNT_FUNC", "CNT_CALCULABLE_EXPR", "CNT_STATE_FUNC"], rel_id:[], expr_levels:[], arg_case:null, default:{item_type:"T_OP_CNN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_bin", coercibility:"IMPLICIT"}, accuracy:{length:-2013264530, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_FUNC", "CNT_CONST_EXPR", "CNT_CONST", "CNT_COLUMN", "CNT_PARAM", "CNT_FUNC", "CNT_CALCULABLE_EXPR"], rel_id:[], expr_levels:[], func:"concat", children:[{item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:5, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":58}}, {item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_bin", coercibility:"IMPLICIT"}, accuracy:{length:50, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:1112705767363193, column_id:34, database_name:"ccam", table_name:"ccam_para_doc_log", synonym_name:"", synonym_db_name:"", column_name:"CREATOR_NAME", expr_level:0, expr_levels:[0], column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}, {item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:1, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":59}}, {item_type:"T_FUN_SYS_CHAR", result_type:{meta:{type:"VARCHAR", collation:"binary", coercibility:"COERCIBLE"}, accuracy:{length:134217728, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_FUNC", "IS_CALCULABLE_EXPR", "IS_CONST_EXPR", "CNT_CONST", "CNT_PARAM", "CNT_FUNC", "CNT_CALCULABLE_EXPR"], rel_id:[], expr_levels:[], func:"char", children:[{item_type:"T_QUESTIONMARK", result_type:{meta:{type:"BIGINT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:2, precision:2, scale:0}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":60}}, {item_type:"T_VARCHAR", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "CNT_CONST"], rel_id:[], value:{"VARCHAR":"binary", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}}], enum_set_values:[]}, {item_type:"T_FUN_SYS_CHAR", result_type:{meta:{type:"VARCHAR", collation:"binary", coercibility:"COERCIBLE"}, accuracy:{length:134217728, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_FUNC", "IS_CALCULABLE_EXPR", "IS_CONST_EXPR", "CNT_CONST", "CNT_PARAM", "CNT_FUNC", "CNT_CALCULABLE_EXPR"], rel_id:[], expr_levels:[], func:"char", children:[{item_type:"T_QUESTIONMARK", result_type:{meta:{type:"BIGINT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:2, precision:2, scale:0}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":61}}, {item_type:"T_VARCHAR", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "CNT_CONST"], rel_id:[], value:{"VARCHAR":"binary", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}}], enum_set_values:[]}, {item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:57, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":62}}, {item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_bin", coercibility:"IMPLICIT"}, accuracy:{length:50, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:1112705767363193, column_id:39, database_name:"ccam", table_name:"ccam_para_doc_log", synonym_name:"", synonym_db_name:"", column_name:"APPROVER_NAME", expr_level:0, expr_levels:[0], column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}, {item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:4, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":63}}, {item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_bin", coercibility:"IMPLICIT"}, accuracy:{length:19, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:1112705767363193, column_id:37, database_name:"ccam", table_name:"ccam_para_doc_log", synonym_name:"", synonym_db_name:"", column_name:"APPROVE_TIME", expr_level:0, expr_levels:[0], column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}, {item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:54, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":64}}, {item_type:"T_FUN_SYS_CHAR", result_type:{meta:{type:"VARCHAR", collation:"binary", coercibility:"COERCIBLE"}, accuracy:{length:134217728, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_FUNC", "IS_CALCULABLE_EXPR", "IS_CONST_EXPR", "CNT_CONST", "CNT_PARAM", "CNT_FUNC", "CNT_CALCULABLE_EXPR"], rel_id:[], expr_levels:[], func:"char", children:[{item_type:"T_QUESTIONMARK", result_type:{meta:{type:"BIGINT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:2, precision:2, scale:0}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":65}}, {item_type:"T_VARCHAR", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "CNT_CONST"], rel_id:[], value:{"VARCHAR":"binary", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}}], enum_set_values:[]}, {item_type:"T_FUN_SYS_CHAR", result_type:{meta:{type:"VARCHAR", collation:"binary", coercibility:"COERCIBLE"}, accuracy:{length:134217728, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_FUNC", "IS_CALCULABLE_EXPR", "IS_CONST_EXPR", "CNT_CONST", "CNT_PARAM", "CNT_FUNC", "CNT_CALCULABLE_EXPR"], rel_id:[], expr_levels:[], func:"char", children:[{item_type:"T_QUESTIONMARK", result_type:{meta:{type:"BIGINT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:2, precision:2, scale:0}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":66}}, {item_type:"T_VARCHAR", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "CNT_CONST"], rel_id:[], value:{"VARCHAR":"binary", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}}], enum_set_values:[]}, {item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:22, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":67}}, {item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:300, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:1112705767363193, column_id:22, database_name:"ccam", table_name:"ccam_para_doc_log", synonym_name:"", synonym_db_name:"", column_name:"NEW_FILE_NAME_US", expr_level:0, expr_levels:[0], column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}, {item_type:"T_FUN_SYS_CHAR", result_type:{meta:{type:"VARCHAR", collation:"binary", coercibility:"COERCIBLE"}, accuracy:{length:134217728, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_FUNC", "IS_CALCULABLE_EXPR", "IS_CONST_EXPR", "CNT_CONST", "CNT_PARAM", "CNT_FUNC", "CNT_CALCULABLE_EXPR"], rel_id:[], expr_levels:[], func:"char", children:[{item_type:"T_QUESTIONMARK", result_type:{meta:{type:"BIGINT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:2, precision:2, scale:0}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":68}}, {item_type:"T_VARCHAR", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "CNT_CONST"], rel_id:[], value:{"VARCHAR":"binary", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}}], enum_set_values:[]}, {item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:31, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":69}}, {item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:300, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:1112705767363193, column_id:23, database_name:"ccam", table_name:"ccam_para_doc_log", synonym_name:"", synonym_db_name:"", column_name:"NEW_FILE_NAME_CN", expr_level:0, expr_levels:[0], column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}, {item_type:"T_FUN_SYS_CHAR", result_type:{meta:{type:"VARCHAR", collation:"binary", coercibility:"COERCIBLE"}, accuracy:{length:134217728, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_FUNC", "IS_CALCULABLE_EXPR", "IS_CONST_EXPR", "CNT_CONST", "CNT_PARAM", "CNT_FUNC", "CNT_CALCULABLE_EXPR"], rel_id:[], expr_levels:[], func:"char", children:[{item_type:"T_QUESTIONMARK", result_type:{meta:{type:"BIGINT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:2, precision:2, scale:0}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":70}}, {item_type:"T_VARCHAR", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "CNT_CONST"], rel_id:[], value:{"VARCHAR":"binary", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}}], enum_set_values:[]}, {item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:31, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":71}}, {item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:300, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:1112705767363193, column_id:24, database_name:"ccam", table_name:"ccam_para_doc_log", synonym_name:"", synonym_db_name:"", column_name:"NEW_FILE_NAME_HK", expr_level:0, expr_levels:[0], column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}, {item_type:"T_FUN_SYS_CHAR", result_type:{meta:{type:"VARCHAR", collation:"binary", coercibility:"COERCIBLE"}, accuracy:{length:134217728, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_FUNC", "IS_CALCULABLE_EXPR", "IS_CONST_EXPR", "CNT_CONST", "CNT_PARAM", "CNT_FUNC", "CNT_CALCULABLE_EXPR"], rel_id:[], expr_levels:[], func:"char", children:[{item_type:"T_QUESTIONMARK", result_type:{meta:{type:"BIGINT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:2, precision:2, scale:0}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":72}}, {item_type:"T_VARCHAR", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "CNT_CONST"], rel_id:[], value:{"VARCHAR":"binary", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}}], enum_set_values:[]}, {item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:8, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":73}}, {item_type:"T_OP_CASE", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:6, precision:-1, scale:-1}, flag:0, calc_type:{type:"TINYINT", collation:"binary", coercibility:"NUMERIC"}}, expr_info:["CNT_CONST", "CNT_COLUMN", "CNT_PARAM"], rel_id:[], expr_levels:[], arg_case:null, default:{item_type:"T_NULL", result_type:{meta:{type:"NULL", collation:"binary", coercibility:"IGNORABLE"}, accuracy:{length:0, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "CNT_CONST"], rel_id:[], value:{"NULL":"NULL"}}, when:[{item_type:"T_OP_EQ", result_type:{meta:{type:"INT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:1, scale:0}, flag:0, calc_type:{type:"VARCHAR", collation:"utf8mb4_bin", coercibility:"IMPLICIT"}}, expr_info:["CNT_CONST", "CNT_COLUMN", "CNT_PARAM", "IS_SIMPLE_COND"], rel_id:[], expr_levels:[], children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_bin", coercibility:"IMPLICIT"}, accuracy:{length:1, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:1112705767363193, column_id:43, database_name:"ccam", table_name:"ccam_para_doc_log", synonym_name:"", synonym_db_name:"", column_name:"FLAG", expr_level:0, expr_levels:[0], column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}, {item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:1, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":74}}]}, {item_type:"T_OP_EQ", result_type:{meta:{type:"INT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:1, scale:0}, flag:0, calc_type:{type:"VARCHAR", collation:"utf8mb4_bin", coercibility:"IMPLICIT"}}, expr_info:["CNT_CONST", "CNT_COLUMN", "CNT_PARAM", "IS_SIMPLE_COND"], rel_id:[], expr_levels:[], children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_bin", coercibility:"IMPLICIT"}, accuracy:{length:1, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:1112705767363193, column_id:43, database_name:"ccam", table_name:"ccam_para_doc_log", synonym_name:"", synonym_db_name:"", column_name:"FLAG", expr_level:0, expr_levels:[0], column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}, {item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:1, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":76}}]}], then:[{item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:6, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":75}}, {item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:6, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":77}}], decode:false}, {item_type:"T_FUN_SYS_CHAR", result_type:{meta:{type:"VARCHAR", collation:"binary", coercibility:"COERCIBLE"}, accuracy:{length:134217728, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_FUNC", "IS_CALCULABLE_EXPR", "IS_CONST_EXPR", "CNT_CONST", "CNT_PARAM", "CNT_FUNC", "CNT_CALCULABLE_EXPR"], rel_id:[], expr_levels:[], func:"char", children:[{item_type:"T_QUESTIONMARK", result_type:{meta:{type:"BIGINT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:2, precision:2, scale:0}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":78}}, {item_type:"T_VARCHAR", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "CNT_CONST"], rel_id:[], value:{"VARCHAR":"binary", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}}], enum_set_values:[]}, {item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:8, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":79}}, {item_type:"T_OP_CASE", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:6, precision:-1, scale:-1}, flag:0, calc_type:{type:"TINYINT", collation:"binary", coercibility:"NUMERIC"}}, expr_info:["CNT_CONST", "CNT_COLUMN", "CNT_PARAM"], rel_id:[], expr_levels:[], arg_case:null, default:{item_type:"T_NULL", result_type:{meta:{type:"NULL", collation:"binary", coercibility:"IGNORABLE"}, accuracy:{length:0, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "CNT_CONST"], rel_id:[], value:{"NULL":"NULL"}}, when:[{item_type:"T_OP_EQ", result_type:{meta:{type:"INT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:1, scale:0}, flag:0, calc_type:{type:"VARCHAR", collation:"utf8mb4_bin", coercibility:"IMPLICIT"}}, expr_info:["CNT_CONST", "CNT_COLUMN", "CNT_PARAM", "IS_SIMPLE_COND"], rel_id:[], expr_levels:[], children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_bin", coercibility:"IMPLICIT"}, accuracy:{length:6, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:1112705767363193, column_id:31, database_name:"ccam", table_name:"ccam_para_doc_log", synonym_name:"", synonym_db_name:"", column_name:"OPERATION_TYPE", expr_level:0, expr_levels:[0], column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}, {item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:3, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":80}}]}, {item_type:"T_OP_EQ", result_type:{meta:{type:"INT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:1, scale:0}, flag:0, calc_type:{type:"VARCHAR", collation:"utf8mb4_bin", coercibility:"IMPLICIT"}}, expr_info:["CNT_CONST", "CNT_COLUMN", "CNT_PARAM", "IS_SIMPLE_COND"], rel_id:[], expr_levels:[], children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_bin", coercibility:"IMPLICIT"}, accuracy:{length:6, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:1112705767363193, column_id:31, database_name:"ccam", table_name:"ccam_para_doc_log", synonym_name:"", synonym_db_name:"", column_name:"OPERATION_TYPE", expr_level:0, expr_levels:[0], column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}, {item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:3, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":82}}]}], then:[{item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:3, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":81}}, {item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:6, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":83}}], decode:false}, {item_type:"T_FUN_SYS_CHAR", result_type:{meta:{type:"VARCHAR", collation:"binary", coercibility:"COERCIBLE"}, accuracy:{length:134217728, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_FUNC", "IS_CALCULABLE_EXPR", "IS_CONST_EXPR", "CNT_CONST", "CNT_PARAM", "CNT_FUNC", "CNT_CALCULABLE_EXPR"], rel_id:[], expr_levels:[], func:"char", children:[{item_type:"T_QUESTIONMARK", result_type:{meta:{type:"BIGINT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:2, precision:2, scale:0}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":84}}, {item_type:"T_VARCHAR", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "CNT_CONST"], rel_id:[], value:{"VARCHAR":"binary", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}}], enum_set_values:[]}, {item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:8, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":85}}, {item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:3, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":86}}, {item_type:"T_FUN_SYS_CHAR", result_type:{meta:{type:"VARCHAR", collation:"binary", coercibility:"COERCIBLE"}, accuracy:{length:134217728, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_FUNC", "IS_CALCULABLE_EXPR", "IS_CONST_EXPR", "CNT_CONST", "CNT_PARAM", "CNT_FUNC", "CNT_CALCULABLE_EXPR"], rel_id:[], expr_levels:[], func:"char", children:[{item_type:"T_QUESTIONMARK", result_type:{meta:{type:"BIGINT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:2, precision:2, scale:0}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":87}}, {item_type:"T_VARCHAR", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "CNT_CONST"], rel_id:[], value:{"VARCHAR":"binary", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}}], enum_set_values:[]}, {item_type:"T_FUN_SYS_CHAR", result_type:{meta:{type:"VARCHAR", collation:"binary", coercibility:"COERCIBLE"}, accuracy:{length:134217728, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_FUNC", "IS_CALCULABLE_EXPR", "IS_CONST_EXPR", "CNT_CONST", "CNT_PARAM", "CNT_FUNC", "CNT_CALCULABLE_EXPR"], rel_id:[], expr_levels:[], func:"char", children:[{item_type:"T_QUESTIONMARK", result_type:{meta:{type:"BIGINT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:2, precision:2, scale:0}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":88}}, {item_type:"T_VARCHAR", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "CNT_CONST"], rel_id:[], value:{"VARCHAR":"binary", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}}], enum_set_values:[]}, {item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:3, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":89}}], enum_set_values:[]}, when:[{item_type:"T_OP_AND", result_type:{meta:{type:"INT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:1, scale:0}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["CNT_CONST", "CNT_COLUMN", "CNT_PARAM"], rel_id:[], expr_levels:[], children:[{item_type:"T_OP_IS_NOT", result_type:{meta:{type:"INT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:1, scale:0}, flag:1, calc_type:{type:"VARCHAR", collation:"utf8mb4_bin", coercibility:"IMPLICIT"}}, expr_info:["CNT_CONST", "CNT_COLUMN"], rel_id:[], expr_levels:[], children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_bin", coercibility:"IMPLICIT"}, accuracy:{length:8, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:1112705767363193, column_id:20, database_name:"ccam", table_name:"ccam_para_doc_log", synonym_name:"", synonym_db_name:"", column_name:"PARENT_FILE_ID", expr_level:0, expr_levels:[0], column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}, {item_type:"T_NULL", result_type:{meta:{type:"NULL", collation:"binary", coercibility:"IGNORABLE"}, accuracy:{length:0, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "CNT_CONST"], rel_id:[], value:{"NULL":"NULL"}}, {item_type:"T_BOOL", result_type:{meta:{type:"TINYINT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "CNT_CONST"], rel_id:[], value:{"TINYINT":0}}]}, {item_type:"T_OP_NE", result_type:{meta:{type:"INT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:1, scale:0}, flag:0, calc_type:{type:"VARCHAR", collation:"utf8mb4_bin", coercibility:"IMPLICIT"}}, expr_info:["CNT_CONST", "CNT_COLUMN", "CNT_PARAM"], rel_id:[], expr_levels:[], children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_bin", coercibility:"IMPLICIT"}, accuracy:{length:8, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:1112705767363193, column_id:20, database_name:"ccam", table_name:"ccam_para_doc_log", synonym_name:"", synonym_db_name:"", column_name:"PARENT_FILE_ID", expr_level:0, expr_levels:[0], column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}, {item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:0, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":10}}]}]}], then:[{item_type:"T_OP_CNN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_bin", coercibility:"IMPLICIT"}, accuracy:{length:-1743780173, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_FUNC", "CNT_CONST_EXPR", "CNT_CONST", "CNT_COLUMN", "CNT_PARAM", "CNT_FUNC", "CNT_CALCULABLE_EXPR", "CNT_STATE_FUNC"], rel_id:[], expr_levels:[], func:"concat", children:[{item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:5, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":11}}, {item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_bin", coercibility:"IMPLICIT"}, accuracy:{length:50, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:1112705767363193, column_id:34, database_name:"ccam", table_name:"ccam_para_doc_log", synonym_name:"", synonym_db_name:"", column_name:"CREATOR_NAME", expr_level:0, expr_levels:[0], column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}, {item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:1, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":12}}, {item_type:"T_FUN_SYS_CHAR", result_type:{meta:{type:"VARCHAR", collation:"binary", coercibility:"COERCIBLE"}, accuracy:{length:134217728, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_FUNC", "IS_CALCULABLE_EXPR", "IS_CONST_EXPR", "CNT_CONST", "CNT_PARAM", "CNT_FUNC", "CNT_CALCULABLE_EXPR"], rel_id:[], expr_levels:[], func:"char", children:[{item_type:"T_QUESTIONMARK", result_type:{meta:{type:"BIGINT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:2, precision:2, scale:0}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":13}}, {item_type:"T_VARCHAR", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "CNT_CONST"], rel_id:[], value:{"VARCHAR":"binary", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}}], enum_set_values:[]}, {item_type:"T_FUN_SYS_CHAR", result_type:{meta:{type:"VARCHAR", collation:"binary", coercibility:"COERCIBLE"}, accuracy:{length:134217728, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_FUNC", "IS_CALCULABLE_EXPR", "IS_CONST_EXPR", "CNT_CONST", "CNT_PARAM", "CNT_FUNC", "CNT_CALCULABLE_EXPR"], rel_id:[], expr_levels:[], func:"char", children:[{item_type:"T_QUESTIONMARK", result_type:{meta:{type:"BIGINT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:2, precision:2, scale:0}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":14}}, {item_type:"T_VARCHAR", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "CNT_CONST"], rel_id:[], value:{"VARCHAR":"binary", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}}], enum_set_values:[]}, {item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:52, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":15}}, {item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_bin", coercibility:"IMPLICIT"}, accuracy:{length:50, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:1112705767363193, column_id:39, database_name:"ccam", table_name:"ccam_para_doc_log", synonym_name:"", synonym_db_name:"", column_name:"APPROVER_NAME", expr_level:0, expr_levels:[0], column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}, {item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:4, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":16}}, {item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_bin", coercibility:"IMPLICIT"}, accuracy:{length:19, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:1112705767363193, column_id:37, database_name:"ccam", table_name:"ccam_para_doc_log", synonym_name:"", synonym_db_name:"", column_name:"APPROVE_TIME", expr_level:0, expr_levels:[0], column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}, {item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:54, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":17}}, {item_type:"T_FUN_SYS_CHAR", result_type:{meta:{type:"VARCHAR", collation:"binary", coercibility:"COERCIBLE"}, accuracy:{length:134217728, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_FUNC", "IS_CALCULABLE_EXPR", "IS_CONST_EXPR", "CNT_CONST", "CNT_PARAM", "CNT_FUNC", "CNT_CALCULABLE_EXPR"], rel_id:[], expr_levels:[], func:"char", children:[{item_type:"T_QUESTIONMARK", result_type:{meta:{type:"BIGINT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:2, precision:2, scale:0}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":18}}, {item_type:"T_VARCHAR", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "CNT_CONST"], rel_id:[], value:{"VARCHAR":"binary", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}}], enum_set_values:[]}, {item_type:"T_FUN_SYS_CHAR", result_type:{meta:{type:"VARCHAR", collation:"binary", coercibility:"COERCIBLE"}, accuracy:{length:134217728, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_FUNC", "IS_CALCULABLE_EXPR", "IS_CONST_EXPR", "CNT_CONST", "CNT_PARAM", "CNT_FUNC", "CNT_CALCULABLE_EXPR"], rel_id:[], expr_levels:[], func:"char", children:[{item_type:"T_QUESTIONMARK", result_type:{meta:{type:"BIGINT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:2, precision:2, scale:0}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":19}}, {item_type:"T_VARCHAR", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "CNT_CONST"], rel_id:[], value:{"VARCHAR":"binary", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}}], enum_set_values:[]}, {item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:29, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":20}}, {item_type:"T_FUN_UDF", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:1048576, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_FUNC", "IS_STATE_FUNC", "CNT_CONST", "CNT_COLUMN", "CNT_PARAM", "CNT_FUNC", "CNT_STATE_FUNC"], rel_id:[], expr_levels:[], database:"ccam", package_name:"", func:"get_dict_value", udf_id:1112705767310378, pkg_id:18446744073709551615, subprogram_path:[], is_deterministic:false, is_udt_udf:false, udf_schema_version:1657190253439024, pkg_schema_version:-1, is_pkg_body_udf:false, children:[{item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:5, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":21}}, {item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:8, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":22}}, {item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_bin", coercibility:"IMPLICIT"}, accuracy:{length:2, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:1112705767363193, column_id:21, database_name:"ccam", table_name:"ccam_para_doc_log", synonym_name:"", synonym_db_name:"", column_name:"FILE_TYPE", expr_level:0, expr_levels:[0], column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}]}, {item_type:"T_FUN_SYS_CHAR", result_type:{meta:{type:"VARCHAR", collation:"binary", coercibility:"COERCIBLE"}, accuracy:{length:134217728, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_FUNC", "IS_CALCULABLE_EXPR", "IS_CONST_EXPR", "CNT_CONST", "CNT_PARAM", "CNT_FUNC", "CNT_CALCULABLE_EXPR"], rel_id:[], expr_levels:[], func:"char", children:[{item_type:"T_QUESTIONMARK", result_type:{meta:{type:"BIGINT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:2, precision:2, scale:0}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":23}}, {item_type:"T_VARCHAR", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "CNT_CONST"], rel_id:[], value:{"VARCHAR":"binary", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}}], enum_set_values:[]}, {item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:15, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":24}}, {item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:300, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:1112705767363193, column_id:28, database_name:"ccam", table_name:"ccam_para_doc_log", synonym_name:"", synonym_db_name:"", column_name:"DOC_TYPE_EN", expr_level:0, expr_levels:[0], column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}, {item_type:"T_FUN_SYS_CHAR", result_type:{meta:{type:"VARCHAR", collation:"binary", coercibility:"COERCIBLE"}, accuracy:{length:134217728, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_FUNC", "IS_CALCULABLE_EXPR", "IS_CONST_EXPR", "CNT_CONST", "CNT_PARAM", "CNT_FUNC", "CNT_CALCULABLE_EXPR"], rel_id:[], expr_levels:[], func:"char", children:[{item_type:"T_QUESTIONMARK", result_type:{meta:{type:"BIGINT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:2, precision:2, scale:0}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":25}}, {item_type:"T_VARCHAR", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "CNT_CONST"], rel_id:[], value:{"VARCHAR":"binary", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}}], enum_set_values:[]}, {item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:17, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":26}}, {item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:300, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:1112705767363193, column_id:22, database_name:"ccam", table_name:"ccam_para_doc_log", synonym_name:"", synonym_db_name:"", column_name:"NEW_FILE_NAME_US", expr_level:0, expr_levels:[0], column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}, {item_type:"T_FUN_SYS_CHAR", result_type:{meta:{type:"VARCHAR", collation:"binary", coercibility:"COERCIBLE"}, accuracy:{length:134217728, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_FUNC", "IS_CALCULABLE_EXPR", "IS_CONST_EXPR", "CNT_CONST", "CNT_PARAM", "CNT_FUNC", "CNT_CALCULABLE_EXPR"], rel_id:[], expr_levels:[], func:"char", children:[{item_type:"T_QUESTIONMARK", result_type:{meta:{type:"BIGINT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:2, precision:2, scale:0}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":27}}, {item_type:"T_VARCHAR", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "CNT_CONST"], rel_id:[], value:{"VARCHAR":"binary", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}}], enum_set_values:[]}, {item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:26, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":28}}, {item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:300, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:1112705767363193, column_id:23, database_name:"ccam", table_name:"ccam_para_doc_log", synonym_name:"", synonym_db_name:"", column_name:"NEW_FILE_NAME_CN", expr_level:0, expr_levels:[0], column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}, {item_type:"T_FUN_SYS_CHAR", result_type:{meta:{type:"VARCHAR", collation:"binary", coercibility:"COERCIBLE"}, accuracy:{length:134217728, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_FUNC", "IS_CALCULABLE_EXPR", "IS_CONST_EXPR", "CNT_CONST", "CNT_PARAM", "CNT_FUNC", "CNT_CALCULABLE_EXPR"], rel_id:[], expr_levels:[], func:"char", children:[{item_type:"T_QUESTIONMARK", result_type:{meta:{type:"BIGINT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:2, precision:2, scale:0}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":29}}, {item_type:"T_VARCHAR", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "CNT_CONST"], rel_id:[], value:{"VARCHAR":"binary", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}}], enum_set_values:[]}, {item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:26, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":30}}, {item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:300, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:1112705767363193, column_id:24, database_name:"ccam", table_name:"ccam_para_doc_log", synonym_name:"", synonym_db_name:"", column_name:"NEW_FILE_NAME_HK", expr_level:0, expr_levels:[0], column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}, {item_type:"T_FUN_SYS_CHAR", result_type:{meta:{type:"VARCHAR", collation:"binary", coercibility:"COERCIBLE"}, accuracy:{length:134217728, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_FUNC", "IS_CALCULABLE_EXPR", "IS_CONST_EXPR", "CNT_CONST", "CNT_PARAM", "CNT_FUNC", "CNT_CALCULABLE_EXPR"], rel_id:[], expr_levels:[], func:"char", children:[{item_type:"T_QUESTIONMARK", result_type:{meta:{type:"BIGINT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:2, precision:2, scale:0}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":31}}, {item_type:"T_VARCHAR", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "CNT_CONST"], rel_id:[], value:{"VARCHAR":"binary", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}}], enum_set_values:[]}, {item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:8, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":32}}, {item_type:"T_OP_CASE", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:6, precision:-1, scale:-1}, flag:0, calc_type:{type:"TINYINT", collation:"binary", coercibility:"NUMERIC"}}, expr_info:["CNT_CONST", "CNT_COLUMN", "CNT_PARAM"], rel_id:[], expr_levels:[], arg_case:null, default:{item_type:"T_NULL", result_type:{meta:{type:"NULL", collation:"binary", coercibility:"IGNORABLE"}, accuracy:{length:0, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "CNT_CONST"], rel_id:[], value:{"NULL":"NULL"}}, when:[{item_type:"T_OP_EQ", result_type:{meta:{type:"INT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:1, scale:0}, flag:0, calc_type:{type:"VARCHAR", collation:"utf8mb4_bin", coercibility:"IMPLICIT"}}, expr_info:["CNT_CONST", "CNT_COLUMN", "CNT_PARAM", "IS_SIMPLE_COND"], rel_id:[], expr_levels:[], children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_bin", coercibility:"IMPLICIT"}, accuracy:{length:1, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:1112705767363193, column_id:43, database_name:"ccam", table_name:"ccam_para_doc_log", synonym_name:"", synonym_db_name:"", column_name:"FLAG", expr_level:0, expr_levels:[0], column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}, {item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:1, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":33}}]}, {item_type:"T_OP_EQ", result_type:{meta:{type:"INT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:1, scale:0}, flag:0, calc_type:{type:"VARCHAR", collation:"utf8mb4_bin", coercibility:"IMPLICIT"}}, expr_info:["CNT_CONST", "CNT_COLUMN", "CNT_PARAM", "IS_SIMPLE_COND"], rel_id:[], expr_levels:[], children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_bin", coercibility:"IMPLICIT"}, accuracy:{length:1, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:1112705767363193, column_id:43, database_name:"ccam", table_name:"ccam_para_doc_log", synonym_name:"", synonym_db_name:"", column_name:"FLAG", expr_level:0, expr_levels:[0], column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}, {item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:1, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":35}}]}], then:[{item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:6, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":34}}, {item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:6, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":36}}], decode:false}, {item_type:"T_FUN_SYS_CHAR", result_type:{meta:{type:"VARCHAR", collation:"binary", coercibility:"COERCIBLE"}, accuracy:{length:134217728, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_FUNC", "IS_CALCULABLE_EXPR", "IS_CONST_EXPR", "CNT_CONST", "CNT_PARAM", "CNT_FUNC", "CNT_CALCULABLE_EXPR"], rel_id:[], expr_levels:[], func:"char", children:[{item_type:"T_QUESTIONMARK", result_type:{meta:{type:"BIGINT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:2, precision:2, scale:0}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":37}}, {item_type:"T_VARCHAR", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "CNT_CONST"], rel_id:[], value:{"VARCHAR":"binary", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}}], enum_set_values:[]}, {item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:8, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":38}}, {item_type:"T_OP_CASE", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:6, precision:-1, scale:-1}, flag:0, calc_type:{type:"TINYINT", collation:"binary", coercibility:"NUMERIC"}}, expr_info:["CNT_CONST", "CNT_COLUMN", "CNT_PARAM"], rel_id:[], expr_levels:[], arg_case:null, default:{item_type:"T_NULL", result_type:{meta:{type:"NULL", collation:"binary", coercibility:"IGNORABLE"}, accuracy:{length:0, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "CNT_CONST"], rel_id:[], value:{"NULL":"NULL"}}, when:[{item_type:"T_OP_EQ", result_type:{meta:{type:"INT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:1, scale:0}, flag:0, calc_type:{type:"VARCHAR", collation:"utf8mb4_bin", coercibility:"IMPLICIT"}}, expr_info:["CNT_CONST", "CNT_COLUMN", "CNT_PARAM", "IS_SIMPLE_COND"], rel_id:[], expr_levels:[], children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_bin", coercibility:"IMPLICIT"}, accuracy:{length:6, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:1112705767363193, column_id:31, database_name:"ccam", table_name:"ccam_para_doc_log", synonym_name:"", synonym_db_name:"", column_name:"OPERATION_TYPE", expr_level:0, expr_levels:[0], column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}, {item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:3, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":39}}]}, {item_type:"T_OP_EQ", result_type:{meta:{type:"INT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:1, scale:0}, flag:0, calc_type:{type:"VARCHAR", collation:"utf8mb4_bin", coercibility:"IMPLICIT"}}, expr_info:["CNT_CONST", "CNT_COLUMN", "CNT_PARAM", "IS_SIMPLE_COND"], rel_id:[], expr_levels:[], children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_bin", coercibility:"IMPLICIT"}, accuracy:{length:6, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:1112705767363193, column_id:31, database_name:"ccam", table_name:"ccam_para_doc_log", synonym_name:"", synonym_db_name:"", column_name:"OPERATION_TYPE", expr_level:0, expr_levels:[0], column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}, {item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:3, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":41}}]}], then:[{item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:3, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":40}}, {item_type:"T_QUESTIONMARK", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:6, precision:1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":42}}], decode:false}], enum_set_values:[]}], decode:false})
[2022-09-23 14:52:31.508798] WARN [SQL.RESV] formalize_stmt (ob_dml_stmt.cpp:1899) [20290][2304][YB427B230D33-0005E544A0DFD904] [lt=623] [dc=0] failed to formalize expr(ret=-4016)
[2022-09-23 14:52:31.508802] WARN [SQL.RESV] resolve_normal_query (ob_select_resolver.cpp:852) [20290][2304][YB427B230D33-0005E544A0DFD904] [lt=3] [dc=0] fail to exec select_stmt->formalize_stmt(session_info_)(ret=-4016)
[2022-09-23 14:52:31.508805] WARN [SQL.RESV] resolve (ob_select_resolver.cpp:960) [20290][2304][YB427B230D33-0005E544A0DFD904] [lt=3] [dc=0] resolve normal query failed(ret=-4016)
[2022-09-23 14:52:31.508808] WARN [SQL.RESV] select_stmt_resolver_func (ob_resolver.cpp:178) [20290][2304][YB427B230D33-0005E544A0DFD904] [lt=2] [dc=0] execute stmt_resolver failed(ret=-4016, parse_tree.type_=3035)
[2022-09-23 14:52:31.508814] WARN [SQL] generate_stmt (ob_sql.cpp:1796) [20290][2304][YB427B230D33-0005E544A0DFD904] [lt=3] [dc=0] failed to resolve(ret=-4016)
[2022-09-23 14:52:31.508818] WARN [SQL] generate_physical_plan (ob_sql.cpp:1905) [20290][2304][YB427B230D33-0005E544A0DFD904] [lt=3] [dc=0] Failed to generate stmt(ret=-4016, result.get_exec_context().need_disconnect()=false)
[2022-09-23 14:52:31.508822] WARN [SQL] handle_physical_plan (ob_sql.cpp:3965) [20290][2304][YB427B230D33-0005E544A0DFD904] [lt=3] [dc=0] Failed to generate plan(ret=-4016, result.get_exec_context().need_disconnect()=false)
[2022-09-23 14:52:31.508825] WARN [SQL] handle_text_query (ob_sql.cpp:1555) [20290][2304][YB427B230D33-0005E544A0DFD904] [lt=2] [dc=0] fail to handle physical plan(ret=-4016)
[2022-09-23 14:52:31.508830] WARN [SQL] stmt_query (ob_sql.cpp:190) [20290][2304][YB427B230D33-0005E544A0DFD904] [lt=2] [dc=0] fail to handle text query(stmt=select date_format(Now(), '%Y%m%d%H%i%s'), '123', creator_email, '', '', concat('[Credit Card Application Management System] ', 'Parameter of ', case when parent_file_id is not null and parent_file_id != '' then 'Document' else 'Document Type' end, ' (', new_file_name_us, ') was approved by ', approver_name), case when parent_file_id is not null and parent_file_id != '' then concat('Dear ', creator_name, ',', CHAR(13), CHAR(13), 'The following Parameter of Document was approved by ', approver_name, ' at ', approve_time, ', you can access the details via the link, thank you. ', CHAR(13), CHAR(13), 'Supplementary Document Type: ', get_dict_value('en_US', 'SMS_TYPE', file_type), CHAR(13), 'Document Type: ', doc_type_en, CHAR(13), 'Document (Eng.): ', new_file_name_us, CHAR(13), 'Document (Simp. Chinese): ', new_file_name_cn, CHAR(13), 'Document (Trad. Chinese): ', new_file_name_hk, CHAR(13), 'Status: ', case when flag = 'Y' then 'Active' when flag = 'N' then 'Frozen' end, CHAR(13), 'Action: ', case when operation_type = 'ADD' then 'New' when operation_type = 'UPD' then 'Update' end, CHAR(13), 'Reason: ', '1232', CHAR(13), CHAR(13), '343', CHAR(13), CHAR(13), 'Best Regards,', CHAR(13), CHAR(13), 'Credit Card Application Management System', CHAR(13), CHAR(13), '*** This is an automatically generated email, please do not reply *** ') else concat('Dear ', creator_name, ',', CHAR(13), CHAR(13), 'The following Parameter of Document Type was approved by ', approver_name, ' at ', approve_time, ', you can access the details via the link, thank you. ', CHAR(13), CHAR(13), 'Document Type (Eng.): ', new_file_name_us, CHAR(13), 'Document Type (Simp. Chinese): ', new_file_name_cn, CHAR(13), 'Document Type (Trad. Chinese): ', new_file_name_hk, CHAR(13), 'Status: ', case when flag = 'Y' then 'Active' when flag = 'N' then 'Frozen' end, CHAR(13), 'Action: ', case when operation_type = 'ADD' then 'New' when operation_type = 'UPD' then 'Update' end, CHAR(13), 'Reason: ', '565', CHAR(13), CHAR(13), '676', CHAR(13), CHAR(13), 'Best Regards,', CHAR(13), CHAR(13), 'Credit Card Application Management System', CHAR(13), CHAR(13), '*** This is an automatically generated email, please do not reply *** ') end, '2', concat(date_format(Now(), '%Y%m%d%H%i%s'), record_id), '20220922175335000817836', '', '0' from ccam_para_doc_log where record_id = '20220922175335000817836', ret=-4016)
[2022-09-23 14:52:31.508836] WARN [SERVER] test_and_save_retry_state (ob_query_retry_ctrl.cpp:532) [20290][2304][YB427B230D33-0005E544A0DFD904] [lt=4] [dc=0] do not need retry(client_ret=-4016, err=-4016, expected_stmt=true, THIS_WORKER.get_timeout_ts()=1663917751506872, retry_type_=0, result.get_stmt_type()=1, result.get_exec_context().need_change_timeout_ret()=true, session->get_retry_info().get_last_query_retry_err()=0)
[2022-09-23 14:52:31.508844] INFO [SERVER] ob_query_retry_ctrl.cpp:558 [20290][2304][YB427B230D33-0005E544A0DFD904] [lt=7] [dc=0] check if need retry(client_ret=-4016, err=-4016, retry_type_=0, retry_times=1, multi_stmt_item={is_part_of_multi_stmt:true, seq_num:0, sql:"select date_format(Now(), '%Y%m%d%H%i%s'), '123', creator_email, '', '', concat('[Credit Card Application Management System] ', 'Parameter of ', case when parent_file_id is not null and parent_file_id != '' then 'Document' else 'Document Type' end, ' (', new_file_name_us, ') was approved by ', approver_name), case when parent_file_id is not null and parent_file_id != '' then concat('Dear ', creator_name, ',', CHAR(13), CHAR(13), 'The following Parameter of Document was approved by ', approver_name, ' at ', approve_time, ', you can access the details via the link, thank you. ', CHAR(13), CHAR(13), 'Supplementary Document Type: ', get_dict_value('en_US', 'SMS_TYPE', file_type), CHAR(13), 'Document Type: ', doc_type_en, CHAR(13), 'Document (Eng.): ', new_file_name_us, CHAR(13), 'Document (Simp. Chinese): ', new_file_name_cn, CHAR(13), 'Document (Trad. Chinese): ', new_file_name_hk, CHAR(13), 'Status: ', case when flag = 'Y' then 'Active' when flag = 'N' then 'Frozen' end, CHAR(13), 'Action: ', case when operation_type = 'ADD' then 'New' when operation_type = 'UPD' then 'Update' end, CHAR(13), 'Reason: ', '1232', CHAR(13), CHAR(13), '343', CHAR(13), CHAR(13), 'Best Regards,', CHAR(13), CHAR(13), 'Credit Card Application Management System', CHAR(13), CHAR(13), '*** This is an automatically generated email, please do not reply *** ') else concat('Dear ', creator_name, ',', CHAR(13), CHAR(13), 'The following Parameter of Document Type was approved by ', approver_name, ' at ', approve_time, ', you can access the details via the link, thank you. ', CHAR(13), CHAR(13), 'Document Type (Eng.): ', new_file_name_us, CHAR(13), 'Document Type (Simp. Chinese): ', new_file_name_cn, CHAR(13), 'Document Type (Trad. Chinese): ', new_file_name_hk, CHAR(13), 'Status: ', case when flag = 'Y' then 'Active' when flag = 'N' then 'Frozen' end, CHAR(13), 'Action: ', case when operation_type = 'ADD' then 'New' when operation_type = 'UPD' then 'Update' end, CHAR(13), 'Reason: ', '565', CHAR(13), CHAR(13), '676', CHAR(13), CHAR(13), 'Best Regards,', CHAR(13), CHAR(13), 'Credit Card Application Management System', CHAR(13), CHAR(13), '*** This is an automatically generated email, please do not reply *** ') end, '2', concat(date_format(Now(), '%Y%m%d%H%i%s'), record_id), '20220922175335000817836', '', '0' from ccam_para_doc_log where record_id = '20220922175335000817836'"})
[2022-09-23 14:52:31.508851] WARN [SERVER] do_process (obmp_query.cpp:661) [20290][2304][YB427B230D33-0005E544A0DFD904] [lt=5] [dc=0] run stmt_query failed, check if need retry(ret=-4016, cli_ret=-4016, retry_ctrl_.need_retry()=0, sql=select date_format(Now(), '%Y%m%d%H%i%s'), '123', creator_email, '', '', concat('[Credit Card Application Management System] ', 'Parameter of ', case when parent_file_id is not null and parent_file_id != '' then 'Document' else 'Document Type' end, ' (', new_file_name_us, ') was approved by ', approver_name), case when parent_file_id is not null and parent_file_id != '' then concat('Dear ', creator_name, ',', CHAR(13), CHAR(13), 'The following Parameter of Document was approved by ', approver_name, ' at ', approve_time, ', you can access the details via the link, thank you. ', CHAR(13), CHAR(13), 'Supplementary Document Type: ', get_dict_value('en_US', 'SMS_TYPE', file_type), CHAR(13), 'Document Type: ', doc_type_en, CHAR(13), 'Document (Eng.): ', new_file_name_us, CHAR(13), 'Document (Simp. Chinese): ', new_file_name_cn, CHAR(13), 'Document (Trad. Chinese): ', new_file_name_hk, CHAR(13), 'Status: ', case when flag = 'Y' then 'Active' when flag = 'N' then 'Frozen' end, CHAR(13), 'Action: ', case when operation_type = 'ADD' then 'New' when operation_type = 'UPD' then 'Update' end, CHAR(13), 'Reason: ', '1232', CHAR(13), CHAR(13), '343', CHAR(13), CHAR(13), 'Best Regards,', CHAR(13), CHAR(13), 'Credit Card Application Management System', CHAR(13), CHAR(13), '*** This is an automatically generated email, please do not reply *** ') else concat('Dear ', creator_name, ',', CHAR(13), CHAR(13), 'The following Parameter of Document Type was approved by ', approver_name, ' at ', approve_time, ', you can access the details via the link, thank you. ', CHAR(13), CHAR(13), 'Document Type (Eng.): ', new_file_name_us, CHAR(13), 'Document Type (Simp. Chinese): ', new_file_name_cn, CHAR(13), 'Document Type (Trad. Chinese): ', new_file_name_hk, CHAR(13), 'Status: ', case when flag = 'Y' then 'Active' when flag = 'N' then 'Frozen' end, CHAR(13), 'Action: ', case when operation_type = 'ADD' then 'New' when operation_type = 'UPD' then 'Update' end, CHAR(13), 'Reason: ', '565', CHAR(13), CHAR(13), '676', CHAR(13), CHAR(13), 'Best Regards,', CHAR(13), CHAR(13), 'Credit Card Application Management System', CHAR(13), CHAR(13), '*** This is an automatically generated email, please do not reply *** ') end, '2', concat(date_format(Now(), '%Y%m%d%H%i%s'), record_id), '20220922175335000817836', '', '0' from ccam_para_doc_log where record_id = '20220922175335000817836')
[2022-09-23 14:52:31.508866] WARN [SERVER] do_process (obmp_query.cpp:779) [20290][2304][YB427B230D33-0005E544A0DFD904] [lt=4] [dc=0] query failed(ret=-4016, retry_ctrl_.need_retry()=0)
[2022-09-23 14:52:31.508898] INFO [SERVER] obmp_base.cpp:1244 [20290][2304][YB427B230D33-0005E544A0DFD904] [lt=3] [dc=0] sending error packet(err=-4016, bt="0xd6bc498 0xd6a43d9 0x9bbdfff 0x9bd56ea 0x328fb1b 0x32886e9 0x32860c1 0x3280dd4 0xa882fea 0x3c1a7e7 0xd451786 0xd44edaf 0xd44cb6e", extra_err_info=0x7ed62abbb8e0)
[2022-09-23 14:52:31.508948] TRACE [TRACE]:0 [20290][2304][YB427B230D33-0005E544A0DFD904] [lt=3] [dc=0] [show trace](TRACE=begin_ts=1663915951506884 2022-09-23 06:52:31.506884|[process_begin] u=0 in_queue_time:11, receive_ts:1663915951506872, enqueue_ts:1663915951506874|[start_sql] u=0 addr:{ip:"123.35.13.51", port:14984}|[query_begin] u=1 trace_id:YB427B230D33-0005E544A0DFD904|[before_processor_run] u=3 |[session] u=2 sid:3221563370, tenant_id:1012|[session] u=7 sid:3221563370, tenant_id:1012|[parse_begin] u=14 stmt:"select date_format(Now(), '%Y%m%d%H%i%s'), '123', creator_email, '', '', concat('[Credit Card Application Management System] ', 'Parameter of ', case when parent_file_id is not null and parent_file_id != '' then 'Document' else 'Document Type' end, ' (', new_file_name_us, ') was approved by ', approver_name), case when parent_file_id is not null and parent_file_id != '' then concat('Dear ', creator_name, ',', CHAR(13), CHAR(13), 'The following Parameter of Document was approved by ', appro", stmt_len:2578|[cache_get_plan_begin] u=2 |[cache_get_plan_end] u=56 |[transform_with_outline_begin] u=0 |[pc_fast_parse_start] u=177 |[pc_fast_parse_end] u=26 |[transform_with_outline_end] u=10 |[resolve_begin] u=155 |[resolve_end] u=1476 |[session] u=93 sid:3221563370, tenant_id:1012|[query_end] u=39 |total_timeu=2061)
[2022-09-23 14:52:31.508968] WARN [SERVER] process (obmp_query.cpp:313) [20290][2304][YB427B230D33-0005E544A0DFD904] [lt=19] [dc=0] fail execute sql(sql_id="", sql=select date_format(Now(), '%Y%m%d%H%i%s'), '123', creator_email, '', '', concat('[Credit Card Application Management System] ', 'Parameter of ', case when parent_file_id is not null and parent_file_id != '' then 'Document' else 'Document Type' end, ' (', new_file_name_us, ') was approved by ', approver_name), case when parent_file_id is not null and parent_file_id != '' then concat('Dear ', creator_name, ',', CHAR(13), CHAR(13), 'The following Parameter of Document was approved by ', approver_name, ' at ', approve_time, ', you can access the details via the link, thank you. ', CHAR(13), CHAR(13), 'Supplementary Document Type: ', get_dict_value('en_US', 'SMS_TYPE', file_type), CHAR(13), 'Document Type: ', doc_type_en, CHAR(13), 'Document (Eng.): ', new_file_name_us, CHAR(13), 'Document (Simp. Chinese): ', new_file_name_cn, CHAR(13), 'Document (Trad. Chinese): ', new_file_name_hk, CHAR(13), 'Status: ', case when flag = 'Y' then 'Active' when flag = 'N' then 'Frozen' end, CHAR(13), 'Action: ', case when operation_type = 'ADD' then 'New' when operation_type = 'UPD' then 'Update' end, CHAR(13), 'Reason: ', '1232', CHAR(13), CHAR(13), '343', CHAR(13), CHAR(13), 'Best Regards,', CHAR(13), CHAR(13), 'Credit Card Application Management System', CHAR(13), CHAR(13), '*** This is an automatically generated email, please do not reply *** ') else concat('Dear ', creator_name, ',', CHAR(13), CHAR(13), 'The following Parameter of Document Type was approved by ', approver_name, ' at ', approve_time, ', you can access the details via the link, thank you. ', CHAR(13), CHAR(13), 'Document Type (Eng.): ', new_file_name_us, CHAR(13), 'Document Type (Simp. Chinese): ', new_file_name_cn, CHAR(13), 'Document Type (Trad. Chinese): ', new_file_name_hk, CHAR(13), 'Status: ', case when flag = 'Y' then 'Active' when flag = 'N' then 'Frozen' end, CHAR(13), 'Action: ', case when operation_type = 'ADD' then 'New' when operation_type = 'UPD' then 'Update' end, CHAR(13), 'Reason: ', '565', CHAR(13), CHAR(13), '676', CHAR(13), CHAR(13), 'Best Regards,', CHAR(13), CHAR(13), 'Credit Card Application Management System', CHAR(13), CHAR(13), '*** This is an automatically generated email, please do not reply *** ') end, '2', concat(date_format(Now(), '%Y%m%d%H%i%s'), record_id), '20220922175335000817836', '', '0' from ccam_para_doc_log where record_id = '20220922175335000817836', sessid=3221563370, ret=-4016, ret="OB_ERR_UNEXPECTED", need_disconnect=false)
[2022-09-23 14:52:31.508984] TRACE [TRACE]:0 [20290][2304][YB427B230D33-0005E544A0DFD904] [lt=5] [dc=0] [err query](TRACE=begin_ts=1663915951506884 2022-09-23 06:52:31.506884|[process_begin] u=0 in_queue_time:11, receive_ts:1663915951506872, enqueue_ts:1663915951506874|[start_sql] u=0 addr:{ip:"123.35.13.51", port:14984}|[query_begin] u=1 trace_id:YB427B230D33-0005E544A0DFD904|[before_processor_run] u=3 |[session] u=2 sid:3221563370, tenant_id:1012|[session] u=7 sid:3221563370, tenant_id:1012|[parse_begin] u=14 stmt:"select date_format(Now(), '%Y%m%d%H%i%s'), '123', creator_email, '', '', concat('[Credit Card Application Management System] ', 'Parameter of ', case when parent_file_id is not null and parent_file_id != '' then 'Document' else 'Document Type' end, ' (', new_file_name_us, ') was approved by ', approver_name), case when parent_file_id is not null and parent_file_id != '' then concat('Dear ', creator_name, ',', CHAR(13), CHAR(13), 'The following Parameter of Document was approved by ', appro", stmt_len:2578|[cache_get_plan_begin] u=2 |[cache_get_plan_end] u=56 |[transform_with_outline_begin] u=0 |[pc_fast_parse_start] u=177 |[pc_fast_parse_end] u=26 |[transform_with_outline_end] u=10 |[resolve_begin] u=155 |[resolve_end] u=1476 |[session] u=93 sid:3221563370, tenant_id:1012|[query_end] u=39 |[process_end] u=38 run_ts:1663915951506888|[process_ret] u=0 process_ret:-4016|total_timeu=2099)
问题原因
concat 类型推导，结果 length 为负数导致的报错。
根本原因是 char 表达式类型推导直接设置结果 length 为 max_allowed_packet, 环境中该变量的值为134217728，concat 会把所有参数的 length 求和作为自己推导出的长度，长度使用 int32 变量表示，最大值为2147483647. 2147483647 / 134217728 = 16，因此当 concat 的参数中 char 表达式大于等于 16 个的时候就会溢出，得到一个负的长度。
解决方法
把 concat 参数中连续的 char(13) 合并到一个 char 表达式中,即 char(13), char(13) 改为 char(13, 13)。
适用版本
OceanBase 数据库 V2.x 和 V3.x 版本。
