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).

    @Test public void testExplicitTable() throws Exception {
      Query query = new Query();
        Select select = new Select();
        query.setSelect(select);
        select.addSymbol(new AllSymbol());
        From from = new From(Arrays.asList(new UnaryFromClause(new GroupSymbol("X"))));
        query.setFrom(from);
      helpTest("TABLE X", "SELECT * FROM X", query);
    }

View Full Code Here

      helpTest(from, "FROM m.g1, m.g2");     //$NON-NLS-1$
    }
    
    public void testFrom2() {
      From from = new From();
      from.addClause(new UnaryFromClause(new GroupSymbol("m.g1")));   //$NON-NLS-1$
      from.addClause(new JoinPredicate(
        new UnaryFromClause(new GroupSymbol("m.g2")), //$NON-NLS-1$
        new UnaryFromClause(new GroupSymbol("m.g3")),  //$NON-NLS-1$
        JoinType.JOIN_CROSS) );
      
      helpTest(from, "FROM m.g1, m.g2 CROSS JOIN m.g3");     //$NON-NLS-1$
    }

View Full Code Here

        helpTest(inc, "m.g.e1 IS NOT NULL"); //$NON-NLS-1$
    }


  public void testJoinPredicate1() {
    JoinPredicate jp = new JoinPredicate(
        new UnaryFromClause(new GroupSymbol("m.g2")), //$NON-NLS-1$
        new UnaryFromClause(new GroupSymbol("m.g3")),  //$NON-NLS-1$
        JoinType.JOIN_CROSS);
        
      helpTest(jp, "m.g2 CROSS JOIN m.g3"); //$NON-NLS-1$
  }

View Full Code Here

      helpTest(jp, "m.g2 CROSS JOIN m.g3"); //$NON-NLS-1$
  }
    
    public void testOptionalJoinPredicate1() {
        JoinPredicate jp = new JoinPredicate(
            new UnaryFromClause(new GroupSymbol("m.g2")), //$NON-NLS-1$
            new UnaryFromClause(new GroupSymbol("m.g3")),  //$NON-NLS-1$
            JoinType.JOIN_CROSS);
        jp.setOptional(true);
        helpTest(jp, "/*+ optional */ (m.g2 CROSS JOIN m.g3)"); //$NON-NLS-1$
    }

View Full Code Here


  public void testJoinPredicate2() {
      ArrayList<Criteria> crits = new ArrayList<Criteria>();
      crits.add(new CompareCriteria(new ElementSymbol("m.g2.e1"), CompareCriteria.EQ, new ElementSymbol("m.g3.e1"))); //$NON-NLS-1$ //$NON-NLS-2$
    JoinPredicate jp = new JoinPredicate(
        new UnaryFromClause(new GroupSymbol("m.g2")), //$NON-NLS-1$
        new UnaryFromClause(new GroupSymbol("m.g3")), //$NON-NLS-1$
        JoinType.JOIN_INNER,
        crits );
        
      helpTest(jp, "m.g2 INNER JOIN m.g3 ON m.g2.e1 = m.g3.e1"); //$NON-NLS-1$
  }

View Full Code Here

  public void testJoinPredicate3() {
      ArrayList<Criteria> crits = new ArrayList<Criteria>();
      crits.add(new CompareCriteria(new ElementSymbol("m.g2.e1"), CompareCriteria.EQ, new ElementSymbol("m.g3.e1"))); //$NON-NLS-1$ //$NON-NLS-2$
      crits.add(new CompareCriteria(new ElementSymbol("m.g2.e2"), CompareCriteria.EQ, new ElementSymbol("m.g3.e2"))); //$NON-NLS-1$ //$NON-NLS-2$
    JoinPredicate jp = new JoinPredicate(
        new UnaryFromClause(new GroupSymbol("m.g2")), //$NON-NLS-1$
        new UnaryFromClause(new GroupSymbol("m.g3")), //$NON-NLS-1$
        JoinType.JOIN_INNER,
        crits );
        
      helpTest(jp, "m.g2 INNER JOIN m.g3 ON m.g2.e1 = m.g3.e1 AND m.g2.e2 = m.g3.e2"); //$NON-NLS-1$
  }

View Full Code Here


  public void testJoinPredicate4() {
      ArrayList<Criteria> crits = new ArrayList<Criteria>();
      crits.add(new CompareCriteria(new ElementSymbol("m.g2.e1"), CompareCriteria.EQ, new ElementSymbol("m.g3.e1"))); //$NON-NLS-1$ //$NON-NLS-2$
    JoinPredicate jp = new JoinPredicate(
        new UnaryFromClause(new GroupSymbol("m.g2")), //$NON-NLS-1$
        new UnaryFromClause(new GroupSymbol("m.g3")), //$NON-NLS-1$
        JoinType.JOIN_INNER,
        crits );
        
      JoinPredicate jp2 = new JoinPredicate(
        jp,
        new UnaryFromClause(new GroupSymbol("m.g1")), //$NON-NLS-1$
        JoinType.JOIN_CROSS);
        
      helpTest(jp2, "(m.g2 INNER JOIN m.g3 ON m.g2.e1 = m.g3.e1) CROSS JOIN m.g1"); //$NON-NLS-1$
  }

View Full Code Here


    public void testJoinPredicate5() {
        ArrayList<Criteria> crits = new ArrayList<Criteria>();
        crits.add(new NotCriteria(new CompareCriteria(new ElementSymbol("m.g2.e1"), CompareCriteria.EQ, new ElementSymbol("m.g3.e1")))); //$NON-NLS-1$ //$NON-NLS-2$
        JoinPredicate jp = new JoinPredicate(
            new UnaryFromClause(new GroupSymbol("m.g2")), //$NON-NLS-1$
            new UnaryFromClause(new GroupSymbol("m.g3")), //$NON-NLS-1$
            JoinType.JOIN_INNER,
            crits );
                        
        helpTest(jp, "m.g2 INNER JOIN m.g3 ON NOT (m.g2.e1 = m.g3.e1)"); //$NON-NLS-1$
    }

View Full Code Here

        ssc.setNegated(true);
        helpTest(ssc, "e2 NOT IN (SELECT e1 FROM m.g1)");             //$NON-NLS-1$
    }
        
  public void testUnaryFromClause() {
    helpTest(new UnaryFromClause(new GroupSymbol("m.g1")), "m.g1");     //$NON-NLS-1$ //$NON-NLS-2$
  }

View Full Code Here

  public void testUnaryFromClause() {
    helpTest(new UnaryFromClause(new GroupSymbol("m.g1")), "m.g1");     //$NON-NLS-1$ //$NON-NLS-2$
  }
    
    public void testOptionalUnaryFromClause() {
        UnaryFromClause unaryFromClause = new UnaryFromClause(new GroupSymbol("m.g1"));//$NON-NLS-1$
        unaryFromClause.setOptional(true);
        helpTest(unaryFromClause, "/*+ optional */ m.g1");     //$NON-NLS-1$ 
    }

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.