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

org.teiid.query.sql.lang.UnaryFromClause
A FROM subpart that represents a single group. For example, the FROM clause: "FROM a, b" will have two UnaryFromClause objects, each holding a reference to a GroupSymbol (for a and b).

         query);
  }
  
  /** Select myG.a myA, myH.b from g myG right outer join h myH on myG.x=myH.x */
  @Test public void testRightOuterJoinWithAliases() {
    UnaryFromClause g = new UnaryFromClause(new GroupSymbol("myG", "g")); //$NON-NLS-1$ //$NON-NLS-2$
    UnaryFromClause h = new UnaryFromClause(new GroupSymbol("myH", "h"));     //$NON-NLS-1$ //$NON-NLS-2$
    CompareCriteria jcrit = new CompareCriteria(
      new ElementSymbol("myG.x"), //$NON-NLS-1$
      CompareCriteria.EQ,
      new ElementSymbol("myH.x")); //$NON-NLS-1$
    ArrayList<Criteria> crits = new ArrayList<Criteria>();

View Full Code Here

         query);
  }
  
  /** Select myG.x myX, myH.y from g myG right join h myH on myG.x=myH.x */
  @Test public void testRightJoinWithAliases() {
    UnaryFromClause g = new UnaryFromClause(new GroupSymbol("myG", "g")); //$NON-NLS-1$ //$NON-NLS-2$
    UnaryFromClause h = new UnaryFromClause(new GroupSymbol("myH", "h"));     //$NON-NLS-1$ //$NON-NLS-2$
    CompareCriteria jcrit = new CompareCriteria(
      new ElementSymbol("myG.x"), //$NON-NLS-1$
      CompareCriteria.EQ,
      new ElementSymbol("myH.x")); //$NON-NLS-1$
    ArrayList<Criteria> crits = new ArrayList<Criteria>();

View Full Code Here

         query);
  }
  
  /** Select myG.a myA, myH.b from g myG left outer join h myH on myG.x=myH.x */
  @Test public void testLeftOuterJoinWithAliases() {
    UnaryFromClause g = new UnaryFromClause(new GroupSymbol("myG", "g")); //$NON-NLS-1$ //$NON-NLS-2$
    UnaryFromClause h = new UnaryFromClause(new GroupSymbol("myH", "h"));     //$NON-NLS-1$ //$NON-NLS-2$
    CompareCriteria jcrit = new CompareCriteria(
      new ElementSymbol("myG.x"), //$NON-NLS-1$
      CompareCriteria.EQ,
      new ElementSymbol("myH.x")); //$NON-NLS-1$
    ArrayList<Criteria> crits = new ArrayList<Criteria>();

View Full Code Here

         query);
  }  


  /** Select myG.a myA, myH.b from g myG left join h myH on myG.x=myH.x */
  @Test public void testLeftJoinWithAliases() {
    UnaryFromClause g = new UnaryFromClause(new GroupSymbol("myG", "g")); //$NON-NLS-1$ //$NON-NLS-2$
    UnaryFromClause h = new UnaryFromClause(new GroupSymbol("myH", "h"));     //$NON-NLS-1$ //$NON-NLS-2$
    CompareCriteria jcrit = new CompareCriteria(
      new ElementSymbol("myG.x"), //$NON-NLS-1$
      CompareCriteria.EQ,
      new ElementSymbol("myH.x")); //$NON-NLS-1$
    ArrayList<Criteria> crits = new ArrayList<Criteria>();

View Full Code Here

         query);
  }  
  
  /** Select myG.a myA, myH.b from g myG full outer join h myH on myG.x=myH.x */
  @Test public void testFullOuterJoinWithAliases() {
    UnaryFromClause g = new UnaryFromClause(new GroupSymbol("myG", "g")); //$NON-NLS-1$ //$NON-NLS-2$
    UnaryFromClause h = new UnaryFromClause(new GroupSymbol("myH", "h"));     //$NON-NLS-1$ //$NON-NLS-2$
    CompareCriteria jcrit = new CompareCriteria(
      new ElementSymbol("myG.x"), //$NON-NLS-1$
      CompareCriteria.EQ,
      new ElementSymbol("myH.x")); //$NON-NLS-1$
    ArrayList<Criteria> crits = new ArrayList<Criteria>();

View Full Code Here

         query);
  }
  
  /** Select g.a, h.b from g full join h on g.x=h.x */
  @Test public void testFullJoin() {
    UnaryFromClause g = new UnaryFromClause(new GroupSymbol("g")); //$NON-NLS-1$
    UnaryFromClause h = new UnaryFromClause(new GroupSymbol("h"));     //$NON-NLS-1$
    CompareCriteria jcrit = new CompareCriteria(
      new ElementSymbol("g.x"), //$NON-NLS-1$
      CompareCriteria.EQ,
      new ElementSymbol("h.x")); //$NON-NLS-1$
    ArrayList<Criteria> crits = new ArrayList<Criteria>();

View Full Code Here

        
        Query query = new Query();
        query.setSelect(select);
        query.setFrom(from);
        
        UnaryFromClause ufc = new UnaryFromClause(new GroupSymbol("m.g1")); //$NON-NLS-1$
        SubqueryFromClause sfc = new SubqueryFromClause("y", query); //$NON-NLS-1$
        CompareCriteria join = new CompareCriteria(new ElementSymbol("m.g1.a"), CompareCriteria.EQ, new ElementSymbol("y.c")); //$NON-NLS-1$ //$NON-NLS-2$
        List crits = new ArrayList();
        crits.add(join);
        JoinPredicate jp = new JoinPredicate(ufc, sfc, JoinType.JOIN_INNER, crits);

View Full Code Here

        Select u1s = new Select();
        u1s.addSymbol(new ElementSymbol("x1")); //$NON-NLS-1$
        u1.setSelect(u1s);
        From u1f = new From();
        u1f = new From();
        u1f.addClause(new UnaryFromClause(new GroupSymbol("db.g2"))); //$NON-NLS-1$
        u1.setFrom(u1f);


        Query u2 = new Query();
        Select u2s = new Select();
        u2s.addSymbol(new ElementSymbol("x2")); //$NON-NLS-1$
        u2.setSelect(u2s);
        From u2f = new From();
        u2f = new From();
        u2f.addClause(new UnaryFromClause(new GroupSymbol("db.g3"))); //$NON-NLS-1$
        u2.setFrom(u2f);


        SetQuery union = new SetQuery(Operation.UNION, true, u1, u2);        
                       
        SubquerySetCriteria subCrit = new SubquerySetCriteria(expr, union);

View Full Code Here

        Query query = new Query();
        Select select = new Select();
        select.addSymbol(new AllSymbol());
        query.setSelect(select);
        From from = new From();
        from.addClause(new UnaryFromClause(new GroupSymbol("newModel2.Table1")));         //$NON-NLS-1$
        StoredProcedure subquery = new StoredProcedure();
        subquery.setProcedureName("NewVirtual.StoredQuery");
        from.addClause(new SubqueryFromClause("a", subquery)); //$NON-NLS-1$
        query.setFrom(from);

View Full Code Here

        List jcrits1 = new ArrayList();
        jcrits1.add(new CompareCriteria(e1, CompareCriteria.EQ, e2));
        List jcrits2 = new ArrayList();
        jcrits2.add(new CompareCriteria(e3, CompareCriteria.EQ, e4));


        JoinPredicate jp1 = new JoinPredicate(new UnaryFromClause(g1), new UnaryFromClause(g2), JoinType.JOIN_INNER, jcrits1); 
        JoinPredicate jp2 = new JoinPredicate(jp1, new UnaryFromClause(g3), JoinType.JOIN_INNER, jcrits2);       
        
        from.addClause(jp2);
        query.setFrom(from);           


        helpTest(sql, sqlExpected, query);

View Full Code Here

0 1 2 3 4 5 6 7 8

TOP

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

org.teiid.dqp.internal.datamgr.TestJoinImpl

org.teiid.dqp.internal.datamgr.TestQueryImpl

org.teiid.dqp.internal.process.DataTierManagerImpl

org.teiid.query.optimizer.relational.RelationalPlanner

org.teiid.query.optimizer.TriggerActionPlanner

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.util.ResolverUtil

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.