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.

    public void testSetQueryUnionOfLiteralsCase3102() {
        
        String expected = "SELECT 'A' AS FOO UNION SELECT 'B' AS FOO"; //$NON-NLS-1$
        
        Select s1 = new Select();
        s1.addSymbol(new AliasSymbol("FOO", new ExpressionSymbol("xxx", new Constant("A")))); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
        Query q1 = new Query();
        q1.setSelect(s1);


        Select s2 = new Select();
        s2.addSymbol(new AliasSymbol("FOO", new ExpressionSymbol("xxx", new Constant("B")))); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
        Query q2 = new Query();
        q2.setSelect(s2);
        
        SetQuery sq = new SetQuery(Operation.UNION, false, q1, q2);

View Full Code Here

    public void testSetQueryUnionOfLiteralsCase3102a() {
        
        String expected = "SELECT 'A' AS FOO UNION SELECT 'B' AS FOO"; //$NON-NLS-1$
        
        Select s1 = new Select();
        s1.addSymbol(new AliasSymbol("FOO", new ExpressionSymbol("xxx", new Constant("A")))); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
        Query q1 = new Query();
        q1.setSelect(s1);


        Select s2 = new Select();
        s2.addSymbol(new AliasSymbol("FOO", new ExpressionSymbol("yyy", new Constant("B")))); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
        Query q2 = new Query();
        q2.setSelect(s2);
        
        SetQuery sq = new SetQuery(Operation.UNION, false, q1, q2);

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.