Examples of AliasSymbol

com.odiago.flumebase.exec.AliasSymbol
A symbol which refers to another existing symbol. This allows a symbol to be referenced by a different name by the user. For example, in the context of "SELECT x FROM s", the field may be referenced as 'x' (the primary symbol), or also 's.x' (the alias).
org.teiid.query.sql.symbol.AliasSymbol
An AliasSymbol wraps a SingleElementSymbol and changes it's name. AliasSymbols should be used to perform the aliasing of elements in a SELECT clause. They should typically NOT be used elsewhere in a query. The alias symbol takes on the type of it's underlying SingleElementSymbol. AliasSymbols are typically applied to ElementSymbol, ExpressionSymbol, and AggregateSymbol.

Examples of org.teiid.query.sql.symbol.AliasSymbol

        from.addGroup(g);


        Function f = new Function("timestampadd", new Expression[] { //$NON-NLS-1$
            new Constant("SQL_TSI_DAY"), new Constant(new Integer(10)), new Constant("2003-05-01 10:20:30")}); //$NON-NLS-1$ //$NON-NLS-2$
        ExpressionSymbol es = new ExpressionSymbol("expr", f); //$NON-NLS-1$
        AliasSymbol as = new AliasSymbol("x", es); //$NON-NLS-1$
        Select select = new Select();
        select.addSymbol(as);


        Query query = new Query();
        query.setSelect(select);

View Full Code Here

Examples of org.teiid.query.sql.symbol.AliasSymbol

        from.addGroup(g);


        Function f = new Function("timestampadd", new Expression[] { //$NON-NLS-1$
            new Constant("SQL_TSI_WEEK"), new Constant(new Integer(10)), new Constant("2003-05-01 10:20:30")}); //$NON-NLS-1$ //$NON-NLS-2$
        ExpressionSymbol es = new ExpressionSymbol("expr", f); //$NON-NLS-1$
        AliasSymbol as = new AliasSymbol("x", es); //$NON-NLS-1$
        Select select = new Select();
        select.addSymbol(as);


        Query query = new Query();
        query.setSelect(select);

View Full Code Here

Examples of org.teiid.query.sql.symbol.AliasSymbol

        from.addGroup(g);


        Function f = new Function("timestampadd", new Expression[] { //$NON-NLS-1$
            new Constant("SQL_TSI_QUARTER"), new Constant(new Integer(10)), new Constant("2003-05-01 10:20:30")}); //$NON-NLS-1$ //$NON-NLS-2$
        ExpressionSymbol es = new ExpressionSymbol("expr", f); //$NON-NLS-1$
        AliasSymbol as = new AliasSymbol("x", es); //$NON-NLS-1$
        Select select = new Select();
        select.addSymbol(as);


        Query query = new Query();
        query.setSelect(select);

View Full Code Here

Examples of org.teiid.query.sql.symbol.AliasSymbol

        from.addGroup(g);


        Function f = new Function("timestampadd", new Expression[] { //$NON-NLS-1$
            new Constant("SQL_TSI_YEAR"), new Constant(new Integer(10)), new Constant("2003-05-01 10:20:30")}); //$NON-NLS-1$ //$NON-NLS-2$
        ExpressionSymbol es = new ExpressionSymbol("expr", f); //$NON-NLS-1$
        AliasSymbol as = new AliasSymbol("x", es); //$NON-NLS-1$
        Select select = new Select();
        select.addSymbol(as);


        Query query = new Query();
        query.setSelect(select);

View Full Code Here

Examples of org.teiid.query.sql.symbol.AliasSymbol

        from.addGroup(g);


        Function f = new Function("timestampdiff", new Expression[] { //$NON-NLS-1$
            new Constant("SQL_TSI_FRAC_SECOND"), new Constant("2003-05-01 10:20:10"), new Constant("2003-05-01 10:20:30")}); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
        ExpressionSymbol es = new ExpressionSymbol("expr", f); //$NON-NLS-1$
        AliasSymbol as = new AliasSymbol("x", es); //$NON-NLS-1$
        Select select = new Select();
        select.addSymbol(as);


        Query query = new Query();
        query.setSelect(select);

View Full Code Here

Examples of org.teiid.query.sql.symbol.AliasSymbol

    GroupSymbol g = new GroupSymbol("m.g"); //$NON-NLS-1$
    From from = new From();
    from.addGroup(g);


    Select select = new Select();
    select.addSymbol(new AliasSymbol("c",  //$NON-NLS-1$
      new AggregateSymbol("c", "COUNT", false, new ElementSymbol("a", false)))); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
    
        
    Query query = new Query();
    query.setSelect(select);

View Full Code Here

Examples of org.teiid.query.sql.symbol.AliasSymbol

        GroupSymbol g = new GroupSymbol("m.g"); //$NON-NLS-1$
        From from = new From();
        from.addGroup(g);


        Select select = new Select();
        select.addSymbol(new AliasSymbol("c",  //$NON-NLS-1$
            new AggregateSymbol("c", "COUNT", false, new ElementSymbol("a", false)))); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
        
                
        Query query = new Query();
        query.setSelect(select);

View Full Code Here

Examples of org.teiid.query.sql.symbol.AliasSymbol

        Select select = new Select();
        AggregateSymbol agg1 = new AggregateSymbol("count", "COUNT", false, new ElementSymbol("a", false)); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
        AggregateSymbol agg2 = new AggregateSymbol("sum", "SUM", false, new ElementSymbol("a", false)); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
        Function f = new Function("*", new Expression[] { agg1, agg2 }); //$NON-NLS-1$
        ExpressionSymbol expr = new ExpressionSymbol("expr", f); //$NON-NLS-1$
        AliasSymbol alias = new AliasSymbol("c", expr); //$NON-NLS-1$
        select.addSymbol(alias);        
                
        Query query = new Query();
        query.setSelect(select);
        query.setFrom(from);

View Full Code Here

Examples of org.teiid.query.sql.symbol.AliasSymbol

  @Test public void testAliasInSelect(){
    GroupSymbol g = new GroupSymbol("g"); //$NON-NLS-1$
    From from = new From();
    from.addGroup(g);


    AliasSymbol as = new AliasSymbol("myA", new ElementSymbol("a")); //$NON-NLS-1$ //$NON-NLS-2$
    Select select = new Select();
    select.addSymbol(as);
    select.addSymbol(new ElementSymbol("b")); //$NON-NLS-1$


    Query query = new Query();

View Full Code Here

Examples of org.teiid.query.sql.symbol.AliasSymbol

    GroupSymbol h = new GroupSymbol("h"); //$NON-NLS-1$
    From from = new From();
    from.addGroup(g);
    from.addGroup(h);


    AliasSymbol as = new AliasSymbol("myA", new ElementSymbol("a")); //$NON-NLS-1$ //$NON-NLS-2$
    Select select = new Select();
    select.addSymbol(as);
    select.addSymbol(new ElementSymbol("b")); //$NON-NLS-1$


    Query query = new Query();

View Full Code Here

0 1 2 3 4 5

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.