Examples of org.teiid.query.sql.lang.SubqueryFromClause

org.teiid.query.sql.lang.SubqueryFromClause
A FROM subpart that represents a subquery. For example, the FROM clause: "FROM (SELECT a FROM b)" will have a SubqueryFromClause referencing the subquery.

        String sql = "SELECT * from TABLE(exec foo()) as x"; //$NON-NLS-1$
        Query query = new Query();
        query.setSelect(new Select(Arrays.asList(new AllSymbol())));
        StoredProcedure sp = new StoredProcedure();
        sp.setProcedureName("foo");
        SubqueryFromClause sfc = new SubqueryFromClause("x", sp);
        sfc.setTable(true);
        query.setFrom(new From(Arrays.asList(sfc)));
        helpTest(sql, "SELECT * FROM TABLE(EXEC foo()) AS x", query);
    }

View Full Code Here

        f1.addGroup(new GroupSymbol("m.g1"));        //$NON-NLS-1$
        Query q1 = new Query();
        q1.setSelect(s1);
        q1.setFrom(f1);


        SubqueryFromClause sfc = new SubqueryFromClause("temp", q1); //$NON-NLS-1$
        helpTest(sfc, "(SELECT e1 FROM m.g1) AS temp");             //$NON-NLS-1$
    }

View Full Code Here

        f1.addGroup(new GroupSymbol("m.g1"));        //$NON-NLS-1$
        Query q1 = new Query();
        q1.setSelect(s1);
        q1.setFrom(f1);


        SubqueryFromClause sfc = new SubqueryFromClause("temp", q1); //$NON-NLS-1$
        sfc.setOptional(true);
        helpTest(sfc, "/*+ optional */ (SELECT e1 FROM m.g1) AS temp");             //$NON-NLS-1$
    }

View Full Code Here

        crit.setLeftExpression(new ElementSymbol("a")); //$NON-NLS-1$
        crit.setRightExpression(new Constant(new Integer(5)));
        crit.setOperator(CompareCriteria.EQ);
        query.setCriteria(crit);
        
        return new SubqueryFromClause("temp", query); //$NON-NLS-1$
    }

View Full Code Here

        crit.setLeftExpression(new ElementSymbol("c")); //$NON-NLS-1$
        crit.setRightExpression(new Constant(new Integer(10)));
        crit.setOperator(CompareCriteria.EQ);
        query.setCriteria(crit);
        
        return new SubqueryFromClause("temp", query); //$NON-NLS-1$
    }

View Full Code Here

        crit.setLeftExpression(new ElementSymbol("a")); //$NON-NLS-1$
        crit.setRightExpression(new Constant(new Integer(5)));
        crit.setOperator(CompareCriteria.EQ);
        query.setCriteria(crit);
        
        return new SubqueryFromClause("temp2", query); //$NON-NLS-1$
    }

View Full Code Here

        UnitTestUtil.helpTestEquivalence(equals, s1, s2);
    }
    
    public void testEquivalenceDifferentOptional(){
        Object s1 = example1();
        SubqueryFromClause s2 = example1();
        s2.setOptional(true);
        int equals = -1;
        UnitTestUtil.helpTestEquivalence(equals, s1, s2);
    }

View Full Code Here

        int equals = -1;
        UnitTestUtil.helpTestEquivalence(equals, s1, s2);
    }
    
    public void testClone() {
        SubqueryFromClause s1 = example1();
        Object clonedS1 = s1.clone();
        assertEquals(s1, clonedS1);
    }

View Full Code Here

0 1 2

TOP

Related Classes of org.teiid.query.sql.lang.SubqueryFromClause

org.teiid.dqp.internal.datamgr.TestInlineViewImpl

org.teiid.query.optimizer.relational.RelationalPlanner

org.teiid.query.optimizer.relational.rules.RuleCollapseSource

org.teiid.query.optimizer.xml.SourceNodePlannerVisitor

org.teiid.query.optimizer.xml.XMLQueryPlanner

org.teiid.query.parser.TestOptionsAndHints

org.teiid.query.parser.TestParser

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

org.teiid.query.resolver.TestResolver

org.teiid.query.rewriter.QueryRewriter

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.