if (plainSelect.getDistinct() != null) { buffer.append("DISTINCT "); if (plainSelect.getDistinct().getOnSelectItems() != null) { buffer.append("ON ("); for (Iterator iter = plainSelect.getDistinct().getOnSelectItems().iterator(); iter.hasNext();) { SelectItem selectItem = (SelectItem) iter.next(); selectItem.accept(this);
buffer.append("DISTINCT "); if (plainSelect.getDistinct().getOnSelectItems() != null) { buffer.append("ON ("); for (Iterator<SelectItem> iter = plainSelect.getDistinct().getOnSelectItems(). iterator(); iter.hasNext();) { SelectItem selectItem = iter.next();
/** * Handle use of the DISTINCT construct. The implementation logs and visits explicit expressions (itself) in the optional * ON(...) since they are not part of the select list. */ @SuppressWarnings("unchecked") protected void handleDistinct(Distinct distinct) { log.debug("handleDistinct: " + distinct); List<SelectItem> onSelectItems = distinct.getOnSelectItems(); if (onSelectItems != null) for (SelectItem si : onSelectItems) { if (si != null) si.accept(this.expressionNavigator); } }
@Override public void visit(PlainSelect plainSelect) { /* working with getProjection we visit the SelectItems and distinguish between select distinct, select distinct on, select all */ Distinct distinct = plainSelect.getDistinct(); if (distinct != null) { // for SELECT DISTINCT [ON (...)] if (distinct.getOnSelectItems() != null) { for(SelectItem item : distinct.getOnSelectItems()) item.accept(this); } } for (SelectItem item : plainSelect.getSelectItems()) item.accept(this); }
@Override public void visit(PlainSelect plainSelect) { // visit the SelectItems and distinguish between select distinct, // select distinct on, select all projection = new ProjectionJSQL(); Distinct distinct = plainSelect.getDistinct(); if (distinct != null) { // for SELECT DISTINCT [ON (...)] if (distinct.getOnSelectItems() != null) { bdistinctOn = true; for (SelectItem item : distinct.getOnSelectItems()) item.accept(this); bdistinctOn = false; } else projection.setType(ProjectionJSQL.SELECT_DISTINCT); } for (SelectItem item : plainSelect.getSelectItems()) item.accept(this); }
if (plainSelect.getDistinct() != null) { buffer.append("DISTINCT "); if (plainSelect.getDistinct().getOnSelectItems() != null) { buffer.append("ON ("); for (Iterator iter = plainSelect.getDistinct().getOnSelectItems().iterator(); iter.hasNext();) { SelectItem selectItem = (SelectItem) iter.next(); selectItem.accept(this);
if (plainSelect.getDistinct().getOnSelectItems() != null) { buffer.append("ON ("); for (Iterator iter = plainSelect.getDistinct().getOnSelectItems().iterator(); iter.hasNext();) { SelectItem selectItem = (SelectItem) iter.next(); selectItem.accept(this);
if (aPlainSelect.getDistinct().getOnSelectItems() != null) { buffer.append(aPlainSelect.getDistinct().getCommentOn() != null ? aPlainSelect.getDistinct().getCommentOn() + " " + ExpressionDeParser.LINE_SEPARATOR : "").append("on") .append(aPlainSelect.getDistinct().getCommentBeginBracket() != null ? " " + aPlainSelect.getDistinct().getCommentBeginBracket() + ExpressionDeParser.LINE_SEPARATOR : "").append(" ("); for (int i = 0; i < aPlainSelect.getDistinct().getOnSelectItems().size(); i++) { SelectItem selectItem = (SelectItem) aPlainSelect.getDistinct().getOnSelectItems().get(i); selectItem.accept(this); if (i < aPlainSelect.getDistinct().getOnSelectItems().size() - 1) { buffer.append(!"".equals(aPlainSelect.getDistinct().getCommentsComma().get(i)) ? " " + aPlainSelect.getDistinct().getCommentsComma().get(i) + ExpressionDeParser.LINE_SEPARATOR : "") .append(", ");
buffer.append("DISTINCT "); if (plainSelect.getDistinct().getOnSelectItems() != null) { buffer.append("ON ("); for (Iterator<SelectItem> iter = plainSelect.getDistinct().getOnSelectItems(). iterator(); iter.hasNext();) { SelectItem selectItem = iter.next();
@Override public void visit(PlainSelect plainSelect) { if (plainSelect.getDistinct() != null && plainSelect.getDistinct().getOnSelectItems() != null) { plainSelect.getDistinct().getOnSelectItems().forEach(s -> s.accept(this));