/* This file is part of VoltDB.
* Copyright (C) 2008-2017 VoltDB Inc.
*
* Permission is hereby granted, free of charge, to any person obtaining
* a copy of this software and associated documentation files (the
* "Software"), to deal in the Software without restriction, including
* without limitation the rights to use, copy, modify, merge, publish,
* distribute, sublicense, and/or sell copies of the Software, and to
* permit persons to whom the Software is furnished to do so, subject to
* the following conditions:
*
* The above copyright notice and this permission notice shall be
* included in all copies or substantial portions of the Software.
*
* THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
* EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
* MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.
* IN NO EVENT SHALL THE AUTHORS BE LIABLE FOR ANY CLAIM, DAMAGES OR
* OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE,
* ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR
* OTHER DEALINGS IN THE SOFTWARE.
*/
package adhocbenchmark;
/**
* Configuration that determines what the projection queries look like.
*/
class ProjectionTest extends QueryTestBase {
private final String m_idColumn;
private ProjectionTest(final String tableName,
final String columnPrefix, int nColumns, String idColumn) {
super(tableName, columnPrefix, nColumns, nColumns);
m_idColumn = idColumn;
}
@Override
public String getQuery(int iQuery, QueryTestHelper helper) {
// Build the projected column list.
StringBuilder query = new StringBuilder("SELECT ");
for (int iColumn = 0; iColumn < this.nColumns; ++iColumn) {
if (iColumn > 0) {
query.append(", ");
}
query.append(helper.columnName(helper.getShuffledNumber(iColumn)));
}
// Complete the query.
// Enough cache-thrashing complexity comes fom the random column list,
// so keep the where clause simple --
// an equality filter with a random constant enables parallel SP processing
// when the table is partitioned on that column (ID).
// For a replicated table, or an MP query against partitioned data,
// this where clause (against a non-partitioning column) doesn't greatly complicate the plan,
// so keep it.
query.append(" FROM " + this.tablePrefix + "_1 WHERE " + m_idColumn + " = " + helper.getShuffledNumber(0));
return query.toString();
}
public static class Factory implements QueryTestBase.Factory {
@Override
public QueryTestBase make(final String tablePrefix, int nVariations, final String columnPrefix,
final int nColumns, final int nRandomNumbers) {
return new ProjectionTest(tablePrefix, columnPrefix, nColumns, "ID");
}
}
public static class MPFactory implements QueryTestBase.Factory {
@Override
public QueryTestBase make(final String tablePrefix, int nVariations, final String columnPrefix,
final int nColumns, final int nRandomNumbers) {
return new ProjectionTest(tablePrefix, columnPrefix, nColumns, "PARENT_ID");
}
}
}