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

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.

    crits.add(jcrit);    
    JoinPredicate jp = new JoinPredicate(g, h, JoinType.JOIN_RIGHT_OUTER, crits);
    From from = new From();
    from.addClause(jp);


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


    Query query = new Query();

View Full Code Here

    crits.add(jcrit);    
    JoinPredicate jp = new JoinPredicate(g, h, JoinType.JOIN_RIGHT_OUTER, crits);
    From from = new From();
    from.addClause(jp);


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


    Query query = new Query();

View Full Code Here

    crits.add(jcrit);    
    JoinPredicate jp = new JoinPredicate(g, h, JoinType.JOIN_LEFT_OUTER, crits);
    From from = new From();
    from.addClause(jp);


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


    Query query = new Query();

View Full Code Here

    crits.add(jcrit);    
    JoinPredicate jp = new JoinPredicate(g, h, JoinType.JOIN_LEFT_OUTER, crits);
    From from = new From();
    from.addClause(jp);


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


    Query query = new Query();

View Full Code Here

    crits.add(jcrit);    
    JoinPredicate jp = new JoinPredicate(g, h, JoinType.JOIN_FULL_OUTER, crits);
    From from = new From();
    from.addClause(jp);


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


    Query query = new Query();

View Full Code Here

    From from = new From();
    from.addGroup(g);


    Function f = new Function("replace", new Expression[] {new ElementSymbol("a", false), new Constant("x"), new Constant("y")}); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ //$NON-NLS-4$
    ExpressionSymbol es = new ExpressionSymbol("y", f); //$NON-NLS-1$
    AliasSymbol as = new AliasSymbol("y", es); //$NON-NLS-1$
    Select select = new Select();
    select.addSymbol(as);


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

View Full Code Here

        From from = new From();
        from.addGroup(g);


        Function f = new Function("left", new Expression[] {new ElementSymbol("fullname", false), new Constant(new Integer(3))}); //$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

        From from = new From();
        from.addGroup(g);


        Function f = new Function("right", new Expression[] {new ElementSymbol("fullname", false), new Constant(new Integer(3))}); //$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

        From from = new From();
        from.addGroup(g);


        Function f = new Function("char", new Expression[] { new Constant("x")}); //$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

        From from = new From();
        from.addGroup(g);


        Function f = new Function("insert", new Expression[] { new Constant("x"), new Constant(new Integer(1)), new Constant("a")}); //$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

0 1 2 3 4 5 6

TOP

Related Classes of org.teiid.query.sql.symbol.AliasSymbol

org.teiid.query.metadata.TempMetadataStore

org.teiid.query.optimizer.relational.AliasGenerator

org.teiid.query.optimizer.relational.rules.RulePushAggregates

org.teiid.query.optimizer.relational.rules.RuleRaiseNull

org.teiid.query.optimizer.xml.SourceNodePlannerVisitor

org.teiid.query.parser.TestParser

org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor

org.teiid.query.rewriter.QueryRewriter

org.teiid.query.sql.lang.SetQuery

org.teiid.query.sql.lang.TestAliasSymbol

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.