OceanBase 数据库 V3.x 版本中对于 SQL 的 Group By 上拉改写，在遇到聚合函数中存在相关子查询的场景下，计划生成阶段报错 -4000

SELECT aa.amount
FROM (
        SELECT sum(
                prp.AMOUNT + (
                    SELECT sum(lixi.amount)
                    FROM PTL_RECE_POSITION lixi
                    WHERE prp.PORTFOLIO_ID = lixi.PORTFOLIO_ID
                )
            ) amount,
            prp.SEC_ACCT_ID secAcctId
        FROM PTL_RECE_POSITION prp
        where prp.HODING_TYPE = '03'
            AND prp.REC_TYPE IN ('01', '02')
        GROUP BY prp.SEC_ACCT_ID
    ) aa
    LEFT JOIN PTL_RECE_POSITION_FLOW bb on bb.SEC_ACCT_ID = aa.secAcctId;

[2024-12-30 10:36:54.738752] WDIAG [SQL.OPT] ob_logical_operator.cpp:2131 [2613054][0][xxxxx-xxxxx-xxxxx-xxxxx] [lt=8] [dc=0][errcode=-4000] failed to produce all required expressions(operator="SUBPLAN FILTER", expr_producers=[{consumer_id:67, producer_id:15, producer_branch:0, is_shared_:false, expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:20, precision:-1, scale:-1}, flag:1048577, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551582, column_id:16, database_name:"", table_name:"t1", synonym_name:"", synonym_db_name:"", column_name:"deptcd", 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, is_unique_key_column:false, is_mul_key_column:false, srs_id:18446744073709551584}}, {consumer_id:67, producer_id:15, producer_branch:0, is_shared_:false, expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:15, precision:-1, scale:-1}, flag:1048577, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551582, column_id:18, database_name:"", table_name:"t1", synonym_name:"", synonym_db_name:"", column_name:"projcd", 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, is_unique_key_column:false, is_mul_key_column:false, srs_id:18446744073709551584}}, {consumer_id:67, producer_id:15, producer_branch:0, is_shared_:false, expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:20, precision:-1, scale:-1}, flag:1048577, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551582, column_id:19, database_name:"", table_name:"t1", synonym_name:"", synonym_db_name:"", column_name:"typecd", 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, is_unique_key_column:false, is_mul_key_column:false, srs_id:18446744073709551584}}, {consumer_id:67, producer_id:15, producer_branch:0, is_shared_:false, expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:20, precision:-1, scale:-1}, flag:1048577, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551582, column_id:20, database_name:"", table_name:"t1", synonym_name:"", synonym_db_name:"", column_name:"issuno", 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, is_unique_key_column:false, is_mul_key_column:false, srs_id:18446744073709551584}}, {consumer_id:67, producer_id:15, producer_branch:0, is_shared_:false, expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:20, precision:-1, scale:-1}, flag:1048577, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551582, column_id:17, database_name:"", table_name:"t1", synonym_name:"", synonym_db_name:"", column_name:"acctdp", 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, is_unique_key_column:false, is_mul_key_column:false, srs_id:18446744073709551584}}, {consumer_id:67, producer_id:16, producer_branch:6, is_shared_:false, expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:20, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[2], table_id:18446744073709551581, column_id:18, database_name:"nxyfi", table_name:"abd", synonym_name:"", synonym_db_name:"", column_name:"TOITEM", expr_level:0, expr_levels:[0], column_flags:68719476736, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false, is_unique_key_column:false, is_mul_key_column:false, srs_id:18446744073709551584}}, {consumer_id:67, producer_id:16, producer_branch:6, is_shared_:false, expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:16, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[2], table_id:18446744073709551581, column_id:19, database_name:"nxyfi", table_name:"abd", synonym_name:"", synonym_db_name:"", column_name:"ATDEPT", expr_level:0, expr_levels:[0], column_flags:68719476736, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false, is_unique_key_column:false, is_mul_key_column:false, srs_id:18446744073709551584}}, {consumer_id:67, producer_id:45, producer_branch:0, is_shared_:false, expr:{item_type:"T_FUN_SUM", result_type:{meta:{type:"DECIMAL", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:19, scale:2}, flag:0, calc_type:{type:"DECIMAL", collation:"binary", coercibility:"NUMERIC"}}, expr_info:["IS_AGG", "CNT_CONST", "CNT_COLUMN", "CNT_PARAM", "CNT_AGG", "CNT_FUNC"], rel_id:[1], expr_level:0, expr_levels:[0], children:[{item_type:"T_OP_ADD", result_type:{meta:{type:"DECIMAL", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:19, scale:2}, flag:0, calc_type:{type:"DECIMAL", collation:"binary", coercibility:"NUMERIC"}}, expr_info:["CNT_CONST", "CNT_COLUMN", "CNT_PARAM", "CNT_FUNC"], rel_id:[1], expr_levels:[0], children:[{item_type:"T_FUN_SYS_IFNULL", result_type:{meta:{type:"DECIMAL", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:20, precision:18, scale:2}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_FUNC", "CNT_CONST", "CNT_COLUMN", "CNT_PARAM", "CNT_FUNC"], rel_id:[1], expr_levels:[0], func:"ifnull", children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"DECIMAL", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:18, scale:2}, flag:1048577, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551582, column_id:25, database_name:"", table_name:"t1", synonym_name:"", synonym_db_name:"", column_name:"apcd.ESTIEA", 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, is_unique_key_column:false, is_mul_key_column:false, srs_id:18446744073709551615}, {item_type:"T_QUESTIONMARK", result_type:{meta:{type:"DECIMAL", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:0, precision:18, scale:2}, 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":55}}], enum_set_values:[]}, {item_type:"T_FUN_SYS_IFNULL", result_type:{meta:{type:"DECIMAL", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:12, precision:11, scale:0}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_FUNC", "CNT_CONST", "CNT_COLUMN", "CNT_PARAM", "CNT_FUNC"], rel_id:[1], expr_levels:[0], func:"ifnull", children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"DECIMAL", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:11, scale:0}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551582, column_id:26, database_name:"", table_name:"t1", synonym_name:"", synonym_db_name:"", column_name:"apcd.ADDEAM", 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, is_unique_key_column:false, is_mul_key_column:false, srs_id:18446744073709551615}, {item_type:"T_QUESTIONMARK", result_type:{meta:{type:"DECIMAL", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:0, precision:11, 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":56}}], enum_set_values:[]}]}], distinct:false, order_by:[], separator_param_expr:null, udf_meta:{tenant_id:18446744073709551615, name:"", ret:0, dl:"", type:0}, linear_inter_expr:null, is_nested_aggr:false, pl_agg_udf_expr:null}}, {consumer_id:67, producer_id:15, producer_branch:0, is_shared_:false, expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"DECIMAL", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:18, scale:2}, flag:1048577, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551582, column_id:25, database_name:"", table_name:"t1", synonym_name:"", synonym_db_name:"", column_name:"apcd.ESTIEA", 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, is_unique_key_column:false, is_mul_key_column:false, srs_id:18446744073709551615}}, {consumer_id:67, producer_id:15, producer_branch:0, is_shared_:false, expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"DECIMAL", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:11, scale:0}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551582, column_id:26, database_name:"", table_name:"t1", synonym_name:"", synonym_db_name:"", column_name:"apcd.ADDEAM", 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, is_unique_key_column:false, is_mul_key_column:false, srs_id:18446744073709551615}}, {consumer_id:67, producer_id:67, producer_branch:0, is_shared_:false, expr:{item_type:"T_REF_QUERY", result_type:{meta:{type:"DECIMAL", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:20, precision:18, scale:2}, flag:0, calc_type:{type:"DECIMAL", collation:"binary", coercibility:"NUMERIC"}}, expr_info:["IS_SUB_QUERY", "CNT_SUB_QUERY"], rel_id:[1, 2], id:1, expr_level:0, expr_levels:[0, 1], output_column:1, is_set:false, is_cursor:false, column_types:[{meta:{type:"DECIMAL", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:20, precision:18, scale:2}, flag:0, calc_type:{type:"DECIMAL", collation:"binary", coercibility:"NUMERIC"}}], enum_set_values:[]}}, {consumer_id:67, producer_id:67, producer_branch:0, is_shared_:false, expr:{item_type:"T_REF_QUERY", result_type:{meta:{type:"DECIMAL", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:20, precision:18, scale:2}, flag:0, calc_type:{type:"DECIMAL", collation:"binary", coercibility:"NUMERIC"}}, expr_info:["IS_SUB_QUERY", "CNT_SUB_QUERY"], rel_id:[1, 2], id:2, expr_level:0, expr_levels:[0, 1], output_column:1, is_set:false, is_cursor:false, column_types:[{meta:{type:"DECIMAL", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:20, precision:18, scale:2}, flag:0, calc_type:{type:"DECIMAL", collation:"binary", coercibility:"NUMERIC"}}], enum_set_values:[]}}, {consumer_id:67, producer_id:67, producer_branch:0, is_shared_:false, expr:{item_type:"T_REF_QUERY", result_type:{meta:{type:"DECIMAL", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:20, precision:18, scale:2}, flag:0, calc_type:{type:"DECIMAL", collation:"binary", coercibility:"NUMERIC"}}, expr_info:["IS_SUB_QUERY", "CNT_SUB_QUERY"], rel_id:[1, 2], id:3, expr_level:0, expr_levels:[0, 1], output_column:1, is_set:false, is_cursor:false, column_types:[{meta:{type:"DECIMAL", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:20, precision:18, scale:2}, flag:0, calc_type:{type:"DECIMAL", collation:"binary", coercibility:"NUMERIC"}}], enum_set_values:[]}}, {consumer_id:67, producer_id:45, producer_branch:0, is_shared_:false, expr:{item_type:"T_FUN_SUM", result_type:{meta:{type:"DECIMAL", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:1, precision:1, scale:0}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_AGG", "CNT_CONST", "CNT_PARAM", "CNT_AGG"], rel_id:[], expr_level:0, expr_levels:[0], children:[{item_type:"T_QUESTIONMARK", result_type:{meta:{type:"BIGINT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:1, precision:1, 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":40}}], distinct:false, order_by:[], separator_param_expr:null, udf_meta:{tenant_id:18446744073709551615, name:"", ret:0, dl:"", type:0}, linear_inter_expr:null, is_nested_aggr:false, pl_agg_udf_expr:null}}, {consumer_id:67, producer_id:15, producer_branch:0, is_shared_:false, expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:30, precision:-1, scale:-1}, flag:1048577, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551582, column_id:21, database_name:"", table_name:"t1", synonym_name:"", synonym_db_name:"", column_name:"billno", 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, is_unique_key_column:false, is_mul_key_column:false, srs_id:18446744073709551584}}, {consumer_id:67, producer_id:15, producer_branch:0, is_shared_:false, expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"CHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:8, precision:-1, scale:-1}, flag:1048577, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551582, column_id:22, database_name:"", table_name:"t1", synonym_name:"", synonym_db_name:"", column_name:"mkdate", 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, is_unique_key_column:false, is_mul_key_column:false, srs_id:18446744073709551584}}, {consumer_id:67, producer_id:15, producer_branch:0, is_shared_:false, expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:16, precision:-1, scale:-1}, flag:1048577, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551582, column_id:23, database_name:"", table_name:"t1", synonym_name:"", synonym_db_name:"", column_name:"mkdept", 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, is_unique_key_column:false, is_mul_key_column:false, srs_id:18446744073709551584}}, {consumer_id:67, producer_id:15, producer_branch:0, is_shared_:false, expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"COERCIBLE"}, accuracy:{length:26, 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:18446744073709551582, column_id:24, database_name:"", table_name:"t1", synonym_name:"", synonym_db_name:"", column_name:"banjdt", 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, is_unique_key_column:false, is_mul_key_column:false, srs_id:18446744073709551615}}, {consumer_id:67, producer_id:18, producer_branch:7, is_shared_:false, expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:100, precision:-1, scale:-1}, flag:1048577, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[3], table_id:18446744073709551580, column_id:21, database_name:"nxyfi", table_name:"pd1", synonym_name:"", synonym_db_name:"", column_name:"DEPTNAME", expr_level:0, expr_levels:[0], column_flags:68719476736, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false, is_unique_key_column:false, is_mul_key_column:false, srs_id:18446744073709551584}}, {consumer_id:67, producer_id:20, producer_branch:8, is_shared_:false, expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:100, precision:-1, scale:-1}, flag:1048577, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[4], table_id:18446744073709551579, column_id:21, database_name:"nxyfi", table_name:"pd2", synonym_name:"", synonym_db_name:"", column_name:"DEPTNAME", expr_level:0, expr_levels:[0], column_flags:68719476736, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false, is_unique_key_column:false, is_mul_key_column:false, srs_id:18446744073709551584}}, {consumer_id:67, producer_id:22, producer_branch:9, is_shared_:false, expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:100, precision:-1, scale:-1}, flag:1048577, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[5], table_id:18446744073709551578, column_id:21, database_name:"nxyfi", table_name:"pd3", synonym_name:"", synonym_db_name:"", column_name:"DEPTNAME", expr_level:0, expr_levels:[0], column_flags:68719476736, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false, is_unique_key_column:false, is_mul_key_column:false, srs_id:18446744073709551584}}, {consumer_id:67, producer_id:24, producer_branch:10, is_shared_:false, expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:100, precision:-1, scale:-1}, flag:1048577, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[6], table_id:18446744073709551577, column_id:21, database_name:"nxyfi", table_name:"pd4", synonym_name:"", synonym_db_name:"", column_name:"DEPTNAME", expr_level:0, expr_levels:[0], column_flags:68719476736, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false, is_unique_key_column:false, is_mul_key_column:false, srs_id:18446744073709551584}}, {consumer_id:67, producer_id:16, producer_branch:6, is_shared_:false, expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:100, precision:-1, scale:-1}, flag:1048577, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[2], table_id:18446744073709551581, column_id:17, database_name:"nxyfi", table_name:"abd", synonym_name:"", synonym_db_name:"", column_name:"TYPENA", expr_level:0, expr_levels:[0], column_flags:68719476736, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false, is_unique_key_column:false, is_mul_key_column:false, srs_id:18446744073709551584}}, {consumer_id:67, producer_id:26, producer_branch:11, is_shared_:false, expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:256, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[7], table_id:18446744073709551576, column_id:17, database_name:"nxyfi", table_name:"app", synonym_name:"", synonym_db_name:"", column_name:"PROJNA", expr_level:0, expr_levels:[0], column_flags:68719476736, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false, is_unique_key_column:false, is_mul_key_column:false, srs_id:18446744073709551584}}, {consumer_id:67, producer_id:28, producer_branch:12, is_shared_:false, expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:200, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[8], table_id:18446744073709551575, column_id:19, database_name:"nxyfi", table_name:"ci", synonym_name:"", synonym_db_name:"", column_name:"ITEMNA", expr_level:0, expr_levels:[0], column_flags:68719476736, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false, is_unique_key_column:false, is_mul_key_column:false, srs_id:18446744073709551584}}, {consumer_id:67, producer_id:30, producer_branch:13, is_shared_:false, expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:100, precision:-1, scale:-1}, flag:1048577, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[9], table_id:18446744073709551574, column_id:17, database_name:"nxyfi", table_name:"bi", synonym_name:"", synonym_db_name:"", column_name:"ISSUNA", expr_level:0, expr_levels:[0], column_flags:68719476736, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false, is_unique_key_column:false, is_mul_key_column:false, srs_id:18446744073709551584}}, {consumer_id:67, producer_id:67, producer_branch:0, is_shared_:false, expr:{item_type:"T_QUESTIONMARK", result_type:{meta:{type:"DATE", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:-1, scale:0}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":49}}}, {consumer_id:67, producer_id:67, producer_branch:0, is_shared_:false, expr:{item_type:"T_OP_CNN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:78, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_FUNC", "CNT_CONST", "CNT_COLUMN", "CNT_PARAM", "CNT_FUNC"], rel_id:[1], expr_levels:[0], func:"concat", children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:20, precision:-1, scale:-1}, flag:1048577, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551582, column_id:16, database_name:"", table_name:"t1", synonym_name:"", synonym_db_name:"", column_name:"deptcd", 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, is_unique_key_column:false, is_mul_key_column:false, srs_id:18446744073709551584}, {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":0}}, {item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:15, precision:-1, scale:-1}, flag:1048577, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551582, column_id:18, database_name:"", table_name:"t1", synonym_name:"", synonym_db_name:"", column_name:"projcd", 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, is_unique_key_column:false, is_mul_key_column:false, srs_id:18446744073709551584}, {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":1}}, {item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:20, precision:-1, scale:-1}, flag:1048577, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551582, column_id:19, database_name:"", table_name:"t1", synonym_name:"", synonym_db_name:"", column_name:"typecd", 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, is_unique_key_column:false, is_mul_key_column:false, srs_id:18446744073709551584}, {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":2}}, {item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:20, precision:-1, scale:-1}, flag:1048577, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551582, column_id:20, database_name:"", table_name:"t1", synonym_name:"", synonym_db_name:"", column_name:"issuno", 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, is_unique_key_column:false, is_mul_key_column:false, srs_id:18446744073709551584}], enum_set_values:[]}}, {consumer_id:67, producer_id:67, producer_branch:0, is_shared_:false, expr:{item_type:"T_OP_CASE", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:20, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["CNT_CONST", "CNT_COLUMN", "CNT_PARAM", "CNT_OR", "CNT_IS_EXPR"], rel_id:[1], expr_levels:[0], arg_case:null, default:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:20, precision:-1, scale:-1}, flag:1048577, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551582, column_id:16, database_name:"", table_name:"t1", synonym_name:"", synonym_db_name:"", column_name:"deptcd", 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, is_unique_key_column:false, is_mul_key_column:false, srs_id:18446744073709551584}, when:[{item_type:"T_OP_OR", 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:["IS_OR", "CNT_CONST", "CNT_COLUMN", "CNT_PARAM", "CNT_OR", "CNT_IS_EXPR"], rel_id:[1], expr_levels:[0], children:[{item_type:"T_OP_EQ", result_type:{meta:{type:"INT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:1, scale:0}, flag:1, calc_type:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}}, expr_info:["CNT_CONST", "CNT_COLUMN", "CNT_PARAM", "IS_SIMPLE_COND"], rel_id:[1], expr_levels:[0], children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:20, precision:-1, scale:-1}, flag:1048577, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551582, column_id:16, database_name:"", table_name:"t1", synonym_name:"", synonym_db_name:"", column_name:"deptcd", 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, is_unique_key_column:false, is_mul_key_column:false, srs_id:18446744073709551584}, {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":3}}]}, {item_type:"T_OP_IS", result_type:{meta:{type:"INT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:1, scale:0}, flag:1, calc_type:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}}, expr_info:["IS_IS_EXPR", "CNT_CONST", "CNT_COLUMN", "CNT_IS_EXPR"], rel_id:[1], expr_levels:[0], children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:20, precision:-1, scale:-1}, flag:1048577, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551582, column_id:16, database_name:"", table_name:"t1", synonym_name:"", synonym_db_name:"", column_name:"deptcd", 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, is_unique_key_column:false, is_mul_key_column:false, srs_id:18446744073709551584}, {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}}]}]}], then:[{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":4}}], decode:false}}, {consumer_id:67, producer_id:67, producer_branch:0, is_shared_:false, expr:{item_type:"T_OP_CASE", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:15, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["CNT_CONST", "CNT_COLUMN", "CNT_PARAM", "CNT_OR", "CNT_IS_EXPR"], rel_id:[1], expr_levels:[0], arg_case:null, default:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:15, precision:-1, scale:-1}, flag:1048577, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551582, column_id:18, database_name:"", table_name:"t1", synonym_name:"", synonym_db_name:"", column_name:"projcd", 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, is_unique_key_column:false, is_mul_key_column:false, srs_id:18446744073709551584}, when:[{item_type:"T_OP_OR", 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:["IS_OR", "CNT_CONST", "CNT_COLUMN", "CNT_PARAM", "CNT_OR", "CNT_IS_EXPR"], rel_id:[1], expr_levels:[0], children:[{item_type:"T_OP_EQ", result_type:{meta:{type:"INT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:1, scale:0}, flag:1, calc_type:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}}, expr_info:["CNT_CONST", "CNT_COLUMN", "CNT_PARAM", "IS_SIMPLE_COND"], rel_id:[1], expr_levels:[0], children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:15, precision:-1, scale:-1}, flag:1048577, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551582, column_id:18, database_name:"", table_name:"t1", synonym_name:"", synonym_db_name:"", column_name:"projcd", 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, is_unique_key_column:false, is_mul_key_column:false, srs_id:18446744073709551584}, {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":5}}]}, {item_type:"T_OP_IS", result_type:{meta:{type:"INT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:1, scale:0}, flag:1, calc_type:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}}, expr_info:["IS_IS_EXPR", "CNT_CONST", "CNT_COLUMN", "CNT_IS_EXPR"], rel_id:[1], expr_levels:[0], children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:15, precision:-1, scale:-1}, flag:1048577, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551582, column_id:18, database_name:"", table_name:"t1", synonym_name:"", synonym_db_name:"", column_name:"projcd", 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, is_unique_key_column:false, is_mul_key_column:false, srs_id:18446744073709551584}, {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}}]}]}], then:[{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":6}}], decode:false}}, {consumer_id:67, producer_id:67, producer_branch:0, is_shared_:false, expr:{item_type:"T_OP_CASE", 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_EXPR", "CNT_CONST", "CNT_PARAM"], rel_id:[], expr_levels:[], arg_case:null, default:{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":37}}, when:[{item_type:"T_QUESTIONMARK", 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:["IS_CONST", "IS_PARAM", "CNT_CONST", "CNT_PARAM"], rel_id:[], value:{"UNKNOWN":70}}], then:[{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":10}}], decode:false}}, {consumer_id:67, producer_id:67, producer_branch:0, is_shared_:false, expr:{item_type:"T_OP_CASE", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:20, precision:-1, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["CNT_CONST", "CNT_COLUMN", "CNT_PARAM", "CNT_OR", "CNT_IS_EXPR"], rel_id:[1], expr_levels:[0], arg_case:null, default:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:20, precision:-1, scale:-1}, flag:1048577, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551582, column_id:20, database_name:"", table_name:"t1", synonym_name:"", synonym_db_name:"", column_name:"issuno", 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, is_unique_key_column:false, is_mul_key_column:false, srs_id:18446744073709551584}, when:[{item_type:"T_OP_OR", 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:["IS_OR", "CNT_CONST", "CNT_COLUMN", "CNT_PARAM", "CNT_OR", "CNT_IS_EXPR"], rel_id:[1], expr_levels:[0], children:[{item_type:"T_OP_EQ", result_type:{meta:{type:"INT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:1, scale:0}, flag:1, calc_type:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}}, expr_info:["CNT_CONST", "CNT_COLUMN", "CNT_PARAM", "IS_SIMPLE_COND"], rel_id:[1], expr_levels:[0], children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:20, precision:-1, scale:-1}, flag:1048577, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551582, column_id:20, database_name:"", table_name:"t1", synonym_name:"", synonym_db_name:"", column_name:"issuno", 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, is_unique_key_column:false, is_mul_key_column:false, srs_id:18446744073709551584}, {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":11}}]}, {item_type:"T_OP_IS", result_type:{meta:{type:"INT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:1, scale:0}, flag:1, calc_type:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}}, expr_info:["IS_IS_EXPR", "CNT_CONST", "CNT_COLUMN", "CNT_IS_EXPR"], rel_id:[1], expr_levels:[0], children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}, accuracy:{length:20, precision:-1, scale:-1}, flag:1048577, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551582, column_id:20, database_name:"", table_name:"t1", synonym_name:"", synonym_db_name:"", column_name:"issuno", 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, is_unique_key_column:false, is_mul_key_column:false, srs_id:18446744073709551584}, {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}}]}]}], then:[{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":12}}], decode:false}}], ret=-4000)
[2024-12-30 10:36:54.738782] WDIAG [SQL.OPT] ob_logical_operator.cpp:2415 [2613054][0][xxxxx-xxxxx-xxxxx-xxxxx] [lt=27] [dc=0][errcode=-4000] failed to perform post traverse action(ret=-4000, operation=0)
[2024-12-30 10:36:54.738789] WDIAG [SQL.OPT] ob_log_plan.cpp:7240 [2613054][0][xxxxx-xxxxx-xxxxx-xxxxx] [lt=5] [dc=0][errcode=-4000] failed to apply operation to operator(operation=0, ret=-4000)
[2024-12-30 10:36:54.738807] WDIAG [SQL.OPT] ob_log_plan.h:1432 [2613054][0][xxxxx-xxxxx-xxxxx-xxxxx] [lt=4] [dc=0][errcode=-4000] failed to do plan traverse(ret=-4000, op=0)