public static boolean isSplittable(Query q) { if (q.getOrderByClause().getItemCount() != 0) { return false; } return true; }
public static boolean isSplittable(Query q) { if (q.getOrderByClause().getItemCount() != 0) { return false; } return true; }
@Override public boolean isFirstRowSupported(final Query query) { return isSupportedVersion(_databaseProductName, _databaseSupportedVersion) && !query.getOrderByClause() .isEmpty(); }
@Override public boolean isFirstRowSupported(final Query query) { return isSupportedVersion(_databaseProductName, _databaseSupportedVersion) && !query.getOrderByClause() .isEmpty(); }
public String rewriteQuery(Query query) { query = beforeRewrite(query); final StringBuilder sb = new StringBuilder(); sb.append(rewriteSelectClause(query, query.getSelectClause())); sb.append(rewriteFromClause(query, query.getFromClause())); sb.append(rewriteWhereClause(query, query.getWhereClause())); sb.append(rewriteGroupByClause(query, query.getGroupByClause())); sb.append(rewriteHavingClause(query, query.getHavingClause())); sb.append(rewriteOrderByClause(query, query.getOrderByClause())); return sb.toString(); }
public String rewriteQuery(Query query) { query = beforeRewrite(query); final StringBuilder sb = new StringBuilder(); sb.append(rewriteSelectClause(query, query.getSelectClause())); sb.append(rewriteFromClause(query, query.getFromClause())); sb.append(rewriteWhereClause(query, query.getWhereClause())); sb.append(rewriteGroupByClause(query, query.getGroupByClause())); sb.append(rewriteHavingClause(query, query.getHavingClause())); sb.append(rewriteOrderByClause(query, query.getOrderByClause())); return sb.toString(); }
final List<OrderByItem> items = query.getOrderByClause().getItems(); for (OrderByItem orderByItem : items) { if (i == 0) {
final List<OrderByItem> items = query.getOrderByClause().getItems(); for (OrderByItem orderByItem : items) { if (i == 0) {
final boolean hasOrderBy = !query.getOrderByClause().isEmpty(); String queryString = super.rewriteQuery(query);
final boolean hasOrderBy = !query.getOrderByClause().isEmpty(); String queryString = super.rewriteQuery(query);
if (!getScalarFunctionSelectItems(query.getOrderByClause().getEvaluatedSelectItems()).isEmpty()) { return true;
if (!getScalarFunctionSelectItems(query.getOrderByClause().getEvaluatedSelectItems()).isEmpty()) { return true;
final String rewrittenOrderByClause = rewriteOrderByClause(innerQuery, innerQuery.getOrderByClause()); final String rowOver = "ROW_NUMBER() " + "OVER(" + rewrittenOrderByClause + ")"; innerQuery.select(new SelectItem(rowOver, "metamodel_row_number")); innerQuery.getOrderByClause().removeItems();
final String rewrittenOrderByClause = rewriteOrderByClause(innerQuery, innerQuery.getOrderByClause()); final String rowOver = "ROW_NUMBER() " + "OVER(" + rewrittenOrderByClause + ")"; innerQuery.select(new SelectItem(rowOver, "metamodel_row_number")); innerQuery.getOrderByClause().removeItems();
countQuery.setFirstRow(null); countQuery.getSelectClause().removeItems(); countQuery.getOrderByClause().removeItems(); countQuery.selectCount(); countQuery.getSelectClause().getItem(0).setFunctionApproximationAllowed(true);
&& query.getOrderByClause().isEmpty()) {
&& query.getOrderByClause().isEmpty()) {
&& query.getOrderByClause().isEmpty()) {
&& query.getOrderByClause().isEmpty()) {
countQuery.setFirstRow(null); countQuery.getSelectClause().removeItems(); countQuery.getOrderByClause().removeItems(); countQuery.selectCount(); countQuery.getSelectClause().getItem(0).setFunctionApproximationAllowed(true);