Method dumpViewContent

src/Client/BuzzHouse/Generator/QueryOracle.cpp:1393–1437

View oracle: dump all columns with explicit ORDER BY

/// View oracle: dump all columns with explicit ORDER BY
void QueryOracle::dumpViewContent(RandomGenerator & rg, const SQLView & v, SQLQuery & sq1, SQLQuery & sq2)
{
    TopSelect * ts = sq1.mutable_single_query()->mutable_explain()->mutable_inner_query()->mutable_select();
    SelectIntoFile * sif = ts->mutable_intofile();
    Select * sel = ts->mutable_sel();
    SelectStatementCore * ssc = sel->mutable_select_core();
    JoinedTableOrFunction * jtf = ssc->mutable_from()->mutable_tos()->mutable_join_clause()->mutable_tos()->mutable_joined_table();

    v.setName(jtf->mutable_tof()->mutable_est(), false);
    jtf->set_final(v.supportsFinal());

    bool first = true;
    uint32_t col_idx = 0;
    OrderByList * obs = ssc->mutable_orderby()->mutable_olist();

    for (const auto & col : v.cols)
    {
        ExprOrderingTerm * eot = first ? obs->mutable_ord_term() : obs->add_extra_ord_terms();
        const String alias = "a" + std::to_string(col_idx++);

        ExprColAlias * eca = ssc->add_result_columns()->mutable_eca();
        eca->mutable_expr()->mutable_comp_expr()->mutable_expr_stc()->mutable_col()->mutable_path()->mutable_col()->set_column(col);
        eca->mutable_col_alias()->set_column(alias);
        eot->mutable_expr()->mutable_comp_expr()->mutable_expr_stc()->mutable_col()->mutable_path()->mutable_col()->set_column(alias);
        if (rg.nextBool())
        {
            eot->set_asc_desc(rg.nextBool() ? AscDesc::ASC : AscDesc::DESC);
        }
        if (rg.nextBool())
        {
            eot->set_nulls_order(
                rg.nextBool() ? ExprOrderingTerm_NullsOrder::ExprOrderingTerm_NullsOrder_FIRST
                              : ExprOrderingTerm_NullsOrder::ExprOrderingTerm_NullsOrder_LAST);
        }
        first = false;
    }

    finishSettings(sel->mutable_setting_values());
    ts->set_format(rg.pickRandomly(rg.pickRandomly(QueryOracle::oracleFormats)));
    const auto err = std::filesystem::remove(qcfile);
    UNUSED(err);
    sif->set_path(qcfile.generic_string());
    sif->set_step(SelectIntoFile_SelectIntoFileStep::SelectIntoFile_SelectIntoFileStep_TRUNCATE);
    sq2.CopyFrom(sq1);
}

void QueryOracle::generateImportQuery(
    RandomGenerator & rg, StatementGenerator & gen, const SQLTable & t, const SQLQuery & sq2, SQLQuery & sq4) const