@Override public void visit(WithItem withItem) { otherItemNames.add(withItem.getName().toLowerCase()); withItem.getSelectBody().accept(this); }
@Override public void visit(WithItem withItem) { if (withItem.isRecursive()) { buffer.append("RECURSIVE "); } buffer.append(withItem.getName()); if (withItem.getWithItemList() != null) { buffer.append(" ").append(PlainSelect. getStringList(withItem.getWithItemList(), true, true)); } buffer.append(" AS ("); withItem.getSelectBody().accept(this); buffer.append(")"); }
@Override public void visit(WithItem withItem) { otherItemNames.add(withItem.getName().toLowerCase()); withItem.getSelectBody().accept(this); }
@Override public void visit(WithItem withItem) { withTCEs.add(withItem.getName().toLowerCase()); withItem.getSelectBody().accept(this); } };
@Override public void visit(WithItem withItem) { withTCEs.add(withItem.getName().toLowerCase()); withItem.getSelectBody().accept(this); } };
@Override public void visit(WithItem withItem) { withTCEs.add(withItem.getName().toLowerCase()); withItem.getSelectBody().accept(this); } };
@Override public void visit(WithItem withItem) { if (withItem.isRecursive()) { buffer.append("RECURSIVE "); } buffer.append(withItem.getName()); if (withItem.getWithItemList() != null) { buffer.append(" ").append(PlainSelect. getStringList(withItem.getWithItemList(), true, true)); } buffer.append(" AS ("); withItem.getSelectBody().accept(this); buffer.append(")"); }
@Override public void visit(WithItem withItem) throws Exception { // TODO: Redo this later. What's withItem list. // Add with name here. if (withItem.getName() != null) { this.withTableNameList.add(withItem.getName()); } withItem.getSelectBody().accept(this); if (withItem.getWithItemList() != null) { for (SelectItem selectItem : withItem.getWithItemList()) { selectItem.accept(this); } } }
SelectBody body = select.getSelectBody(); for (WithItem item: withItems) { cteName2Def.put(item.getName(), item.getSelectBody());