/** * Fill in missing bounds. Default bounds are "BETWEEN UNBOUNDED PRECEDING * AND CURRENT ROW" when ORDER BY present and "BETWEEN UNBOUNDED PRECEDING * AND UNBOUNDED FOLLOWING" when no ORDER BY present. */ public void populateBounds() { if (lowerBound == null && upperBound == null) { setLowerBound( SqlWindow.createUnboundedPreceding(getParserPosition())); } if (lowerBound == null) { setLowerBound( SqlWindow.createCurrentRow(getParserPosition())); } if (upperBound == null) { SqlParserPos pos = orderList.getParserPosition(); setUpperBound( orderList.size() == 0 ? SqlWindow.createUnboundedFollowing(pos) : SqlWindow.createCurrentRow(pos)); } }
/** * Fill in missing bounds. Default bounds are "BETWEEN UNBOUNDED PRECEDING * AND CURRENT ROW" when ORDER BY present and "BETWEEN UNBOUNDED PRECEDING * AND UNBOUNDED FOLLOWING" when no ORDER BY present. */ public void populateBounds() { if (lowerBound == null && upperBound == null) { setLowerBound( SqlWindow.createUnboundedPreceding(getParserPosition())); } if (lowerBound == null) { setLowerBound( SqlWindow.createCurrentRow(getParserPosition())); } if (upperBound == null) { SqlParserPos pos = orderList.getParserPosition(); setUpperBound( orderList.size() == 0 ? SqlWindow.createUnboundedFollowing(pos) : SqlWindow.createCurrentRow(pos)); } }
window.setLowerBound(SqlWindow.createUnboundedPreceding(SqlParserPos.ZERO)); window.setUpperBound(SqlWindow.createCurrentRow(SqlParserPos.ZERO)); window.setRows(SqlLiteral.createBoolean(true, SqlParserPos.ZERO));
window.setLowerBound(SqlWindow.createUnboundedPreceding(SqlParserPos.ZERO)); window.setUpperBound(SqlWindow.createCurrentRow(SqlParserPos.ZERO)); window.setRows(SqlLiteral.createBoolean(true, SqlParserPos.ZERO));
window.setLowerBound(SqlWindow.createUnboundedPreceding(SqlParserPos.ZERO)); window.setUpperBound(SqlWindow.createCurrentRow(SqlParserPos.ZERO)); window.setRows(SqlLiteral.createBoolean(true, SqlParserPos.ZERO));
window.setLowerBound(SqlWindow.createUnboundedPreceding(SqlParserPos.ZERO)); window.setUpperBound(SqlWindow.createCurrentRow(SqlParserPos.ZERO)); window.setRows(SqlLiteral.createBoolean(true, SqlParserPos.ZERO));