*************** Case 1 *************** select c1, sum(c2) from t1 where c1 > 0 and c2 + c1 = 100 group by c2 order by c1 desc limit 0, 1 { "stmt_type":1, "table": [ { "table_id":1, "table_name":"t1", "alias_name":"", "table_type":0, "ref_id":1, "ref_query":null } ], "joined_table": [ ], "partition_express": [ { "table_id":1, "expression": { "item_type":"T_FUN_SYS_PART_HASH", "result_type":"", "expr_info": [ "IS_FUNC", "CNT_CONST", "CNT_COLUMN", "CNT_FUNC" ], "rel_id": [ 1 ], "func":"partition_hash", "children": [ { "item_type":"T_OP_ADD", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } } ] } ] } } ], "column": [ { "column_id":17, "column_name":"c2", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 } }, { "column_id":16, "column_name":"c1", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 } } ], "select": [ { "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 }, "table_id":-1, "column_id":65519, "is_alias":false, "alias_name":"c1", "expr_name":"c1", "obj_type":"BIGINT", "decimal_scale":0 }, { "expression": { "item_type":"T_FUN_SUM", "result_type":"", "expr_info": [ "IS_AGG", "CNT_COLUMN", "CNT_AGG" ], "rel_id": [ 1 ], "children": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, "distinct":false }, "table_id":-1, "column_id":65508, "is_alias":false, "alias_name":"", "expr_name":"sum(c2)", "obj_type":"", "decimal_scale":9223372036854775807 } ], "distinct":false, "from": [ { "table_id":1, "is_join":false } ], "where": [ { "item_type":"T_OP_GT", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN", "IS_RANGE_COND" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":0 } } ] }, { "item_type":"T_OP_EQ", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_OP_ADD", "result_type":"", "expr_info": [ "CNT_COLUMN" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 } ] }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":100 } } ] } ], "group_by": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 } ], "having": [ ], "aggr_func": [ { "column_id":65518, "expression": { "item_type":"T_FUN_SUM", "result_type":"", "expr_info": [ "IS_AGG", "CNT_COLUMN", "CNT_AGG" ], "rel_id": [ 1 ], "children": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, "distinct":false } } ], "order_by": [ { "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 }, "ascending":"DESC" } ], "limit": { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } }, "offset": { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":0 } }, "for_update":false, "wait":-1, "when": [ ], "hint": { "read_static":false, "frozen_version":-1, "topk_precision":-1, "sharding_minimum_row_count":0, "query_timeout":-1, "hotspot":false, "index": [ ], "read_consistency":0, "join_order": [ ], "merge_hint": [ ], "merge_hint_idxs":"0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000", "hash_hint": [ ], "hash_hint_idxs":"0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000", "nl_hint": [ ], "nl_hint_idxs":"0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000" }, "equal_sets": [ [ { "item_type":"T_OP_ADD", "result_type":"", "expr_info": [ "CNT_COLUMN" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 } ] }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":100 } } ] ] } *************** Case 2 *************** select t1.c1, sum(t1.c2) from rongxuan.t1 where t1.c1 > 0 and t1.c2 + t1.c1 = 100 group by c2 order by t1.c1 desc limit 0, 1; { "stmt_type":1, "table": [ { "table_id":1, "table_name":"t1", "alias_name":"", "table_type":0, "ref_id":1, "ref_query":null } ], "joined_table": [ ], "partition_express": [ { "table_id":1, "expression": { "item_type":"T_FUN_SYS_PART_HASH", "result_type":"", "expr_info": [ "IS_FUNC", "CNT_CONST", "CNT_COLUMN", "CNT_FUNC" ], "rel_id": [ 1 ], "func":"partition_hash", "children": [ { "item_type":"T_OP_ADD", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } } ] } ] } } ], "column": [ { "column_id":17, "column_name":"c2", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 } }, { "column_id":16, "column_name":"c1", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 } } ], "select": [ { "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 }, "table_id":-1, "column_id":65519, "is_alias":false, "alias_name":"c1", "expr_name":"c1", "obj_type":"BIGINT", "decimal_scale":0 }, { "expression": { "item_type":"T_FUN_SUM", "result_type":"", "expr_info": [ "IS_AGG", "CNT_COLUMN", "CNT_AGG" ], "rel_id": [ 1 ], "children": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, "distinct":false }, "table_id":-1, "column_id":65508, "is_alias":false, "alias_name":"", "expr_name":"sum(t1.c2)", "obj_type":"", "decimal_scale":9223372036854775807 } ], "distinct":false, "from": [ { "table_id":1, "is_join":false } ], "where": [ { "item_type":"T_OP_GT", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN", "IS_RANGE_COND" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":0 } } ] }, { "item_type":"T_OP_EQ", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_OP_ADD", "result_type":"", "expr_info": [ "CNT_COLUMN" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 } ] }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":100 } } ] } ], "group_by": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 } ], "having": [ ], "aggr_func": [ { "column_id":65518, "expression": { "item_type":"T_FUN_SUM", "result_type":"", "expr_info": [ "IS_AGG", "CNT_COLUMN", "CNT_AGG" ], "rel_id": [ 1 ], "children": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, "distinct":false } } ], "order_by": [ { "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 }, "ascending":"DESC" } ], "limit": { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } }, "offset": { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":0 } }, "for_update":false, "wait":-1, "when": [ ], "hint": { "read_static":false, "frozen_version":-1, "topk_precision":-1, "sharding_minimum_row_count":0, "query_timeout":-1, "hotspot":false, "index": [ ], "read_consistency":0, "join_order": [ ], "merge_hint": [ ], "merge_hint_idxs":"0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000", "hash_hint": [ ], "hash_hint_idxs":"0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000", "nl_hint": [ ], "nl_hint_idxs":"0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000" }, "equal_sets": [ [ { "item_type":"T_OP_ADD", "result_type":"", "expr_info": [ "CNT_COLUMN" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 } ] }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":100 } } ] ] } *************** Case 3 *************** select rongxuan.t1.c1, sum(rongxuan.t1.c2) from rongxuan.t1 where rongxuan.t1.c1 > 0 and rongxuan.t1.c2 + rongxuan.t1.c1 = 100 group by rongxuan.t1.c2 order by rongxuan.t1.c1 desc limit 0, 1; { "stmt_type":1, "table": [ { "table_id":1, "table_name":"t1", "alias_name":"", "table_type":0, "ref_id":1, "ref_query":null } ], "joined_table": [ ], "partition_express": [ { "table_id":1, "expression": { "item_type":"T_FUN_SYS_PART_HASH", "result_type":"", "expr_info": [ "IS_FUNC", "CNT_CONST", "CNT_COLUMN", "CNT_FUNC" ], "rel_id": [ 1 ], "func":"partition_hash", "children": [ { "item_type":"T_OP_ADD", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } } ] } ] } } ], "column": [ { "column_id":17, "column_name":"c2", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 } }, { "column_id":16, "column_name":"c1", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 } } ], "select": [ { "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 }, "table_id":-1, "column_id":65519, "is_alias":false, "alias_name":"c1", "expr_name":"c1", "obj_type":"BIGINT", "decimal_scale":0 }, { "expression": { "item_type":"T_FUN_SUM", "result_type":"", "expr_info": [ "IS_AGG", "CNT_COLUMN", "CNT_AGG" ], "rel_id": [ 1 ], "children": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, "distinct":false }, "table_id":-1, "column_id":65508, "is_alias":false, "alias_name":"", "expr_name":"sum(rongxuan.t1.c2)", "obj_type":"", "decimal_scale":9223372036854775807 } ], "distinct":false, "from": [ { "table_id":1, "is_join":false } ], "where": [ { "item_type":"T_OP_GT", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN", "IS_RANGE_COND" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":0 } } ] }, { "item_type":"T_OP_EQ", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_OP_ADD", "result_type":"", "expr_info": [ "CNT_COLUMN" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 } ] }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":100 } } ] } ], "group_by": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 } ], "having": [ ], "aggr_func": [ { "column_id":65518, "expression": { "item_type":"T_FUN_SUM", "result_type":"", "expr_info": [ "IS_AGG", "CNT_COLUMN", "CNT_AGG" ], "rel_id": [ 1 ], "children": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, "distinct":false } } ], "order_by": [ { "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 }, "ascending":"DESC" } ], "limit": { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } }, "offset": { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":0 } }, "for_update":false, "wait":-1, "when": [ ], "hint": { "read_static":false, "frozen_version":-1, "topk_precision":-1, "sharding_minimum_row_count":0, "query_timeout":-1, "hotspot":false, "index": [ ], "read_consistency":0, "join_order": [ ], "merge_hint": [ ], "merge_hint_idxs":"0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000", "hash_hint": [ ], "hash_hint_idxs":"0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000", "nl_hint": [ ], "nl_hint_idxs":"0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000" }, "equal_sets": [ [ { "item_type":"T_OP_ADD", "result_type":"", "expr_info": [ "CNT_COLUMN" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 } ] }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":100 } } ] ] } *************** Case 4 *************** insert into t1 values(1, 2) { "stmt_type":2, "table": [ { "table_id":1, "table_name":"t1", "alias_name":"", "table_type":0, "ref_id":1, "ref_query":null } ], "partition_express": [ { "table_id":1, "expression": { "item_type":"T_FUN_SYS_PART_HASH", "result_type":"", "expr_info": [ "IS_FUNC", "CNT_CONST", "CNT_COLUMN", "CNT_FUNC" ], "rel_id": [ 1 ], "func":"partition_hash", "children": [ { "item_type":"T_OP_ADD", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } } ] } ] } } ], "column": [ { "column_id":16, "column_name":"c1", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":0, "cs_level":7, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 } }, { "column_id":17, "column_name":"c2", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 } } ], "value": [ [ { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":2 } } ] ], "on_duplicate": [ ] } *************** Case 5 *************** insert into rongxuan.t1 values(1, 2) { "stmt_type":2, "table": [ { "table_id":1, "table_name":"t1", "alias_name":"", "table_type":0, "ref_id":1, "ref_query":null } ], "partition_express": [ { "table_id":1, "expression": { "item_type":"T_FUN_SYS_PART_HASH", "result_type":"", "expr_info": [ "IS_FUNC", "CNT_CONST", "CNT_COLUMN", "CNT_FUNC" ], "rel_id": [ 1 ], "func":"partition_hash", "children": [ { "item_type":"T_OP_ADD", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } } ] } ] } } ], "column": [ { "column_id":16, "column_name":"c1", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":0, "cs_level":7, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 } }, { "column_id":17, "column_name":"c2", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 } } ], "value": [ [ { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":2 } } ] ], "on_duplicate": [ ] } *************** Case 6 *************** insert into t1(c1) values(1), (2) { "stmt_type":2, "table": [ { "table_id":1, "table_name":"t1", "alias_name":"", "table_type":0, "ref_id":1, "ref_query":null } ], "partition_express": [ { "table_id":1, "expression": { "item_type":"T_FUN_SYS_PART_HASH", "result_type":"", "expr_info": [ "IS_FUNC", "CNT_CONST", "CNT_COLUMN", "CNT_FUNC" ], "rel_id": [ 1 ], "func":"partition_hash", "children": [ { "item_type":"T_OP_ADD", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } } ] } ] } } ], "column": [ { "column_id":16, "column_name":"c1", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 } }, { "column_id":17, "column_name":"c2", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 } } ], "value": [ [ { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } }, { "item_type":"T_NULL", "result_type":"NULL", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "NULL":"NULL" } } ], [ { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":2 } }, { "item_type":"T_NULL", "result_type":"NULL", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "NULL":"NULL" } } ] ], "on_duplicate": [ ] } *************** Case 7 *************** insert into rongxuan.t1(rongxuan.t1.c1) values(5), (6) { "stmt_type":2, "table": [ { "table_id":1, "table_name":"t1", "alias_name":"", "table_type":0, "ref_id":1, "ref_query":null } ], "partition_express": [ { "table_id":1, "expression": { "item_type":"T_FUN_SYS_PART_HASH", "result_type":"", "expr_info": [ "IS_FUNC", "CNT_CONST", "CNT_COLUMN", "CNT_FUNC" ], "rel_id": [ 1 ], "func":"partition_hash", "children": [ { "item_type":"T_OP_ADD", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } } ] } ] } } ], "column": [ { "column_id":16, "column_name":"c1", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 } }, { "column_id":17, "column_name":"c2", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 } } ], "value": [ [ { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":5 } }, { "item_type":"T_NULL", "result_type":"NULL", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "NULL":"NULL" } } ], [ { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":6 } }, { "item_type":"T_NULL", "result_type":"NULL", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "NULL":"NULL" } } ] ], "on_duplicate": [ ] } *************** Case 8 *************** update rongxuan.t1 vt1 set c2=c1+1 where c1 > 1 order by c1 desc { "stmt_type":5, "table": [ { "table_id":1, "table_name":"t1", "alias_name":"vt1", "table_type":1, "ref_id":1, "ref_query":null } ], "partition_express": [ { "table_id":1, "expression": { "item_type":"T_FUN_SYS_PART_HASH", "result_type":"", "expr_info": [ "IS_FUNC", "CNT_CONST", "CNT_COLUMN", "CNT_FUNC" ], "rel_id": [ 1 ], "func":"partition_hash", "children": [ { "item_type":"T_OP_ADD", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } } ] } ] } } ], "column": [ { "column_id":17, "column_name":"c2", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 } }, { "column_id":16, "column_name":"c1", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 } } ], "input_columns": [ { "table_id":1, "table_name":"t1", "column": [ { "column_id":16, "column_name":"c1", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 } }, { "column_id":17, "column_name":"c2", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 } } ] } ], "assign": [ { "table": { "table_id":1, "table_name":"t1", "alias_name":"vt1", "table_type":1, "ref_id":1, "ref_query":null }, "assign": [ { "column": { "column_id":17, "column_name":"c2", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 } }, "expression": { "item_type":"T_OP_ADD", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } } ] } } ] } ], "where": [ { "item_type":"T_OP_GT", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN", "IS_RANGE_COND" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } } ] } ], "order_by": [ { "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 }, "ascending":"DESC" } ], "limit":null, "offset":null, "when": [ ] } *************** Case 9 *************** delete from t1 where c2 > 10 order by c1 limit 1 { "stmt_type":4, "table_id":1, "table": [ { "table_id":1, "table_name":"t1", "alias_name":"", "table_type":0, "ref_id":1, "ref_query":null } ], "partition_express": [ { "table_id":1, "expression": { "item_type":"T_FUN_SYS_PART_HASH", "result_type":"", "expr_info": [ "IS_FUNC", "CNT_CONST", "CNT_COLUMN", "CNT_FUNC" ], "rel_id": [ 1 ], "func":"partition_hash", "children": [ { "item_type":"T_OP_ADD", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } } ] } ] } } ], "column": [ { "column_id":17, "column_name":"c2", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 } }, { "column_id":16, "column_name":"c1", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 } } ], "where": [ { "item_type":"T_OP_GT", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN", "IS_RANGE_COND" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":10 } } ] } ], "order_by": [ { "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 }, "ascending":"ASC" } ], "limit": { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } }, "offset":null, "when": [ ] } *************** Case 10 *************** delete from rongxuan.t1 where rongxuan.t1.c2 > 10 order by t1.c1 limit 1; { "stmt_type":4, "table_id":1, "table": [ { "table_id":1, "table_name":"t1", "alias_name":"", "table_type":0, "ref_id":1, "ref_query":null } ], "partition_express": [ { "table_id":1, "expression": { "item_type":"T_FUN_SYS_PART_HASH", "result_type":"", "expr_info": [ "IS_FUNC", "CNT_CONST", "CNT_COLUMN", "CNT_FUNC" ], "rel_id": [ 1 ], "func":"partition_hash", "children": [ { "item_type":"T_OP_ADD", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } } ] } ] } } ], "column": [ { "column_id":17, "column_name":"c2", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 } }, { "column_id":16, "column_name":"c1", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 } } ], "where": [ { "item_type":"T_OP_GT", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN", "IS_RANGE_COND" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":10 } } ] } ], "order_by": [ { "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 }, "ascending":"ASC" } ], "limit": { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } }, "offset":null, "when": [ ] } *************** Case 11 *************** delete from rongxuan.t1 where rongxuan.t1.c2 > 10 order by rongxuan.t1.c1 limit 1; { "stmt_type":4, "table_id":1, "table": [ { "table_id":1, "table_name":"t1", "alias_name":"", "table_type":0, "ref_id":1, "ref_query":null } ], "partition_express": [ { "table_id":1, "expression": { "item_type":"T_FUN_SYS_PART_HASH", "result_type":"", "expr_info": [ "IS_FUNC", "CNT_CONST", "CNT_COLUMN", "CNT_FUNC" ], "rel_id": [ 1 ], "func":"partition_hash", "children": [ { "item_type":"T_OP_ADD", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } } ] } ] } } ], "column": [ { "column_id":17, "column_name":"c2", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 } }, { "column_id":16, "column_name":"c1", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 } } ], "where": [ { "item_type":"T_OP_GT", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN", "IS_RANGE_COND" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":10 } } ] } ], "order_by": [ { "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 }, "ascending":"ASC" } ], "limit": { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } }, "offset":null, "when": [ ] } *************** Case 12 *************** select t1.c1, t2.c1 from t1 join t2 on t1.c1=t2.c1 where t1.c1>0; { "stmt_type":1, "table": [ { "table_id":1, "table_name":"t1", "alias_name":"", "table_type":0, "ref_id":1, "ref_query":null }, { "table_id":2, "table_name":"t2", "alias_name":"", "table_type":0, "ref_id":2, "ref_query":null } ], "joined_table": [ { "table_id":-2, "table_type":3, "join_type":"INNER JOIN", "left_table": { "table_id":1, "table_name":"t1", "alias_name":"", "table_type":0, "ref_id":1, "ref_query":null }, "right_table": { "table_id":2, "table_name":"t2", "alias_name":"", "table_type":0, "ref_id":2, "ref_query":null } } ], "partition_express": [ { "table_id":1, "expression": { "item_type":"T_FUN_SYS_PART_HASH", "result_type":"", "expr_info": [ "IS_FUNC", "CNT_CONST", "CNT_COLUMN", "CNT_FUNC" ], "rel_id": [ 1 ], "func":"partition_hash", "children": [ { "item_type":"T_OP_ADD", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } } ] } ] } }, { "table_id":2, "expression": { "item_type":"T_FUN_SYS_PART_KEY", "result_type":"", "expr_info": [ "IS_FUNC", "CNT_COLUMN", "CNT_FUNC" ], "rel_id": [ 2 ], "func":"partition_key", "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 2 ], "table_id":2, "column_id":17 }, { "item_type":"T_REF_COLUMN", "result_type":"VARCHAR", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 2 ], "table_id":2, "column_id":18 } ] } } ], "column": [ { "column_id":17, "column_name":"c2", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 } }, { "column_id":17, "column_name":"c2", "table_id":2, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 2 ], "table_id":2, "column_id":17 } }, { "column_id":18, "column_name":"c3", "table_id":2, "obj_type":"VARCHAR", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"VARCHAR", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 2 ], "table_id":2, "column_id":18 } }, { "column_id":16, "column_name":"c1", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 } }, { "column_id":16, "column_name":"c1", "table_id":2, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 2 ], "table_id":2, "column_id":16 } } ], "select": [ { "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 }, "table_id":-1, "column_id":65519, "is_alias":false, "alias_name":"c1", "expr_name":"c1", "obj_type":"BIGINT", "decimal_scale":0 }, { "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 2 ], "table_id":2, "column_id":16 }, "table_id":-1, "column_id":65518, "is_alias":false, "alias_name":"c1", "expr_name":"c1", "obj_type":"BIGINT", "decimal_scale":0 } ], "distinct":false, "from": [ { "table_id":-2, "is_join":true } ], "where": [ { "item_type":"T_OP_GT", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN", "IS_RANGE_COND" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":0 } } ] } ], "group_by": [ ], "having": [ ], "aggr_func": [ ], "order_by": [ ], "limit":null, "offset":null, "for_update":false, "wait":-1, "when": [ ], "hint": { "read_static":false, "frozen_version":-1, "topk_precision":-1, "sharding_minimum_row_count":0, "query_timeout":-1, "hotspot":false, "index": [ ], "read_consistency":0, "join_order": [ ], "merge_hint": [ ], "merge_hint_idxs":"0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000", "hash_hint": [ ], "hash_hint_idxs":"0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000", "nl_hint": [ ], "nl_hint_idxs":"0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000" }, "equal_sets": [ ] } *************** Case 13 *************** select t1.c1, rongxuan.t2.c1 from rongxuan.t1 join rongxuan.t2 on rongxuan.t1.c1=t2.c1 where t1.c1>0; { "stmt_type":1, "table": [ { "table_id":1, "table_name":"t1", "alias_name":"", "table_type":0, "ref_id":1, "ref_query":null }, { "table_id":2, "table_name":"t2", "alias_name":"", "table_type":0, "ref_id":2, "ref_query":null } ], "joined_table": [ { "table_id":-2, "table_type":3, "join_type":"INNER JOIN", "left_table": { "table_id":1, "table_name":"t1", "alias_name":"", "table_type":0, "ref_id":1, "ref_query":null }, "right_table": { "table_id":2, "table_name":"t2", "alias_name":"", "table_type":0, "ref_id":2, "ref_query":null } } ], "partition_express": [ { "table_id":1, "expression": { "item_type":"T_FUN_SYS_PART_HASH", "result_type":"", "expr_info": [ "IS_FUNC", "CNT_CONST", "CNT_COLUMN", "CNT_FUNC" ], "rel_id": [ 1 ], "func":"partition_hash", "children": [ { "item_type":"T_OP_ADD", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } } ] } ] } }, { "table_id":2, "expression": { "item_type":"T_FUN_SYS_PART_KEY", "result_type":"", "expr_info": [ "IS_FUNC", "CNT_COLUMN", "CNT_FUNC" ], "rel_id": [ 2 ], "func":"partition_key", "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 2 ], "table_id":2, "column_id":17 }, { "item_type":"T_REF_COLUMN", "result_type":"VARCHAR", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 2 ], "table_id":2, "column_id":18 } ] } } ], "column": [ { "column_id":17, "column_name":"c2", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 } }, { "column_id":17, "column_name":"c2", "table_id":2, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 2 ], "table_id":2, "column_id":17 } }, { "column_id":18, "column_name":"c3", "table_id":2, "obj_type":"VARCHAR", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"VARCHAR", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 2 ], "table_id":2, "column_id":18 } }, { "column_id":16, "column_name":"c1", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 } }, { "column_id":16, "column_name":"c1", "table_id":2, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 2 ], "table_id":2, "column_id":16 } } ], "select": [ { "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 }, "table_id":-1, "column_id":65519, "is_alias":false, "alias_name":"c1", "expr_name":"c1", "obj_type":"BIGINT", "decimal_scale":0 }, { "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 2 ], "table_id":2, "column_id":16 }, "table_id":-1, "column_id":65518, "is_alias":false, "alias_name":"c1", "expr_name":"c1", "obj_type":"BIGINT", "decimal_scale":0 } ], "distinct":false, "from": [ { "table_id":-2, "is_join":true } ], "where": [ { "item_type":"T_OP_GT", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN", "IS_RANGE_COND" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":0 } } ] } ], "group_by": [ ], "having": [ ], "aggr_func": [ ], "order_by": [ ], "limit":null, "offset":null, "for_update":false, "wait":-1, "when": [ ], "hint": { "read_static":false, "frozen_version":-1, "topk_precision":-1, "sharding_minimum_row_count":0, "query_timeout":-1, "hotspot":false, "index": [ ], "read_consistency":0, "join_order": [ ], "merge_hint": [ ], "merge_hint_idxs":"0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000", "hash_hint": [ ], "hash_hint_idxs":"0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000", "nl_hint": [ ], "nl_hint_idxs":"0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000" }, "equal_sets": [ ] } *************** Case 14 *************** insert into t1 value (1, 2), (3, 4) on duplicate key update c1 = c2 + 1, c2 = c2 + 3; { "stmt_type":2, "table": [ { "table_id":1, "table_name":"t1", "alias_name":"", "table_type":0, "ref_id":1, "ref_query":null } ], "partition_express": [ { "table_id":1, "expression": { "item_type":"T_FUN_SYS_PART_HASH", "result_type":"", "expr_info": [ "IS_FUNC", "CNT_CONST", "CNT_COLUMN", "CNT_FUNC" ], "rel_id": [ 1 ], "func":"partition_hash", "children": [ { "item_type":"T_OP_ADD", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } } ] } ] } } ], "column": [ { "column_id":16, "column_name":"c1", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":0, "cs_level":7, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 } }, { "column_id":17, "column_name":"c2", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 } } ], "value": [ [ { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":2 } } ], [ { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":3 } }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":4 } } ] ], "on_duplicate": [ { "table": { "table_id":1, "table_name":"t1", "alias_name":"", "table_type":0, "ref_id":1, "ref_query":null }, "assign": [ { "column": { "column_id":16, "column_name":"c1", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 } }, "expression": { "item_type":"T_OP_ADD", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } } ] } }, { "column": { "column_id":17, "column_name":"c2", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 } }, "expression": { "item_type":"T_OP_ADD", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":3 } } ] } } ] } ] } *************** Case 15 *************** insert into rongxuan.t1 value (112, 2), (15, 4) on duplicate key update rongxuan.t1.c1 = c2 + 1, t1.c2 = c2 + 3; { "stmt_type":2, "table": [ { "table_id":1, "table_name":"t1", "alias_name":"", "table_type":0, "ref_id":1, "ref_query":null } ], "partition_express": [ { "table_id":1, "expression": { "item_type":"T_FUN_SYS_PART_HASH", "result_type":"", "expr_info": [ "IS_FUNC", "CNT_CONST", "CNT_COLUMN", "CNT_FUNC" ], "rel_id": [ 1 ], "func":"partition_hash", "children": [ { "item_type":"T_OP_ADD", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } } ] } ] } } ], "column": [ { "column_id":16, "column_name":"c1", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":0, "cs_level":7, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 } }, { "column_id":17, "column_name":"c2", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 } } ], "value": [ [ { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":112 } }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":2 } } ], [ { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":15 } }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":4 } } ] ], "on_duplicate": [ { "table": { "table_id":1, "table_name":"t1", "alias_name":"", "table_type":0, "ref_id":1, "ref_query":null }, "assign": [ { "column": { "column_id":16, "column_name":"c1", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":0, "cs_level":7, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 } }, "expression": { "item_type":"T_OP_ADD", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } } ] } }, { "column": { "column_id":17, "column_name":"c2", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 } }, "expression": { "item_type":"T_OP_ADD", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":3 } } ] } } ] } ] } *************** Case 16 *************** update test set c4 = 'abc' where c1 = 1; { "stmt_type":5, "table": [ { "table_id":4, "table_name":"test", "alias_name":"", "table_type":0, "ref_id":4, "ref_query":null } ], "partition_express": [ ], "column": [ { "column_id":16, "column_name":"c1", "table_id":4, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":4, "column_id":16 } }, { "column_id":17, "column_name":"c2", "table_id":4, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":4, "column_id":17 } }, { "column_id":18, "column_name":"c3", "table_id":4, "obj_type":"VARCHAR", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"VARCHAR", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":4, "column_id":18 } }, { "column_id":19, "column_name":"c4", "table_id":4, "obj_type":"VARCHAR", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"VARCHAR", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":4, "column_id":19 } } ], "input_columns": [ { "table_id":4, "table_name":"test", "column": [ { "column_id":16, "column_name":"c1", "table_id":4, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":4, "column_id":16 } }, { "column_id":17, "column_name":"c2", "table_id":4, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":4, "column_id":17 } }, { "column_id":18, "column_name":"c3", "table_id":4, "obj_type":"VARCHAR", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"VARCHAR", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":4, "column_id":18 } }, { "column_id":19, "column_name":"c4", "table_id":4, "obj_type":"VARCHAR", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"VARCHAR", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":4, "column_id":19 } } ] } ], "assign": [ { "table": { "table_id":4, "table_name":"test", "alias_name":"", "table_type":0, "ref_id":4, "ref_query":null }, "assign": [ { "column": { "column_id":19, "column_name":"c4", "table_id":4, "obj_type":"VARCHAR", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"VARCHAR", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":4, "column_id":19 } }, "expression": { "item_type":"T_STRING", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "VARCHAR":"abc" } } } ] } ], "where": [ { "item_type":"T_OP_EQ", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN", "IS_SIMPLE_COND" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":4, "column_id":16 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } } ] } ], "order_by": [ ], "limit":null, "offset":null, "when": [ ] } *************** Case 17 *************** select * from t1 where c1=1 and c1=c2 and c1+1=c2+1; { "stmt_type":1, "table": [ { "table_id":1, "table_name":"t1", "alias_name":"", "table_type":0, "ref_id":1, "ref_query":null } ], "joined_table": [ ], "partition_express": [ { "table_id":1, "expression": { "item_type":"T_FUN_SYS_PART_HASH", "result_type":"", "expr_info": [ "IS_FUNC", "CNT_CONST", "CNT_COLUMN", "CNT_FUNC" ], "rel_id": [ 1 ], "func":"partition_hash", "children": [ { "item_type":"T_OP_ADD", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } } ] } ] } } ], "column": [ { "column_id":17, "column_name":"c2", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 } }, { "column_id":16, "column_name":"c1", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":0, "cs_level":7, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 } }, { "column_id":16, "column_name":"c1", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 } }, { "column_id":16, "column_name":"c1", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 } }, { "column_id":16, "column_name":"c1", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 } } ], "select": [ { "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 }, "table_id":-1, "column_id":65519, "is_alias":false, "alias_name":"c1", "expr_name":"c1", "obj_type":"BIGINT", "decimal_scale":0 }, { "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, "table_id":-1, "column_id":65518, "is_alias":false, "alias_name":"c2", "expr_name":"c2", "obj_type":"BIGINT", "decimal_scale":0 } ], "distinct":false, "from": [ { "table_id":1, "is_join":false } ], "where": [ { "item_type":"T_OP_EQ", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN", "IS_SIMPLE_COND" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } } ] }, { "item_type":"T_OP_EQ", "result_type":"", "expr_info": [ "CNT_COLUMN", "IS_JOIN_COND" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 }, { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 } ] }, { "item_type":"T_OP_EQ", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN", "IS_JOIN_COND" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_OP_ADD", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } } ] }, { "item_type":"T_OP_ADD", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } } ] } ] }, { "item_type":"T_OP_EQ", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN", "IS_SIMPLE_COND" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } } ] } ], "group_by": [ ], "having": [ ], "aggr_func": [ ], "order_by": [ ], "limit":null, "offset":null, "for_update":false, "wait":-1, "when": [ ], "hint": { "read_static":false, "frozen_version":-1, "topk_precision":-1, "sharding_minimum_row_count":0, "query_timeout":-1, "hotspot":false, "index": [ ], "read_consistency":0, "join_order": [ ], "merge_hint": [ ], "merge_hint_idxs":"0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000", "hash_hint": [ ], "hash_hint_idxs":"0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000", "nl_hint": [ ], "nl_hint_idxs":"0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000" }, "equal_sets": [ [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } }, { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 } ], [ { "item_type":"T_OP_ADD", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } } ] }, { "item_type":"T_OP_ADD", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } } ] } ] ] } *************** Case 18 *************** select * from t1 where c1=? and c2=?; { "stmt_type":1, "table": [ { "table_id":1, "table_name":"t1", "alias_name":"", "table_type":0, "ref_id":1, "ref_query":null } ], "joined_table": [ ], "partition_express": [ { "table_id":1, "expression": { "item_type":"T_FUN_SYS_PART_HASH", "result_type":"", "expr_info": [ "IS_FUNC", "CNT_CONST", "CNT_COLUMN", "CNT_FUNC" ], "rel_id": [ 1 ], "func":"partition_hash", "children": [ { "item_type":"T_OP_ADD", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } } ] } ] } } ], "column": [ { "column_id":17, "column_name":"c2", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 } }, { "column_id":16, "column_name":"c1", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":0, "cs_level":7, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 } }, { "column_id":16, "column_name":"c1", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 } } ], "select": [ { "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 }, "table_id":-1, "column_id":65519, "is_alias":false, "alias_name":"c1", "expr_name":"c1", "obj_type":"BIGINT", "decimal_scale":0 }, { "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, "table_id":-1, "column_id":65518, "is_alias":false, "alias_name":"c2", "expr_name":"c2", "obj_type":"BIGINT", "decimal_scale":0 } ], "distinct":false, "from": [ { "table_id":1, "is_join":false } ], "where": [ { "item_type":"T_OP_EQ", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN", "CNT_STATIC_PARAM", "IS_SIMPLE_COND" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 }, { "item_type":"T_QUESTIONMARK", "result_type":"", "expr_info": [ "IS_CONST", "IS_STATIC_PARAM", "CNT_CONST", "CNT_STATIC_PARAM" ], "rel_id": [ ], "value": { "UNKNOWN":0 } } ] }, { "item_type":"T_OP_EQ", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN", "CNT_STATIC_PARAM", "IS_SIMPLE_COND" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, { "item_type":"T_QUESTIONMARK", "result_type":"", "expr_info": [ "IS_CONST", "IS_STATIC_PARAM", "CNT_CONST", "CNT_STATIC_PARAM" ], "rel_id": [ ], "value": { "UNKNOWN":1 } } ] } ], "group_by": [ ], "having": [ ], "aggr_func": [ ], "order_by": [ ], "limit":null, "offset":null, "for_update":false, "wait":-1, "when": [ ], "hint": { "read_static":false, "frozen_version":-1, "topk_precision":-1, "sharding_minimum_row_count":0, "query_timeout":-1, "hotspot":false, "index": [ ], "read_consistency":0, "join_order": [ ], "merge_hint": [ ], "merge_hint_idxs":"0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000", "hash_hint": [ ], "hash_hint_idxs":"0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000", "nl_hint": [ ], "nl_hint_idxs":"0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000" }, "equal_sets": [ [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 }, { "item_type":"T_QUESTIONMARK", "result_type":"", "expr_info": [ "IS_CONST", "IS_STATIC_PARAM", "CNT_CONST", "CNT_STATIC_PARAM" ], "rel_id": [ ], "value": { "UNKNOWN":0 } } ], [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, { "item_type":"T_QUESTIONMARK", "result_type":"", "expr_info": [ "IS_CONST", "IS_STATIC_PARAM", "CNT_CONST", "CNT_STATIC_PARAM" ], "rel_id": [ ], "value": { "UNKNOWN":1 } } ] ] } *************** Case 19 *************** select * from t1 where c1=1 and c2=1; { "stmt_type":1, "table": [ { "table_id":1, "table_name":"t1", "alias_name":"", "table_type":0, "ref_id":1, "ref_query":null } ], "joined_table": [ ], "partition_express": [ { "table_id":1, "expression": { "item_type":"T_FUN_SYS_PART_HASH", "result_type":"", "expr_info": [ "IS_FUNC", "CNT_CONST", "CNT_COLUMN", "CNT_FUNC" ], "rel_id": [ 1 ], "func":"partition_hash", "children": [ { "item_type":"T_OP_ADD", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } } ] } ] } } ], "column": [ { "column_id":17, "column_name":"c2", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 } }, { "column_id":16, "column_name":"c1", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":0, "cs_level":7, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 } }, { "column_id":16, "column_name":"c1", "table_id":1, "obj_type":"BIGINT", "data_length":0, "cs_type":45, "cs_level":2, "decimal_scale":0, "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 } } ], "select": [ { "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 }, "table_id":-1, "column_id":65519, "is_alias":false, "alias_name":"c1", "expr_name":"c1", "obj_type":"BIGINT", "decimal_scale":0 }, { "expression": { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, "table_id":-1, "column_id":65518, "is_alias":false, "alias_name":"c2", "expr_name":"c2", "obj_type":"BIGINT", "decimal_scale":0 } ], "distinct":false, "from": [ { "table_id":1, "is_join":false } ], "where": [ { "item_type":"T_OP_EQ", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN", "IS_SIMPLE_COND" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } } ] }, { "item_type":"T_OP_EQ", "result_type":"", "expr_info": [ "CNT_CONST", "CNT_COLUMN", "IS_SIMPLE_COND" ], "rel_id": [ 1 ], "children": [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } } ] } ], "group_by": [ ], "having": [ ], "aggr_func": [ ], "order_by": [ ], "limit":null, "offset":null, "for_update":false, "wait":-1, "when": [ ], "hint": { "read_static":false, "frozen_version":-1, "topk_precision":-1, "sharding_minimum_row_count":0, "query_timeout":-1, "hotspot":false, "index": [ ], "read_consistency":0, "join_order": [ ], "merge_hint": [ ], "merge_hint_idxs":"0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000", "hash_hint": [ ], "hash_hint_idxs":"0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000", "nl_hint": [ ], "nl_hint_idxs":"0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000" }, "equal_sets": [ [ { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":16 }, { "item_type":"T_INT", "result_type":"", "expr_info": [ "IS_CONST", "CNT_CONST" ], "rel_id": [ ], "value": { "BIGINT":1 } }, { "item_type":"T_REF_COLUMN", "result_type":"BIGINT", "expr_info": [ "IS_COLUMN", "CNT_COLUMN" ], "rel_id": [ 1 ], "table_id":1, "column_id":17 } ] ] } *************** Case 20 *************** prepare p1 from select ?; { "stmt_name":"p1", "prepare_sql":"select ?" } *************** Case 21 *************** execute p1 using @a; { "stmt_name":"p1", "var_name": [ "a" ] } *************** Case 22 *************** deallocate prepare p1; { "stmt_name":"p1" }