case K_DISTINCT: jj_consume_token(K_DISTINCT); Distinct distinct = new Distinct(); plainSelect.setDistinct(distinct); switch ((jj_ntk==-1)?jj_ntk():jj_ntk) { case K_ON:
Distinct distinct = new Distinct(); plainSelect.setDistinct(distinct); switch ((jj_ntk==-1)?jj_ntk_f():jj_ntk) { case K_ON:{ Distinct distinct = new Distinct(true); plainSelect.setDistinct(distinct); break;
/** The query for obtaining values of parameters is almost the same with the original source query, except that we only need to distinct project the columns needed for the template expansion */ private static String getTemplateValuesQuery(String sql, List<SelectExpressionItem> templateColumns) throws JSQLParserException { Select select = (Select)CCJSqlParserUtil.parse(sql); PlainSelect plainSelect = (PlainSelect)select.getSelectBody(); plainSelect.setDistinct(new Distinct()); plainSelect.setSelectItems(ImmutableList.copyOf(templateColumns)); // SelectExpressionItem -> SelectItem return select.toString(); }
/** The query for obtaining values of parameters is almost the same with the original source query, except that we only need to distinct project the columns needed for the template expansion */ private static String getTemplateValuesQuery(String sql, List<SelectExpressionItem> templateColumns) throws JSQLParserException { Select select = (Select)CCJSqlParserUtil.parse(sql); PlainSelect plainSelect = (PlainSelect)select.getSelectBody(); plainSelect.setDistinct(new Distinct()); plainSelect.setSelectItems(ImmutableList.copyOf(templateColumns)); // SelectExpressionItem -> SelectItem return select.toString(); }
@Override public void visit(PlainSelect plainSelect) { if (proj.getType().equals("select distinct on")) { List<SelectItem> distinctList = new ArrayList<>(); for (SelectExpressionItem seItem : proj.getColumnList()) distinctList.add(seItem); Distinct distinct = new Distinct(); distinct.setOnSelectItems(distinctList); plainSelect.setDistinct(distinct); } else if (proj.getType().equals("select distinct")) { Distinct distinct = new Distinct(); plainSelect.setDistinct(distinct); plainSelect.getSelectItems().clear(); plainSelect.getSelectItems().addAll(proj.getColumnList()); } else { plainSelect.getSelectItems().clear(); List<SelectExpressionItem> columnList = proj.getColumnList(); if (!columnList.isEmpty()) { plainSelect.getSelectItems().addAll(columnList); } else { plainSelect.getSelectItems().add(new AllColumns()); } } }
Distinct distinct = new Distinct(); plainSelect.setDistinct(distinct); if (tk.specialToken != null) { distinct.setComment(tk.specialToken.image);
Distinct distinct = new Distinct(); plainSelect.setDistinct(distinct); switch ((jj_ntk==-1)?jj_ntk_f():jj_ntk) { case K_ON:{
Distinct distinct = new Distinct(); plainSelect.setDistinct(distinct); switch ((jj_ntk==-1)?jj_ntk_f():jj_ntk) { case K_ON:{ Distinct distinct = new Distinct(true); plainSelect.setDistinct(distinct); break;