/** * Return a deep copy of this Select. * @return Deep clone */ public Select clone() { Select copy = new Select(LanguageObject.Util.deepClone(this.symbols, Expression.class)); copy.setDistinct( isDistinct() ); return copy; }
/** * Return a deep copy of this Select. * @return Deep clone */ public Select clone() { Select copy = new Select(LanguageObject.Util.deepClone(this.symbols, Expression.class)); copy.setDistinct( isDistinct() ); return copy; }
/** * Return a deep copy of this Select. * @return Deep clone */ public Select clone() { Select copy = new Select(LanguageObject.Util.deepClone(this.symbols, Expression.class)); copy.setDistinct( isDistinct() ); return copy; }
private Query rewriteGroupBy(Query query) throws TeiidComponentException, TeiidProcessingException { if (query.getGroupBy() == null) { rewriteAggs = false; return query; } if (isDistinctWithGroupBy(query)) { query.getSelect().setDistinct(false); } rewriteExpressions(query.getGroupBy()); List<Expression> expr = query.getGroupBy().getSymbols(); for (Iterator<Expression> iter = expr.iterator(); iter.hasNext();) { if (EvaluatableVisitor.willBecomeConstant(iter.next())) { iter.remove(); } } if (expr.isEmpty()) { query.setGroupBy(null); } return query; }
private Query rewriteGroupBy(Query query) throws TeiidComponentException, TeiidProcessingException { if (query.getGroupBy() == null) { rewriteAggs = false; return query; } if (isDistinctWithGroupBy(query)) { query.getSelect().setDistinct(false); } rewriteExpressions(query.getGroupBy()); List<Expression> expr = query.getGroupBy().getSymbols(); for (Iterator<Expression> iter = expr.iterator(); iter.hasNext();) { if (EvaluatableVisitor.willBecomeConstant(iter.next())) { iter.remove(); } } if (expr.isEmpty()) { query.setGroupBy(null); } return query; }
private Query rewriteGroupBy(Query query) throws TeiidComponentException, TeiidProcessingException { if (query.getGroupBy() == null) { rewriteAggs = false; return query; } if (isDistinctWithGroupBy(query)) { query.getSelect().setDistinct(false); } rewriteExpressions(query.getGroupBy()); List<Expression> expr = query.getGroupBy().getSymbols(); for (Iterator<Expression> iter = expr.iterator(); iter.hasNext();) { if (EvaluatableVisitor.willBecomeConstant(iter.next())) { iter.remove(); } } if (expr.isEmpty()) { query.setGroupBy(null); } return query; }
public static org.teiid.query.sql.lang.Select helpExampleSelect(boolean distinct) { ArrayList<ElementSymbol> symbols = new ArrayList<ElementSymbol>(); symbols.add(TestElementImpl.helpExample("vm1.g1", "e1")); //$NON-NLS-1$ //$NON-NLS-2$ symbols.add(TestElementImpl.helpExample("vm1.g1", "e2")); //$NON-NLS-1$ //$NON-NLS-2$ symbols.add(TestElementImpl.helpExample("vm1.g1", "e3")); //$NON-NLS-1$ //$NON-NLS-2$ symbols.add(TestElementImpl.helpExample("vm1.g1", "e4")); //$NON-NLS-1$ //$NON-NLS-2$ org.teiid.query.sql.lang.Select sel = new org.teiid.query.sql.lang.Select(symbols); sel.setDistinct(distinct); return sel; }
@Test public void testSelect2() { Select select = new Select(); select.setDistinct(true); select.addSymbol(new ElementSymbol("e1")); //$NON-NLS-1$ helpTest(select, " DISTINCT e1"); //$NON-NLS-1$ }
return false; plannedResult.query.getSelect().setDistinct(true); plannedResult.madeDistinct = true;
return false; plannedResult.query.getSelect().setDistinct(true); plannedResult.madeDistinct = true;
return false; plannedResult.query.getSelect().setDistinct(true); plannedResult.madeDistinct = true;
transformationQuery.getSelect().setDistinct(false); baseQuery.getSelect().setDistinct(true);
/** SELECT DISTINCT a FROM g */ @Test public void testSelectDistinct(){ GroupSymbol g = new GroupSymbol("g"); //$NON-NLS-1$ From from = new From(); from.addGroup(g); Select select = new Select(); select.addSymbol(new ElementSymbol("a")); //$NON-NLS-1$ select.setDistinct(true); Query query = new Query(); query.setSelect(select); query.setFrom(from); helpTest("SELECT DISTINCT a FROM g", //$NON-NLS-1$ "SELECT DISTINCT a FROM g", //$NON-NLS-1$ query); }
/** SELECT ALL a FROM g */ @Test public void testSelectAll(){ GroupSymbol g = new GroupSymbol("g"); //$NON-NLS-1$ From from = new From(); from.addGroup(g); Select select = new Select(); select.addSymbol(new ElementSymbol("a")); //$NON-NLS-1$ select.setDistinct(false); Query query = new Query(); query.setSelect(select); query.setFrom(from); helpTest("SELECT ALL a FROM g", //$NON-NLS-1$ "SELECT a FROM g", //$NON-NLS-1$ query); }
currentQuery.getSelect().setDistinct(true);
ex = SymbolMap.getExpression(ex); select.setSymbols(Arrays.asList(new AggregateSymbol(type.name(), false, ex))); select.setDistinct(false);
ex = SymbolMap.getExpression(ex); select.setSymbols(Arrays.asList(new AggregateSymbol(type.name(), false, ex))); select.setDistinct(false);
ex = SymbolMap.getExpression(ex); select.setSymbols(Arrays.asList(new AggregateSymbol(type.name(), false, ex))); select.setDistinct(false);
((Query)queryCommand).getSelect().setDistinct(true);
((Query)queryCommand).getSelect().setDistinct(true);