public SQLOver clone() { SQLOver x = new SQLOver(); cloneTo(x); return x; }
protected void over(SQLAggregateExpr aggregateExpr) { lexer.nextToken(); if (lexer.token != Token.LPAREN) { SQLName overRef = this.name(); aggregateExpr.setOverRef(overRef); return; } SQLOver over = new SQLOver(); over(over); aggregateExpr.setOver(over); }
protected void parseWindow(SQLSelectQueryBlock queryBlock) { if (!(lexer.identifierEquals(FnvHash.Constants.WINDOW) || lexer.token == Token.WINDOW)) { return; } lexer.nextToken(); for (;;) { SQLName name = this.exprParser.name(); accept(Token.AS); SQLOver over = new SQLOver(); this.exprParser.over(over); queryBlock.addWindow(new SQLWindow(name, over)); if (lexer.token == Token.COMMA) { lexer.nextToken(); continue; } break; } }
aggregateExpr.setOver(new SQLOver(orderBy)); SQLAggregateExpr aggregateExpr = new SQLAggregateExpr("ROW_NUMBER"); SQLOrderBy orderBy = select.getOrderBy(); aggregateExpr.setOver(new SQLOver(orderBy)); select.setOrderBy(null); countQueryBlock.getSelectList().add(new SQLSelectItem(aggregateExpr, "ROWNUM"));
public SQLOver clone() { SQLOver x = new SQLOver(); cloneTo(x); return x; }
protected void over(SQLAggregateExpr aggregateExpr) { lexer.nextToken(); if (lexer.token != Token.LPAREN) { SQLName overRef = this.name(); aggregateExpr.setOverRef(overRef); return; } SQLOver over = new SQLOver(); over(over); aggregateExpr.setOver(over); }
protected void parseWindow(SQLSelectQueryBlock queryBlock) { if (!(lexer.identifierEquals(FnvHash.Constants.WINDOW) || lexer.token == Token.WINDOW)) { return; } lexer.nextToken(); for (;;) { SQLName name = this.exprParser.name(); accept(Token.AS); SQLOver over = new SQLOver(); this.exprParser.over(over); queryBlock.addWindow(new SQLWindow(name, over)); if (lexer.token == Token.COMMA) { lexer.nextToken(); continue; } break; } }
aggregateExpr.setOver(new SQLOver(orderBy)); SQLAggregateExpr aggregateExpr = new SQLAggregateExpr("ROW_NUMBER"); SQLOrderBy orderBy = select.getOrderBy(); aggregateExpr.setOver(new SQLOver(orderBy)); select.setOrderBy(null); countQueryBlock.getSelectList().add(new SQLSelectItem(aggregateExpr, "ROWNUM"));