private int getFirstRow() { return _query.getFirstRow() == null ? 1 : _query.getFirstRow(); }
@Override protected String rewriteSelectClause(Query query, SelectClause selectClause) { String result = super.rewriteSelectClause(query, selectClause); Integer firstRow = query.getFirstRow(); Integer maxRows = query.getMaxRows(); if (maxRows != null || firstRow != null) { if (maxRows == null) { maxRows = Integer.MAX_VALUE; } if (firstRow == null || firstRow <= 0) { result = "SELECT TOP " + maxRows + " " + result.substring(7); } else { final int offset = firstRow - 1; result = "SELECT LIMIT " + offset + " " + maxRows + " " + result.substring(7); } } return result; }
@Override protected String rewriteSelectClause(Query query, SelectClause selectClause) { String result = super.rewriteSelectClause(query, selectClause); Integer firstRow = query.getFirstRow(); Integer maxRows = query.getMaxRows(); if (maxRows != null || firstRow != null) { if (maxRows == null) { maxRows = Integer.MAX_VALUE; } if (firstRow == null || firstRow <= 0) { result = "SELECT TOP " + maxRows + " " + result.substring(7); } else { final int offset = firstRow - 1; result = "SELECT LIMIT " + offset + " " + maxRows + " " + result.substring(7); } } return result; }
/** * {@inheritDoc} * * If the Max rows and/or First row property of the query is set, then we * will use the database's LIMIT and OFFSET functions. */ @Override public String rewriteQuery(Query query) { String queryString = super.rewriteQuery(query); Integer maxRows = query.getMaxRows(); Integer firstRow = query.getFirstRow(); if (maxRows != null || firstRow != null) { if (maxRows == null) { maxRows = Integer.MAX_VALUE; } queryString = queryString + " LIMIT " + maxRows; if (firstRow != null && firstRow > 1) { // offset is 0-based int offset = firstRow - 1; queryString = queryString + " OFFSET " + offset; } } return queryString; } }
/** * {@inheritDoc} * * If the Max rows and/or First row property of the query is set, then we * will use the database's LIMIT and OFFSET functions. */ @Override public String rewriteQuery(Query query) { String queryString = super.rewriteQuery(query); Integer maxRows = query.getMaxRows(); Integer firstRow = query.getFirstRow(); if (maxRows != null || firstRow != null) { if (maxRows == null) { maxRows = Integer.MAX_VALUE; } queryString = queryString + " LIMIT " + maxRows; if (firstRow != null && firstRow > 1) { // offset is 0-based int offset = firstRow - 1; queryString = queryString + " OFFSET " + offset; } } return queryString; } }
if (category == Category.VALID) { final Integer previousMaxRows = q.getMaxRows(); final Integer previousFirstRow = q.getFirstRow(); int newMaxRows = Math.min(previousMaxRows.intValue(), maxRows); if (previousFirstRow != null) { final Integer newFirstRow = q.getFirstRow(); final int maxWindowSizeFrombefore = previousFirstRow.intValue() + previousMaxRows.intValue() - newFirstRow;
|| query.getFirstRow() != null)) { final Integer maxRows = query.getMaxRows(); Integer firstRow = query.getFirstRow();
|| query.getFirstRow() != null)) { final Integer maxRows = query.getMaxRows(); Integer firstRow = query.getFirstRow();
final Integer firstRow = query.getFirstRow(); final Integer maxRows = query.getMaxRows(); if (maxRows != null && maxRows > 0) {
final Integer firstRow = query.getFirstRow(); final Integer maxRows = query.getMaxRows(); if (maxRows != null && maxRows > 0) {
int firstRow = (query.getFirstRow() == null ? 1 : query.getFirstRow()); int maxRows = (query.getMaxRows() == null ? -1 : query.getMaxRows());
int firstRow = (query.getFirstRow() == null ? 1 : query.getFirstRow()); int maxRows = (query.getMaxRows() == null ? -1 : query.getMaxRows()); boolean thereIsAtLeastOneAlias = false;
int firstRow = (query.getFirstRow() == null ? 1 : query.getFirstRow()); int maxRows = (query.getMaxRows() == null ? -1 : query.getMaxRows());
int firstRow = (query.getFirstRow() == null ? 1 : query.getFirstRow()); int maxRows = (query.getMaxRows() == null ? -1 : query.getMaxRows()); boolean thereIsAtLeastOneAlias = false;
if (finalQuery.getFirstRow() == null) { idGenerator = new SimpleRowIdGenerator(); } else { idGenerator = new SimpleRowIdGenerator(finalQuery.getFirstRow()); logger.debug("Final query firstRow={}, maxRows={}", finalQuery.getFirstRow(), finalQuery.getMaxRows());
@Override public final ConsumeRowHandler createConsumeRowHandler() { final RowProcessingQueryOptimizer queryOptimizer = getQueryOptimizer(); final Query finalQuery = queryOptimizer.getOptimizedQuery(); final RowIdGenerator idGenerator; if (finalQuery.getFirstRow() == null) { idGenerator = new SimpleRowIdGenerator(); } else { idGenerator = new SimpleRowIdGenerator(finalQuery.getFirstRow()); } final RowProcessingPublishers publishers = getPublishers(); final AnalysisListener analysisListener = publishers.getAnalysisListener(); for (final RowProcessingConsumer consumer : getConsumers()) { final ComponentJob componentJob = consumer.getComponentJob(); final ComponentMetrics metrics = new AnalysisJobMetricsImpl(consumer.getAnalysisJob(), publishers).getComponentMetrics(componentJob); analysisListener.componentBegin(getStream().getAnalysisJob(), componentJob, metrics); if (consumer instanceof TransformerConsumer) { ((TransformerConsumer) consumer).setRowIdGenerator(idGenerator); } } final List<RowProcessingConsumer> consumers = queryOptimizer.getOptimizedConsumers(); final Collection<? extends FilterOutcome> availableOutcomes = queryOptimizer.getOptimizedAvailableOutcomes(); return new ConsumeRowHandler(consumers, availableOutcomes); }
if (finalQuery.getFirstRow() == null) { idGenerator = new SimpleRowIdGenerator(); } else { idGenerator = new SimpleRowIdGenerator(finalQuery.getFirstRow()); logger.debug("Final query firstRow={}, maxRows={}", finalQuery.getFirstRow(), finalQuery.getMaxRows());
final List<OrderByItem> orderByItems = query.getOrderByClause().getItems(); final int firstRow = (query.getFirstRow() == null ? 1 : query.getFirstRow()); final int maxRows = (query.getMaxRows() == null ? -1 : query.getMaxRows());
@Override public String rewriteQuery(Query query) { final Integer firstRow = query.getFirstRow(); final Integer maxRows = query.getMaxRows();
@Override public String rewriteQuery(Query query) { final Integer firstRow = query.getFirstRow(); final Integer maxRows = query.getMaxRows();