protected void visitAggreateRest(SQLAggregateExpr x) { SQLOrderBy orderBy = x.getWithinGroup(); if (orderBy != null) { print(' '); orderBy.accept(this); } } }
static void resolve(SchemaResolveVisitor visitor, SQLOver x) { SQLName of = x.getOf(); SQLOrderBy orderBy = x.getOrderBy(); List<SQLExpr> partitionBy = x.getPartitionBy(); if (of == null // skip if of is not null && orderBy != null) { orderBy.accept(visitor); } if (partitionBy != null) { for (SQLExpr expr : partitionBy) { expr.accept(visitor); } } }
public boolean visit(SQLOver x) { SQLName of = x.getOf(); SQLOrderBy orderBy = x.getOrderBy(); List<SQLExpr> partitionBy = x.getPartitionBy(); if (of == null // skip if of is not null && orderBy != null) { orderBy.accept(this); } if (partitionBy != null) { for (SQLExpr expr : partitionBy) { expr.accept(this); } } return false; }
@Override public boolean visit(SQLKeep x) { if (x.getDenseRank() == SQLKeep.DenseRank.FIRST) { print0(ucase ? "KEEP (DENSE_RANK FIRST " : "keep (dense_rank first "); } else { print0(ucase ? "KEEP (DENSE_RANK LAST " : "keep (dense_rank last "); } x.getOrderBy().accept(this); print(')'); return false; }
public boolean visit(SQLOrderBy x) { final SQLASTVisitor orderByVisitor = createOrderByVisitor(x); SQLSelectQueryBlock query = null; if (x.getParent() instanceof SQLSelectQueryBlock) { query = (SQLSelectQueryBlock) x.getParent(); } if (query != null) { for (SQLSelectOrderByItem item : x.getItems()) { SQLExpr expr = item.getExpr(); if (expr instanceof SQLIntegerExpr) { int intValue = ((SQLIntegerExpr) expr).getNumber().intValue() - 1; if (intValue < query.getSelectList().size()) { SQLSelectItem selectItem = query.getSelectList().get(intValue); selectItem.getExpr().accept(orderByVisitor); } } else if (expr instanceof MySqlExpr || expr instanceof OracleExpr) { continue; } } } x.accept(orderByVisitor); for (SQLSelectOrderByItem orderByItem : x.getItems()) { statExpr( orderByItem.getExpr()); } return false; }
public boolean visit(SQLSelect x) { SQLWithSubqueryClause withSubQuery = x.getWithSubQuery(); if (withSubQuery != null) { withSubQuery.accept(this); println(); } printQuery(x.getQuery()); SQLOrderBy orderBy = x.getOrderBy(); if (orderBy != null) { println(); orderBy.accept(this); } if (x.getHintsSize() > 0) { printAndAccept(x.getHints(), ""); } return false; }
@Override public boolean visit(ModelClause.CellAssignmentItem x) { if (x.getOption() != null) { print0(x.getOption().name); print(' '); } x.getCellAssignment().accept(this); if (x.getOrderBy() != null) { print(' '); x.getOrderBy().accept(this); } print0(" = "); x.getExpr().accept(this); return false; }
@Override public boolean visit(CellAssignmentItem x) { if (x.getOption() != null) { print0(x.getOption().name); print(' '); } x.getCellAssignment().accept(this); if (x.getOrderBy() != null) { print(' '); x.getOrderBy().accept(this); } print0(" = "); x.getExpr().accept(this); return false; }
public boolean visit(SQLSelect x) { SQLWithSubqueryClause with = x.getWithSubQuery(); if (with != null) { with.accept(this); println(); } SQLSelectQuery query = x.getQuery(); query.accept(this); if (x.getRestriction() != null) { println(); print("WITH "); x.getRestriction().accept(this); } SQLOrderBy orderBy = x.getOrderBy(); if (orderBy != null) { boolean hasFirst = false; if (query instanceof SQLSelectQueryBlock) { SQLSelectQueryBlock queryBlock = (SQLSelectQueryBlock) query; hasFirst = queryBlock.getFirst() != null; } if (!hasFirst) { println(); orderBy.accept(this); } } return false; }
orderBy.accept(this);
if (orderBy != null) { println(); orderBy.accept(this);
orderBy.accept(visitor);
x.getOrderBy().accept(this);
protected void visitAggreateRest(SQLAggregateExpr x) { SQLOrderBy orderBy = x.getWithinGroup(); if (orderBy != null) { print(' '); orderBy.accept(this); } } }
x.getOrderBy().accept(this);
x.getOrderBy().accept(this);
x.getOrderBy().accept(this);
@Override public boolean visit(SQLKeep x) { if (x.getDenseRank() == SQLKeep.DenseRank.FIRST) { print0(ucase ? "KEEP (DENSE_RANK FIRST " : "keep (dense_rank first "); } else { print0(ucase ? "KEEP (DENSE_RANK LAST " : "keep (dense_rank last "); } x.getOrderBy().accept(this); print(')'); return false; }
if (orderBy != null) { println(); orderBy.accept(this);
if (orderBy != null) { println(); orderBy.accept(this);