Function mysql_sql_parse_join

sqladvisor/main.cc:147–171

}

void mysql_sql_parse_join(TABLE_LIST *join_table) {
    List_iterator<TABLE_LIST> li_join_list(join_table->nested_join->join_list);
    TABLE_LIST * table_right = li_join_list++;
    TABLE_LIST * table_left = li_join_list++;
    List_iterator<String> using_fields(*join_table->join_using_fields);
    String *using_field;
    while ((using_field = using_fields++)) {
        if (options.verbose)
            sql_print_information("第%d步：开始解析join using条件:%s \n", STEP_CNT++,
                    using_field->ptr());
        Item_field * field_cond_left = new Item_field(NULL, NULL,
                table_left->table_name, using_field->ptr());
        Item_field * field_cond_right = new Item_field(NULL, NULL,
                table_right->table_name, using_field->ptr());

        JOIN_CONDITION * right_table_join = new JOIN_CONDITION(table_left);
        JOIN_CONDITION * left_table_join = new JOIN_CONDITION(table_right);

        right_table_join->get_join_field()->push_back(field_cond_left);
        left_table_join->get_join_field()->push_back(field_cond_right);

        table_right->get_join_condition()->push_back(right_table_join);
        table_left->get_join_condition()->push_back(left_table_join);
    }
}

void mysql_sql_parse_join(Item *join_condition) {
    Item::Type type = join_condition->type();