@Override public void visit(DerivedTable obj) { if (visitSubcommands) { visitNode(obj.getQuery()); } }
@Override public void visit(DerivedTable obj) { buffer.append(Tokens.LPAREN); append(obj.getQuery()); buffer.append(Tokens.RPAREN); buffer.append(Tokens.SPACE); if(useAsInGroupAlias()) { buffer.append(AS); buffer.append(Tokens.SPACE); } buffer.append(obj.getCorrelationName()); }
public void visit(DerivedTable obj) { if (obj.isLateral()) { appendLateralKeyword(); buffer.append(Tokens.SPACE); } buffer.append(Tokens.LPAREN); append(obj.getQuery()); buffer.append(Tokens.RPAREN); buffer.append(Tokens.SPACE); if(useAsInGroupAlias()) { buffer.append(AS); buffer.append(Tokens.SPACE); } buffer.append(obj.getCorrelationName()); }
public void testGetQuery() throws Exception { assertEquals("SELECT DISTINCT g1.e1, g1.e2, g1.e3, g1.e4 FROM g1, g2 AS myAlias, g3, g4 WHERE 100 >= 200 AND 500 < 600 GROUP BY g1.e1, g1.e2, g1.e3, g1.e4 HAVING 100 >= 200 AND 500 < 600 ORDER BY g1.e1, g1.e2 DESC, g1.e3, g1.e4 DESC", example().getQuery().toString()); //$NON-NLS-1$ }