You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-10-30 07:25:34 +03:00
256691652d
* toCppCode for ParseTree and TreeNode * generated tree is compiling * Put tree constructors into tests * Minor fixes * Fixed parse + some constructors * Fixed includes, removed debug and old data * Hopefully fix clang errors * Forgot an override * More overrides
1030 lines
60 KiB
C++
1030 lines
60 KiB
C++
#include "simplecolumn.h"
|
|
#include "constantfilter.h"
|
|
#include "simplefilter.h"
|
|
#include "logicoperator.h"
|
|
#include "parsetree.h"
|
|
#include "existsfilter.h"
|
|
|
|
namespace execplan
|
|
{
|
|
auto initial_Query_1 = new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` + `test`.`t2`.`pos` > 15000", SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` = `test`.`t2`.`id`",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` + `test`.`t2`.`pos` < 1000", SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}), nullptr,
|
|
nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` = `test`.`t2`.`id`",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)));
|
|
}
|
|
|
|
namespace execplan
|
|
{
|
|
auto initial_Query_2 = new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` + `test`.`t2`.`pos` < 1000", SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}), nullptr,
|
|
nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` = `test`.`t2`.`id`",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr));
|
|
}
|
|
|
|
namespace execplan
|
|
{
|
|
auto initial_Query_3 = new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` + `test`.`t2`.`pos` < 1000", SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}), nullptr,
|
|
nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` = `test`.`t2`.`id`",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr));
|
|
}
|
|
|
|
namespace execplan
|
|
{
|
|
auto initial_Query_4 = new ParseTree(
|
|
new SimpleFilter("`test`.`t1`.`pos` > 20", SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}), nullptr,
|
|
nullptr);
|
|
}
|
|
|
|
namespace execplan
|
|
{
|
|
auto initial_Query_5 = new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` + `test`.`t2`.`pos` > 15000", SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` = `test`.`t2`.`id`",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` + `test`.`t2`.`pos` < 1000", SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}), nullptr,
|
|
nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` = `test`.`t2`.`id`",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)));
|
|
}
|
|
|
|
namespace execplan
|
|
{
|
|
auto initial_Query_6 = new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` + `test`.`t2`.`pos` > 15000", SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` = `test`.`t2`.`id`",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` + `test`.`t2`.`pos` < 1000", SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}), nullptr,
|
|
nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` = `test`.`t2`.`rid`",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)));
|
|
}
|
|
|
|
namespace execplan
|
|
{
|
|
auto initial_Query_7 =
|
|
new ParseTree(new ExistsFilter(boost::shared_ptr<CalpontSelectExecutionPlan>(), 0, 1), nullptr, nullptr);
|
|
}
|
|
|
|
namespace execplan
|
|
{
|
|
auto initial_Query_8 = new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` = `test`.`t2`.`id`",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new ExistsFilter(boost::shared_ptr<CalpontSelectExecutionPlan>(), 0, 1), nullptr, nullptr));
|
|
}
|
|
|
|
namespace execplan
|
|
{
|
|
auto initial_Query_9 = new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` = `test`.`t2`.`rid`",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` = `test`.`t2`.`id`",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new ExistsFilter(boost::shared_ptr<CalpontSelectExecutionPlan>(), 0, 1), nullptr, nullptr));
|
|
}
|
|
|
|
namespace execplan
|
|
{
|
|
auto initial_Query_10 = new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`place` > 'abcdefghij'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`posname` > 'qwer'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)));
|
|
}
|
|
|
|
namespace execplan
|
|
{
|
|
auto initial_Query_11 = new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)));
|
|
}
|
|
|
|
namespace execplan
|
|
{
|
|
auto initial_Query_12 = new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(
|
|
new SimpleFilter("`test`.`t1`.`id` < 30", SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(
|
|
new SimpleFilter("`test`.`t1`.`pos` > 5000", SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr));
|
|
}
|
|
|
|
namespace execplan
|
|
{
|
|
auto initial_Query_13 = new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(new LogicOperator("or"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(
|
|
new SimpleFilter("`test`.`t1`.`id` < 30", SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(
|
|
new SimpleFilter("`test`.`t1`.`pos` > 5000", SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr));
|
|
}
|
|
|
|
namespace execplan
|
|
{
|
|
auto initial_Query_14 = new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(new LogicOperator("or"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new ExistsFilter(boost::shared_ptr<CalpontSelectExecutionPlan>(), 0, 1), nullptr, nullptr));
|
|
}
|
|
|
|
namespace execplan
|
|
{
|
|
auto initial_Query_15 = new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(new LogicOperator("or"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new ExistsFilter(boost::shared_ptr<CalpontSelectExecutionPlan>(), 0, 1), nullptr, nullptr));
|
|
}
|
|
|
|
namespace execplan
|
|
{
|
|
auto initial_Query_16 = new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr))),
|
|
new ParseTree(new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)));
|
|
}
|
|
|
|
namespace execplan
|
|
{
|
|
auto initial_Query_17 = new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr))),
|
|
new ParseTree(new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr))),
|
|
new ParseTree(new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)));
|
|
}
|
|
|
|
namespace execplan
|
|
{
|
|
auto initial_Query_18 = new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr))),
|
|
new ParseTree(new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr))),
|
|
new ParseTree(new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr))),
|
|
new ParseTree(new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)));
|
|
}
|
|
|
|
namespace execplan
|
|
{
|
|
auto initial_Query_19 = new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(
|
|
new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(
|
|
new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr))),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr))),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr))),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr))),
|
|
new ParseTree(new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr))),
|
|
new ParseTree(new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr))),
|
|
new ParseTree(new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)));
|
|
}
|
|
|
|
namespace execplan
|
|
{
|
|
auto initial_Query_20 = new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`place` > 'abcdefghij'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`posname` > 'qwer'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)));
|
|
}
|
|
|
|
namespace execplan
|
|
{
|
|
auto initial_Query_21 = new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`place` < 'zyxqwertyu'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`place` > 'abcdefghij'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`posname` > 'qwer'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr))),
|
|
new ParseTree(new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)));
|
|
}
|
|
|
|
namespace execplan
|
|
{
|
|
auto initial_Query_22 = new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`place` < 'zyxqwertyu'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr))),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`place` > 'abcdefghij'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`posname` > 'qwer'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr))),
|
|
new ParseTree(new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)));
|
|
}
|
|
|
|
namespace execplan
|
|
{
|
|
auto initial_Query_23 = new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`place` < 'zyxqwertyu'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new SimpleFilter("30 > `test`.`t1`.`id`",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr))),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("5000 < `test`.`t1`.`pos`",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`place` > 'abcdefghij'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`posname` > 'qwer'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr))),
|
|
new ParseTree(new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("5000 < `test`.`t1`.`pos`",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)));
|
|
}
|
|
|
|
namespace execplan
|
|
{
|
|
auto initial_Query_27 = new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`rid` > 20",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`place` < 'zyxqwertyu'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`rid` > 20",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr))),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`rid` > 20",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`place` < 'zyxqwertyu'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr))),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`rid` > 20",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`place` > 'abcdefghij'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`posname` > 'qwer'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr))),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`rid` > 20",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(
|
|
new SimpleFilter("`test`.`t1`.`pos` > 5000", SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)));
|
|
}
|
|
|
|
namespace execplan
|
|
{
|
|
auto initial_Query_28 = new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`place` < 'zyxqwertyu'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`place` < 'zyxqwertyu'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`rid` > 20",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`rid` > 20",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`place` < 'zyxqwertyu'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr))),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`rid` > 20",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`pos` > 5000",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`place` < 'zyxqwertyu'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`place` > 'abcdefghij'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`id` < 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`posname` > 'qwer'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr))),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`place` < 'zyxqwertyu'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(new SimpleFilter("`test`.`t1`.`rid` > 20",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(
|
|
new SimpleFilter("`test`.`t1`.`id` < 30", SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(
|
|
new SimpleFilter("`test`.`t1`.`pos` > 5000", SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)));
|
|
}
|
|
|
|
namespace execplan
|
|
{
|
|
auto initial_TPCH_19 = new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(
|
|
new LogicOperator("or"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new SimpleFilter(
|
|
"`tpch`.`LINEITEM`.`l_shipinstruct` = 'DELIVER IN PERSON'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(
|
|
new ConstantFilter(
|
|
boost::shared_ptr<Operator>(new LogicOperator("or")),
|
|
ConstantFilter::FilterList{
|
|
boost::shared_ptr<SimpleFilter>(new SimpleFilter(
|
|
"`tpch`.`LINEITEM`.`l_shipmode` = 'AIR REG'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{})),
|
|
boost::shared_ptr<SimpleFilter>(new SimpleFilter(
|
|
"`tpch`.`LINEITEM`.`l_shipmode` = 'AIR'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}))},
|
|
boost::shared_ptr<ReturnedColumn>(
|
|
new SimpleColumn("`tpch`.`LINEITEM`.`l_shipmode`",
|
|
SimpleColumn::ForTestPurposeWithoutOID{})),
|
|
"", "`tpch`.`LINEITEM`.`L_SHIPMODE` in ('AIR','AIR REG')"),
|
|
nullptr, nullptr)),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new SimpleFilter("`tpch`.`PART`.`p_size` <= 15",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(
|
|
new SimpleFilter("`tpch`.`PART`.`p_size` >= 1",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr))),
|
|
new ParseTree(new SimpleFilter("`tpch`.`LINEITEM`.`l_quantity` <= 30",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new SimpleFilter("`tpch`.`LINEITEM`.`l_quantity` >= 20",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(
|
|
new ConstantFilter(
|
|
boost::shared_ptr<Operator>(new LogicOperator("or")),
|
|
ConstantFilter::FilterList{
|
|
boost::shared_ptr<SimpleFilter>(
|
|
new SimpleFilter("`tpch`.`PART`.`p_container` = 'LG PKG'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{})),
|
|
boost::shared_ptr<SimpleFilter>(
|
|
new SimpleFilter("`tpch`.`PART`.`p_container` = 'LG PACK'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{})),
|
|
boost::shared_ptr<SimpleFilter>(
|
|
new SimpleFilter("`tpch`.`PART`.`p_container` = 'LG BOX'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{})),
|
|
boost::shared_ptr<SimpleFilter>(
|
|
new SimpleFilter("`tpch`.`PART`.`p_container` = 'LG CASE'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}))},
|
|
boost::shared_ptr<ReturnedColumn>(new SimpleColumn(
|
|
"`tpch`.`PART`.`p_container`", SimpleColumn::ForTestPurposeWithoutOID{})),
|
|
"", "`tpch`.`PART`.`P_CONTAINER` in ('LG CASE','LG BOX','LG PACK','LG PKG')"),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new SimpleFilter("`tpch`.`PART`.`p_brand` = 'Brand#34'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new SimpleFilter("`tpch`.`PART`.`p_partkey` = `tpch`.`LINEITEM`.`l_partkey`",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new SimpleFilter(
|
|
"`tpch`.`LINEITEM`.`l_shipinstruct` = 'DELIVER IN PERSON'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(
|
|
new ConstantFilter(
|
|
boost::shared_ptr<Operator>(new LogicOperator("or")),
|
|
ConstantFilter::FilterList{
|
|
boost::shared_ptr<SimpleFilter>(new SimpleFilter(
|
|
"`tpch`.`LINEITEM`.`l_shipmode` = 'AIR REG'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{})),
|
|
boost::shared_ptr<SimpleFilter>(new SimpleFilter(
|
|
"`tpch`.`LINEITEM`.`l_shipmode` = 'AIR'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}))},
|
|
boost::shared_ptr<ReturnedColumn>(
|
|
new SimpleColumn("`tpch`.`LINEITEM`.`l_shipmode`",
|
|
SimpleColumn::ForTestPurposeWithoutOID{})),
|
|
"", "`tpch`.`LINEITEM`.`L_SHIPMODE` in ('AIR','AIR REG')"),
|
|
nullptr, nullptr)),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new SimpleFilter("`tpch`.`PART`.`p_size` <= 10",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(
|
|
new SimpleFilter("`tpch`.`PART`.`p_size` >= 1",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr))),
|
|
new ParseTree(new SimpleFilter("`tpch`.`LINEITEM`.`l_quantity` <= 20",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new SimpleFilter("`tpch`.`LINEITEM`.`l_quantity` >= 10",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(
|
|
new ConstantFilter(
|
|
boost::shared_ptr<Operator>(new LogicOperator("or")),
|
|
ConstantFilter::FilterList{
|
|
boost::shared_ptr<SimpleFilter>(
|
|
new SimpleFilter("`tpch`.`PART`.`p_container` = 'MED PACK'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{})),
|
|
boost::shared_ptr<SimpleFilter>(
|
|
new SimpleFilter("`tpch`.`PART`.`p_container` = 'MED PKG'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{})),
|
|
boost::shared_ptr<SimpleFilter>(
|
|
new SimpleFilter("`tpch`.`PART`.`p_container` = 'MED BOX'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{})),
|
|
boost::shared_ptr<SimpleFilter>(
|
|
new SimpleFilter("`tpch`.`PART`.`p_container` = 'MED BAG'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}))},
|
|
boost::shared_ptr<ReturnedColumn>(new SimpleColumn(
|
|
"`tpch`.`PART`.`p_container`", SimpleColumn::ForTestPurposeWithoutOID{})),
|
|
"", "`tpch`.`PART`.`P_CONTAINER` in ('MED BAG','MED BOX','MED PKG','MED PACK')"),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new SimpleFilter("`tpch`.`PART`.`p_brand` = 'Brand#23'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new SimpleFilter("`tpch`.`PART`.`p_partkey` = `tpch`.`LINEITEM`.`l_partkey`",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr))),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(new SimpleFilter(
|
|
"`tpch`.`LINEITEM`.`l_shipinstruct` = 'DELIVER IN PERSON'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(
|
|
new ConstantFilter(
|
|
boost::shared_ptr<Operator>(new LogicOperator("or")),
|
|
ConstantFilter::FilterList{
|
|
boost::shared_ptr<SimpleFilter>(new SimpleFilter(
|
|
"`tpch`.`LINEITEM`.`l_shipmode` = 'AIR REG'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{})),
|
|
boost::shared_ptr<SimpleFilter>(new SimpleFilter(
|
|
"`tpch`.`LINEITEM`.`l_shipmode` = 'AIR'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}))},
|
|
boost::shared_ptr<ReturnedColumn>(
|
|
new SimpleColumn("`tpch`.`LINEITEM`.`l_shipmode`",
|
|
SimpleColumn::ForTestPurposeWithoutOID{})),
|
|
"", "`tpch`.`LINEITEM`.`L_SHIPMODE` in ('AIR','AIR REG')"),
|
|
nullptr, nullptr)),
|
|
new ParseTree(
|
|
new LogicOperator("and"),
|
|
new ParseTree(
|
|
new SimpleFilter("`tpch`.`PART`.`p_size` <= 5",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr),
|
|
new ParseTree(
|
|
new SimpleFilter("`tpch`.`PART`.`p_size` >= 1",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr))),
|
|
new ParseTree(new SimpleFilter("`tpch`.`LINEITEM`.`l_quantity` <= 11",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new SimpleFilter("`tpch`.`LINEITEM`.`l_quantity` >= 1",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(
|
|
new ConstantFilter(
|
|
boost::shared_ptr<Operator>(new LogicOperator("or")),
|
|
ConstantFilter::FilterList{boost::shared_ptr<SimpleFilter>(new SimpleFilter(
|
|
"`tpch`.`PART`.`p_container` = 'SM PKG'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{})),
|
|
boost::shared_ptr<SimpleFilter>(new SimpleFilter(
|
|
"`tpch`.`PART`.`p_container` = 'SM PACK'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{})),
|
|
boost::shared_ptr<SimpleFilter>(new SimpleFilter(
|
|
"`tpch`.`PART`.`p_container` = 'SM BOX'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{})),
|
|
boost::shared_ptr<SimpleFilter>(new SimpleFilter(
|
|
"`tpch`.`PART`.`p_container` = 'SM CASE'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}))},
|
|
boost::shared_ptr<ReturnedColumn>(new SimpleColumn(
|
|
"`tpch`.`PART`.`p_container`", SimpleColumn::ForTestPurposeWithoutOID{})),
|
|
"", "`tpch`.`PART`.`P_CONTAINER` in ('SM CASE','SM BOX','SM PACK','SM PKG')"),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new SimpleFilter("`tpch`.`PART`.`p_brand` = 'Brand#12'",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)),
|
|
new ParseTree(new SimpleFilter("`tpch`.`PART`.`p_partkey` = `tpch`.`LINEITEM`.`l_partkey`",
|
|
SimpleFilter::ForTestPurposesWithoutColumnsOIDS{}),
|
|
nullptr, nullptr)));
|
|
}
|