--- title: 存储过程编译报错 4019-OceanBase数据库使用指南 description: 了解OceanBase数据库在实际应用中关于 存储过程编译报错 4019相关的常见问题和使用技巧，帮助您快速解决 存储过程编译报错 4019的难题。 image: https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*OSPzQ6GUQF4AAAAAQHAAAAgAeiGDAQ/original --- 切换语言 - 中文站 - 简体中文 - International - English - 日本站 - 日本語 划线反馈 # 存储过程编译报错 4019 更新时间：2024-01-22 01:56 适用版本： V3.1.x、V3.2.x 内容类型：Troubleshoot 本文介绍存储过程编译报错 4019 的原因和解决方法。 ## 问题描述 在 OceanBase 数据库 V3.2.4 BP3 (oceanbase-3.2.4.3-103000032023041816) 版本下存储过程编译报错 4019，报错日志信息如下。 ```shell WARN [SQL] print (ob_raw_expr_printer.cpp:431) [660866][0][xxxxx-xxxxx-xxxxx-xxxxx] [lt=11] [dc=0] fail to print(ret=-4019) WARN [SQL] print (ob_raw_expr_printer.cpp:155) [660866][0][xxxxx-xxxxx-xxxxx-xxxxx] [lt=16] [dc=0] fail to print expr(ret=-4019) WARN [SQL] do_print (ob_raw_expr_printer.cpp:103) [660866][0][xxxxx-xxxxx-xxxxx-xxxxx] [lt=5] [dc=0] fail to print expr(ret=-4019) WARN [SQL] print_select (ob_select_stmt_printer.cpp:444) [660866][0][xxxxx-xxxxx-xxxxx-xxxxx] [lt=4] [dc=0] fail to print select expr(ret=-4019) WARN [SQL] print_table (ob_dml_stmt_printer.cpp:551) [660866][0][xxxxx-xxxxx-xxxxx-xxxxx] [lt=73] [dc=0] fail to print generated table(ret=-4019) WARN [SQL] print_table (ob_dml_stmt_printer.cpp:481) [660866][0][xxxxx-xxxxx-xxxxx-xxxxx] [lt=8] [dc=0] fail to print right table(ret=-4019, *right_table={table_id:18446744073709551576, table_name:"MFL", alias_name:"MFL", synonym_name:"", synonym_db_name:"", table_type:2, ref_id:18446744073709551615, database_name:"", for_update:false, wait:-1, skip_locked:false, mock_id:18446744073709551615, view_base_item:18446744073709551615, dblink_name:"", link_database_name:""}) WARN [SQL] print_table (ob_dml_stmt_printer.cpp:438) [660866][0][xxxxx-xxxxx-xxxxx-xxxxx] [lt=6] [dc=0] fail to print left table(ret=-4019, *left_table={table_id:18446744073709551582, table_type:3, join_type:"OUTER JOIN", left_table:{table_id:18446744073709551579, table_name:"xxx", alias_name:"xxx", synonym_name:"", synonym_db_name:"", table_type:2, ref_id:18446744073709551615, database_name:"", for_update:false, wait:-1, skip_locked:false, mock_id:18446744073709551615, view_base_item:18446744073709551615, dblink_name:"", link_database_name:""}, right_table:{table_id:18446744073709551576, table_name:"xxx", alias_name:"MFL", synonym_name:"", synonym_db_name:"", table_type:2, ref_id:18446744073709551615, database_name:"", for_update:false, wait:-1, skip_locked:false, mock_id:18446744073709551615, view_base_item:18446744073709551615, dblink_name:"", link_database_name:""}, join_condition:[{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:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}}, expr_info:["CNT_COLUMN", "IS_JOIN_COND"], rel_id:[1, 2], expr_levels:[0], children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}, accuracy:{length:32, precision:2, scale:-1}, flag:3162115, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551579, column_id:16, database_name:"", table_name:"xxx", synonym_name:"", synonym_db_name:"", column_name:"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_REF_COLUMN", result_type:{meta:{type:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}, accuracy:{length:32, precision:2, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[2], table_id:18446744073709551576, column_id:18, database_name:"", table_name:"MFL", synonym_name:"", synonym_db_name:"", column_name:"FLOW_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_OP_EQ", result_type:{meta:{type:"INT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:1, scale:0}, flag:1, calc_type:{type:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}}, expr_info:["CNT_CONST", "CNT_COLUMN", "IS_SIMPLE_COND"], rel_id:[2], expr_levels:[0], children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}, accuracy:{length:2, precision:2, scale:-1}, flag:3145729, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[2], table_id:18446744073709551576, column_id:30, database_name:"", table_name:"MFL", synonym_name:"", synonym_db_name:"", column_name:"DEL_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_CHAR", result_type:{meta:{type:"CHAR", collation:"gbk_bin", coercibility:"COERCIBLE"}, accuracy:{length:1, precision:2, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "CNT_CONST"], rel_id:[], value:{"CHAR":"0", collation:"gbk_bin", coercibility:"COERCIBLE"}}]}]}) WARN [SQL] print_from (ob_dml_stmt_printer.cpp:370) [660866][0][xxxxx-xxxxx-xxxxx-xxxxx] [lt=9] [dc=0] fail to print table(ret=-4019, *table_item={table_id:18446744073709551583, table_type:3, join_type:"OUTER JOIN", left_table:{table_id:18446744073709551582, table_type:3, join_type:"OUTER JOIN", left_table:{table_id:18446744073709551579, table_name:"xxx", alias_name:"xxx", synonym_name:"", synonym_db_name:"", table_type:2, ref_id:18446744073709551615, database_name:"", for_update:false, wait:-1, skip_locked:false, mock_id:18446744073709551615, view_base_item:18446744073709551615, dblink_name:"", link_database_name:""}, right_table:{table_id:18446744073709551576, table_name:"xxx", alias_name:"xxx", synonym_name:"", synonym_db_name:"", table_type:2, ref_id:18446744073709551615, database_name:"", for_update:false, wait:-1, skip_locked:false, mock_id:18446744073709551615, view_base_item:18446744073709551615, dblink_name:"", link_database_name:""}, join_condition:[{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:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}}, expr_info:["CNT_COLUMN", "IS_JOIN_COND"], rel_id:[1, 2], expr_levels:[0], children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}, accuracy:{length:32, precision:2, scale:-1}, flag:3162115, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551579, column_id:16, database_name:"", table_name:"MHF", synonym_name:"", synonym_db_name:"", column_name:"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_REF_COLUMN", result_type:{meta:{type:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}, accuracy:{length:32, precision:2, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[2], table_id:18446744073709551576, column_id:18, database_name:"", table_name:"MFL", synonym_name:"", synonym_db_name:"", column_name:"FLOW_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_OP_EQ", result_type:{meta:{type:"INT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:1, scale:0}, flag:1, calc_type:{type:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}}, expr_info:["CNT_CONST", "CNT_COLUMN", "IS_SIMPLE_COND"], rel_id:[2], expr_levels:[0], children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}, accuracy:{length:2, precision:2, scale:-1}, flag:3145729, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[2], table_id:18446744073709551576, column_id:30, database_name:"", table_name:"MFL", synonym_name:"", synonym_db_name:"", column_name:"DEL_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_CHAR", result_type:{meta:{type:"CHAR", collation:"gbk_bin", coercibility:"COERCIBLE"}, accuracy:{length:1, precision:2, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "CNT_CONST"], rel_id:[], value:{"CHAR":"0", collation:"gbk_bin", coercibility:"COERCIBLE"}}]}]}, right_table:{table_id:18446744073709551575, table_name:"MC_FLOW", alias_name:"M", synonym_name:"", synonym_db_name:"", table_type:1, ref_id:1102810162712091, database_name:"MCMS", for_update:false, wait:-1, skip_locked:false, mock_id:18446744073709551615, view_base_item:18446744073709551615, dblink_name:"", link_database_name:""}, join_condition:[{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:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}}, expr_info:["CNT_COLUMN", "IS_JOIN_COND"], rel_id:[1, 3], expr_levels:[0], children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}, accuracy:{length:32, precision:2, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551579, column_id:18, database_name:"", table_name:"MHF", synonym_name:"", synonym_db_name:"", column_name:"FLOW_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_REF_COLUMN", result_type:{meta:{type:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}, accuracy:{length:32, precision:2, scale:-1}, flag:3162115, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[3], table_id:18446744073709551575, column_id:16, database_name:"MCMS", table_name:"M", synonym_name:"", synonym_db_name:"", column_name:"ID", expr_level:0, expr_levels:[0], column_flags:68719534080, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}]}]}) WARN [SQL] print_table (ob_dml_stmt_printer.cpp:551) [660866][0][xxxxx-xxxxx-xxxxx-xxxxx] [lt=24] [dc=0] fail to print generated table(ret=-4019) WARN [SQL] print_table (ob_dml_stmt_printer.cpp:481) [660866][0][xxxxx-xxxxx-xxxxx-xxxxx] [lt=4] [dc=0] fail to print right table(ret=-4019, *right_table={table_id:18446744073709551574, table_name:"TJSH", alias_name:"TJSH", synonym_name:"", synonym_db_name:"", table_type:2, ref_id:18446744073709551615, database_name:"", for_update:false, wait:-1, skip_locked:false, mock_id:18446744073709551615, view_base_item:18446744073709551615, dblink_name:"", link_database_name:""}) WARN [SQL] print_table (ob_dml_stmt_printer.cpp:438) [660866][0][xxxxx-xxxxx-xxxxx-xxxxx] [lt=3] [dc=0] fail to print left table(ret=-4019, *left_table={table_id:18446744073709551613, table_type:3, join_type:"OUTER JOIN", left_table:{table_id:18446744073709551612, table_type:3, join_type:"OUTER JOIN", left_table:{table_id:18446744073709551611, table_type:3, join_type:"OUTER JOIN", left_table:{table_id:18446744073709551610, table_type:3, join_type:"OUTER JOIN", left_table:{table_id:18446744073709551609, table_type:3, join_type:"OUTER JOIN", left_table:{table_id:18446744073709551608, table_type:3, join_type:"OUTER JOIN", left_table:{table_id:18446744073709551607, table_name:"MC_FLOW", alias_name:"M", synonym_name:"", synonym_db_name:"", table_type:1, ref_id:1102810162712091, database_name:"MCMS", for_update:false, wait:-1, skip_locked:false, mock_id:18446744073709551615, view_base_item:18446744073709551615, dblink_name:"", link_database_name:""}, right_table:{table_id:18446744073709551606, table_name:"MC_CLAIM", alias_name:"C", synonym_name:"", synonym_db_name:"", table_type:1, ref_id:1102810162712079, database_name:"MCMS", for_update:false, wait:-1, skip_locked:false, mock_id:18446744073709551615, view_base_item:18446744073709551615, dblink_name:"", link_database_name:""}, join_condition:[{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:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}}, expr_info:["CNT_COLUMN", "IS_JOIN_COND"], rel_id:[1, 2], expr_levels:[0], children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}, accuracy:{length:32, precision:2, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551607, column_id:17, database_name:"MCMS", table_name:"M", synonym_name:"", synonym_db_name:"", column_name:"CLAIM_ID", 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}, {item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}, accuracy:{length:32, precision:2, scale:-1}, flag:3162115, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[2], table_id:18446744073709551606, column_id:16, database_name:"MCMS", table_name:"C", synonym_name:"", synonym_db_name:"", column_name:"ID", expr_level:0, expr_levels:[0], column_flags:68719534080, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}]}]}, right_table:{table_id:18446744073709551605, table_name:"MC_SURVEY", alias_name:"S", synonym_name:"", synonym_db_name:"", table_type:1, ref_id:1102810162712110, database_name:"MCMS", for_update:false, wait:-1, skip_locked:false, mock_id:18446744073709551615, view_base_item:18446744073709551615, dblink_name:"", link_database_name:""}, join_condition:[{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:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}}, expr_info:["CNT_COLUMN", "IS_JOIN_COND"], rel_id:[1, 3], expr_levels:[0], children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}, accuracy:{length:32, precision:2, scale:-1}, flag:3162115, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551607, column_id:16, database_name:"MCMS", table_name:"M", synonym_name:"", synonym_db_name:"", column_name:"ID", expr_level:0, expr_levels:[0], column_flags:68719534080, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}, {item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}, accuracy:{length:32, precision:2, scale:-1}, flag:3145729, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[3], table_id:18446744073709551605, column_id:18, database_name:"MCMS", table_name:"S", synonym_name:"", synonym_db_name:"", column_name:"FLOW_ID", expr_level:0, expr_levels:[0], column_flags:68719534080, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}]}, {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:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}}, expr_info:["CNT_CONST", "CNT_COLUMN", "IS_SIMPLE_COND"], rel_id:[3], expr_levels:[0], children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}, accuracy:{length:2, precision:2, scale:-1}, flag:3145729, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[3], table_id:18446744073709551605, column_id:30, database_name:"MCMS", table_name:"S", synonym_name:"", synonym_db_name:"", column_name:"DEL_FLAG", expr_level:0, expr_levels:[0], column_flags:68719534080, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}, {item_type:"T_CHAR", result_type:{meta:{type:"CHAR", collation:"gbk_bin", coercibility:"COERCIBLE"}, accuracy:{length:1, precision:2, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "CNT_CONST"], rel_id:[], value:{"CHAR":"0", collation:"gbk_bin", coercibility:"COERCIBLE"}}]}]}, right_table:{table_id:18446744073709551604, table_name:"MC_INJURE", alias_name:"MI", synonym_name:"", synonym_db_name:"", table_type:1, ref_id:1102810162712083, database_name:"MCMS", for_update:false, wait:-1, skip_locked:false, mock_id:18446744073709551615, view_base_item:18446744073709551615, dblink_name:"", link_database_name:""}, join_condition:[{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:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}}, expr_info:["CNT_COLUMN", "IS_JOIN_COND"], rel_id:[1, 4], expr_levels:[0], children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}, accuracy:{length:32, precision:2, scale:-1}, flag:3162115, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[4], table_id:18446744073709551604, column_id:16, database_name:"MCMS", table_name:"MI", synonym_name:"", synonym_db_name:"", column_name:"ID", expr_level:0, expr_levels:[0], column_flags:68719534080, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}, {item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}, accuracy:{length:32, precision:2, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551607, column_id:48, database_name:"MCMS", table_name:"M", synonym_name:"", synonym_db_name:"", column_name:"INJURE_ID", 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}]}, {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:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}}, expr_info:["CNT_CONST", "CNT_COLUMN", "IS_SIMPLE_COND"], rel_id:[4], expr_levels:[0], children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}, accuracy:{length:2, precision:2, scale:-1}, flag:3145729, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[4], table_id:18446744073709551604, column_id:51, database_name:"MCMS", table_name:"MI", synonym_name:"", synonym_db_name:"", column_name:"DEL_FLAG", expr_level:0, expr_levels:[0], column_flags:68719534080, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}, {item_type:"T_CHAR", result_type:{meta:{type:"CHAR", collation:"gbk_bin", coercibility:"COERCIBLE"}, accuracy:{length:1, precision:2, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "CNT_CONST"], rel_id:[], value:{"CHAR":"0", collation:"gbk_bin", coercibility:"COERCIBLE"}}]}]}, right_table:{table_id:18446744073709551594, table_name:"GZ", alias_name:"GZ", synonym_name:"", synonym_db_name:"", table_type:2, ref_id:18446744073709551615, database_name:"", for_update:false, wait:-1, skip_locked:false, mock_id:18446744073709551615, view_base_item:18446744073709551615, dblink_name:"", link_database_name:""}, join_condition:[{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:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}}, expr_info:["CNT_COLUMN", "IS_JOIN_COND"], rel_id:[1, 5], expr_levels:[0], children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}, accuracy:{length:32, precision:2, scale:-1}, flag:3162115, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551607, column_id:16, database_name:"MCMS", table_name:"M", synonym_name:"", synonym_db_name:"", column_name:"ID", expr_level:0, expr_levels:[0], column_flags:68719534080, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}, {item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}, accuracy:{length:32, precision:2, scale:-1}, flag:3145728, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[5], table_id:18446744073709551594, column_id:16, database_name:"", table_name:"GZ", synonym_name:"", synonym_db_name:"", column_name:"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}]}]}, right_table:{table_id:18446744073709551584, table_name:"TJ", alias_name:"TJ", synonym_name:"", synonym_db_name:"", table_type:2, ref_id:18446744073709551615, database_name:"", for_update:false, wait:-1, skip_locked:false, mock_id:18446744073709551615, view_base_item:18446744073709551615, dblink_name:"", link_database_name:""}, join_condition:[{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:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}}, expr_info:["CNT_COLUMN", "IS_JOIN_COND"], rel_id:[1, 6], expr_levels:[0], children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}, accuracy:{length:32, precision:2, scale:-1}, flag:3162115, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551607, column_id:16, database_name:"MCMS", table_name:"M", synonym_name:"", synonym_db_name:"", column_name:"ID", expr_level:0, expr_levels:[0], column_flags:68719534080, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}, {item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}, accuracy:{length:32, precision:2, scale:-1}, flag:3145728, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[6], table_id:18446744073709551584, column_id:16, database_name:"", table_name:"TJ", synonym_name:"", synonym_db_name:"", column_name:"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}]}]}, right_table:{table_id:18446744073709551574, table_name:"TJSH", alias_name:"TJSH", synonym_name:"", synonym_db_name:"", table_type:2, ref_id:18446744073709551615, database_name:"", for_update:false, wait:-1, skip_locked:false, mock_id:18446744073709551615, view_base_item:18446744073709551615, dblink_name:"", link_database_name:""}, join_condition:[{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:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}}, expr_info:["CNT_COLUMN", "IS_JOIN_COND"], rel_id:[1, 7], expr_levels:[0], children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}, accuracy:{length:32, precision:2, scale:-1}, flag:3162115, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551607, column_id:16, database_name:"MCMS", table_name:"M", synonym_name:"", synonym_db_name:"", column_name:"ID", expr_level:0, expr_levels:[0], column_flags:68719534080, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}, {item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}, accuracy:{length:32, precision:2, scale:-1}, flag:3145728, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[7], table_id:18446744073709551574, column_id:16, database_name:"", table_name:"TJSH", synonym_name:"", synonym_db_name:"", column_name:"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}]}]}) WARN [SQL] print_from (ob_dml_stmt_printer.cpp:370) [660866][0][xxxxx-xxxxx-xxxxx-xxxxx] [lt=11] [dc=0] fail to print table(ret=-4019, *table_item={table_id:18446744073709551614, table_type:3, join_type:"OUTER JOIN", left_table:{table_id:18446744073709551613, table_type:3, join_type:"OUTER JOIN", left_table:{table_id:18446744073709551612, table_type:3, join_type:"OUTER JOIN", left_table:{table_id:18446744073709551611, table_type:3, join_type:"OUTER JOIN", left_table:{table_id:18446744073709551610, table_type:3, join_type:"OUTER JOIN", left_table:{table_id:18446744073709551609, table_type:3, join_type:"OUTER JOIN", left_table:{table_id:18446744073709551608, table_type:3, join_type:"OUTER JOIN", left_table:{table_id:18446744073709551607, table_name:"MC_FLOW", alias_name:"M", synonym_name:"", synonym_db_name:"", table_type:1, ref_id:1102810162712091, database_name:"MCMS", for_update:false, wait:-1, skip_locked:false, mock_id:18446744073709551615, view_base_item:18446744073709551615, dblink_name:"", link_database_name:""}, right_table:{table_id:18446744073709551606, table_name:"MC_CLAIM", alias_name:"C", synonym_name:"", synonym_db_name:"", table_type:1, ref_id:1102810162712079, database_name:"MCMS", for_update:false, wait:-1, skip_locked:false, mock_id:18446744073709551615, view_base_item:18446744073709551615, dblink_name:"", link_database_name:""}, join_condition:[{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:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}}, expr_info:["CNT_COLUMN", "IS_JOIN_COND"], rel_id:[1, 2], expr_levels:[0], children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}, accuracy:{length:32, precision:2, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551607, column_id:17, database_name:"MCMS", table_name:"M", synonym_name:"", synonym_db_name:"", column_name:"CLAIM_ID", 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}, {item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}, accuracy:{length:32, precision:2, scale:-1}, flag:3162115, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[2], table_id:18446744073709551606, column_id:16, database_name:"MCMS", table_name:"C", synonym_name:"", synonym_db_name:"", column_name:"ID", expr_level:0, expr_levels:[0], column_flags:68719534080, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}]}]}, right_table:{table_id:18446744073709551605, table_name:"MC_SURVEY", alias_name:"S", synonym_name:"", synonym_db_name:"", table_type:1, ref_id:1102810162712110, database_name:"MCMS", for_update:false, wait:-1, skip_locked:false, mock_id:18446744073709551615, view_base_item:18446744073709551615, dblink_name:"", link_database_name:""}, join_condition:[{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:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}}, expr_info:["CNT_COLUMN", "IS_JOIN_COND"], rel_id:[1, 3], expr_levels:[0], children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}, accuracy:{length:32, precision:2, scale:-1}, flag:3162115, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551607, column_id:16, database_name:"MCMS", table_name:"M", synonym_name:"", synonym_db_name:"", column_name:"ID", expr_level:0, expr_levels:[0], column_flags:68719534080, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}, {item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}, accuracy:{length:32, precision:2, scale:-1}, flag:3145729, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[3], table_id:18446744073709551605, column_id:18, database_name:"MCMS", table_name:"S", synonym_name:"", synonym_db_name:"", column_name:"FLOW_ID", expr_level:0, expr_levels:[0], column_flags:68719534080, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}]}, {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:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}}, expr_info:["CNT_CONST", "CNT_COLUMN", "IS_SIMPLE_COND"], rel_id:[3], expr_levels:[0], children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}, accuracy:{length:2, precision:2, scale:-1}, flag:3145729, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[3], table_id:18446744073709551605, column_id:30, database_name:"MCMS", table_name:"S", synonym_name:"", synonym_db_name:"", column_name:"DEL_FLAG", expr_level:0, expr_levels:[0], column_flags:68719534080, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}, {item_type:"T_CHAR", result_type:{meta:{type:"CHAR", collation:"gbk_bin", coercibility:"COERCIBLE"}, accuracy:{length:1, precision:2, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "CNT_CONST"], rel_id:[], value:{"CHAR":"0", collation:"gbk_bin", coercibility:"COERCIBLE"}}]}]}, right_table:{table_id:18446744073709551604, table_name:"MC_INJURE", alias_name:"MI", synonym_name:"", synonym_db_name:"", table_type:1, ref_id:1102810162712083, database_name:"MCMS", for_update:false, wait:-1, skip_locked:false, mock_id:18446744073709551615, view_base_item:18446744073709551615, dblink_name:"", link_database_name:""}, join_condition:[{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:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}}, expr_info:["CNT_COLUMN", "IS_JOIN_COND"], rel_id:[1, 4], expr_levels:[0], children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}, accuracy:{length:32, precision:2, scale:-1}, flag:3162115, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[4], table_id:18446744073709551604, column_id:16, database_name:"MCMS", table_name:"MI", synonym_name:"", synonym_db_name:"", column_name:"ID", expr_level:0, expr_levels:[0], column_flags:68719534080, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}, {item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}, accuracy:{length:32, precision:2, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551607, column_id:48, database_name:"MCMS", table_name:"M", synonym_name:"", synonym_db_name:"", column_name:"INJURE_ID", 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}]}, {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:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}}, expr_info:["CNT_CONST", "CNT_COLUMN", "IS_SIMPLE_COND"], rel_id:[4], expr_levels:[0], children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}, accuracy:{length:2, precision:2, scale:-1}, flag:3145729, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[4], table_id:18446744073709551604, column_id:51, database_name:"MCMS", table_name:"MI", synonym_name:"", synonym_db_name:"", column_name:"DEL_FLAG", expr_level:0, expr_levels:[0], column_flags:68719534080, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}, {item_type:"T_CHAR", result_type:{meta:{type:"CHAR", collation:"gbk_bin", coercibility:"COERCIBLE"}, accuracy:{length:1, precision:2, scale:-1}, flag:1, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST", "CNT_CONST"], rel_id:[], value:{"CHAR":"0", collation:"gbk_bin", coercibility:"COERCIBLE"}}]}]}, right_table:{table_id:18446744073709551594, table_name:"xxx", alias_name:"xxx", synonym_name:"", synonym_db_name:"", table_type:2, ref_id:18446744073709551615, database_name:"", for_update:false, wait:-1, skip_locked:false, mock_id:18446744073709551615, view_base_item:18446744073709551615, dblink_name:"", link_database_name:""}, join_condition:[{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:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}}, expr_info:["CNT_COLUMN", "IS_JOIN_COND"], rel_id:[1, 5], expr_levels:[0], children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}, accuracy:{length:32, precision:2, scale:-1}, flag:3162115, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551607, column_id:16, database_name:"xxx", table_name:"xxx", synonym_name:"", synonym_db_name:"", column_name:"ID", expr_level:0, expr_levels:[0], column_flags:68719534080, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}, {item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}, accuracy:{length:32, precision:2, scale:-1}, flag:3145728, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[5], table_id:18446744073709551594, column_id:16, database_name:"", table_name:"GZ", synonym_name:"", synonym_db_name:"", column_name:"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}]}]}, right_table:{table_id:18446744073709551584, table_name:"TJ", alias_name:"TJ", synonym_name:"", synonym_db_name:"", table_type:2, ref_id:18446744073709551615, database_name:"", for_update:false, wait:-1, skip_locked:false, mock_id:18446744073709551615, view_base_item:18446744073709551615, dblink_name:"", link_database_name:""}, join_condition:[{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:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}}, expr_info:["CNT_COLUMN", "IS_JOIN_COND"], rel_id:[1, 6], expr_levels:[0], children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}, accuracy:{length:32, precision:2, scale:-1}, flag:3162115, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551607, column_id:16, database_name:"xxx", table_name:"xxx", synonym_name:"", synonym_db_name:"", column_name:"ID", expr_level:0, expr_levels:[0], column_flags:6x8719534080, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}, {item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}, accuracy:{length:32, precision:2, scale:-1}, flag:3145728, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[6], table_id:18446744073709551584, column_id:16, database_name:"", table_name:"TJ", synonym_name:"", synonym_db_name:"", column_name:"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}]}]}, right_table:{table_id:18446744073709551574, table_name:"TJSH", alias_name:"xxx", synonym_name:"", synonym_db_name:"", table_type:2, ref_id:18446744073709551615, database_name:"", for_update:false, wait:-1, skip_locked:false, mock_id:18446744073709551615, view_base_item:18446744073709551615, dblink_name:"", link_database_name:""}, join_condition:[{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:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}}, expr_info:["CNT_COLUMN", "IS_JOIN_COND"], rel_id:[1, 7], expr_levels:[0], children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}, accuracy:{length:32, precision:2, scale:-1}, flag:3162115, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551607, column_id:16, database_name:"xxx", table_name:"xxx", synonym_name:"", synonym_db_name:"", column_name:"ID", expr_level:0, expr_levels:[0], column_flags:68719534080, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}, {item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}, accuracy:{length:32, precision:2, scale:-1}, flag:3145728, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[7], table_id:18446744073709551574, column_id:16, database_name:"", table_name:"xxx", synonym_name:"", synonym_db_name:"", column_name:"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}]}]}, right_table:{table_id:18446744073709551564, table_name:"FYSH", alias_name:"xxx", synonym_name:"", synonym_db_name:"", table_type:2, ref_id:18446744073709551615, database_name:"", for_update:false, wait:-1, skip_locked:false, mock_id:18446744073709551615, view_base_item:18446744073709551615, dblink_name:"", link_database_name:""}, join_condition:[{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:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}}, expr_info:["CNT_COLUMN", "IS_JOIN_COND"], rel_id:[1, 8], expr_levels:[0], children:[{item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}, accuracy:{length:32, precision:2, scale:-1}, flag:3162115, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[1], table_id:18446744073709551607, column_id:16, database_name:"xxx", table_name:"xxx", synonym_name:"", synonym_db_name:"", column_name:"ID", expr_level:0, expr_levels:[0], column_flags:68719534080, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false}, {item_type:"T_REF_COLUMN", result_type:{meta:{type:"VARCHAR2", collation:"gbk_bin", coercibility:"IMPLICIT"}, accuracy:{length:32, precision:2, scale:-1}, flag:3145728, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[8], table_id:18446744073709551564, column_id:16, database_name:"", table_name:"xxx", synonym_name:"", synonym_db_name:"", column_name:"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}]}]}) WARN [SQL] do_print (ob_insert_stmt_printer.cpp:59) [660866][0][xxxxx-xxxxx-xxxxx-xxxxx] [lt=29] [dc=0] fail to print stmt(ret=-4019) ``` ## 适用版本 OceanBase 数据库 V3.x 版本。 ## 问题原因 动态 SQL 反拼超过 Buffer 大小。OceanBase 数据库 V3.2.4 BP3 版本中 Buffer 大小为定长 64k。 ## 解决方法 升级至问题已修复版本。 目前已修复的版本包括 OceanBase 数据库企业版 V3.2.3 BP6 (oceanbase-3.2.3.3-106000102022111521) 及之后版本、V3.2.4 BP4 (oceanbase-3.2.4.4-104000052023062021) 及之后版本。 上一篇 [OceanBase 数据库执行 PL 时，PL 内的 SQL 语句报错 -4003:Array index out of range](https://www.oceanbase.com/knowledge-base/oceanbase-database-1000000002396428) 下一篇 [DB2 和 OceanBase 数据库使用游标方式获取数据的代码交互过程差异](https://www.oceanbase.com/knowledge-base/oceanbase-database-1000000000210007) ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线