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

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

    }
    
    public void testInequality1() {
        GroupSymbol group = new GroupSymbol("g1", "a"); //$NON-NLS-1$ //$NON-NLS-2$
        GroupSymbol group1 = new GroupSymbol("g1"); //$NON-NLS-1$ 
        assertFalse(new UnaryFromClause(group).equals(new UnaryFromClause(group1)));
    }

View Full Code Here

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


    // ======================== Joins ===============================================


  /** SELECT * FROM g1 inner join g2 on g1.a1=g2.a2 */
  @Test public void testInnerJoin() {
    UnaryFromClause g1 = new UnaryFromClause(new GroupSymbol("g1")); //$NON-NLS-1$
    UnaryFromClause g2 = new UnaryFromClause(new GroupSymbol("g2"));     //$NON-NLS-1$
    CompareCriteria jcrit = new CompareCriteria(
      new ElementSymbol("g1.a1"), //$NON-NLS-1$
      CompareCriteria.EQ,
      new ElementSymbol("g2.a2")); //$NON-NLS-1$
    ArrayList<Criteria> crits = new ArrayList<Criteria>();

View Full Code Here

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

         query);
  }


  /** SELECT * FROM g1 cross join g2 */
  @Test public void testCrossJoin() {
    UnaryFromClause g1 = new UnaryFromClause(new GroupSymbol("g1")); //$NON-NLS-1$
    UnaryFromClause g2 = new UnaryFromClause(new GroupSymbol("g2")); //$NON-NLS-1$
    JoinPredicate jp = new JoinPredicate(g1, g2, JoinType.JOIN_CROSS);    
    From from = new From();
    from.addClause(jp);  


    AllSymbol all = new AllSymbol();

View Full Code Here

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

         query);
  }
  
  /** SELECT * FROM (g1 cross join g2), g3 */
  @Test public void testFromClauses() {
    UnaryFromClause g1 = new UnaryFromClause(new GroupSymbol("g1")); //$NON-NLS-1$
    UnaryFromClause g2 = new UnaryFromClause(new GroupSymbol("g2")); //$NON-NLS-1$
    JoinPredicate jp = new JoinPredicate(g1, g2, JoinType.JOIN_CROSS);    
    From from = new From();
    from.addClause(jp);  
    from.addClause(new UnaryFromClause(new GroupSymbol("g3"))); //$NON-NLS-1$


    AllSymbol all = new AllSymbol();
    Select select = new Select();
    select.addSymbol(all);

View Full Code Here

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

    helpException("SELECT * FROM g1 inner join g2");     //$NON-NLS-1$
  }


  /** SELECT * FROM (g1 cross join g2) cross join g3 */
  @Test public void testMultiCrossJoin() {
    UnaryFromClause g1 = new UnaryFromClause(new GroupSymbol("g1")); //$NON-NLS-1$
    UnaryFromClause g2 = new UnaryFromClause(new GroupSymbol("g2"));     //$NON-NLS-1$
    JoinPredicate jp = new JoinPredicate(g1, g2, JoinType.JOIN_CROSS);
    JoinPredicate jp2 = new JoinPredicate(jp, new UnaryFromClause(new GroupSymbol("g3")), JoinType.JOIN_CROSS);     //$NON-NLS-1$
    From from = new From();
    from.addClause(jp2);  


    AllSymbol all = new AllSymbol();
    Select select = new Select();

View Full Code Here

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

         query);
  }


  /** SELECT * FROM (g1 cross join g2) cross join (g3 cross join g4) */
  @Test public void testMultiCrossJoin2() {
    UnaryFromClause g1 = new UnaryFromClause(new GroupSymbol("g1")); //$NON-NLS-1$
    UnaryFromClause g2 = new UnaryFromClause(new GroupSymbol("g2"));     //$NON-NLS-1$
    JoinPredicate jp = new JoinPredicate(g1, g2, JoinType.JOIN_CROSS);
    UnaryFromClause g3 = new UnaryFromClause(new GroupSymbol("g3")); //$NON-NLS-1$
    UnaryFromClause g4 = new UnaryFromClause(new GroupSymbol("g4"));     //$NON-NLS-1$
    JoinPredicate jp2 = new JoinPredicate(g3, g4, JoinType.JOIN_CROSS);
    JoinPredicate jp3 = new JoinPredicate(jp, jp2, JoinType.JOIN_CROSS);    
    From from = new From();
    from.addClause(jp3);

View Full Code Here

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

         query);
  }


  /** SELECT * FROM g1 cross join (g2 cross join g3) */
  @Test public void testMultiCrossJoin3() {
    UnaryFromClause g1 = new UnaryFromClause(new GroupSymbol("g1")); //$NON-NLS-1$
    UnaryFromClause g2 = new UnaryFromClause(new GroupSymbol("g2"));     //$NON-NLS-1$
    UnaryFromClause g3 = new UnaryFromClause(new GroupSymbol("g3")); //$NON-NLS-1$
    JoinPredicate jp = new JoinPredicate(g2, g3, JoinType.JOIN_CROSS);
    JoinPredicate jp2 = new JoinPredicate(g1, jp, JoinType.JOIN_CROSS);
    From from = new From();
    from.addClause(jp2);

View Full Code Here

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

         query);
  }


  /** SELECT * FROM g1 cross join (g2 cross join g3), g4 */
  @Test public void testMixedJoin() {
    UnaryFromClause g1 = new UnaryFromClause(new GroupSymbol("g1")); //$NON-NLS-1$
    UnaryFromClause g2 = new UnaryFromClause(new GroupSymbol("g2"));     //$NON-NLS-1$
    UnaryFromClause g3 = new UnaryFromClause(new GroupSymbol("g3")); //$NON-NLS-1$
    JoinPredicate jp = new JoinPredicate(g2, g3, JoinType.JOIN_CROSS);
    JoinPredicate jp2 = new JoinPredicate(g1, jp, JoinType.JOIN_CROSS);
    From from = new From();
    from.addClause(jp2);
    from.addClause(new UnaryFromClause(new GroupSymbol("g4")));   //$NON-NLS-1$


    AllSymbol all = new AllSymbol();
    Select select = new Select();
    select.addSymbol(all);

View Full Code Here

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

         query);
  }


  /** SELECT * FROM g1 cross join (g2 cross join g3), g4, g5 cross join g6 */
  @Test public void testMixedJoin2() {
    UnaryFromClause g1 = new UnaryFromClause(new GroupSymbol("g1")); //$NON-NLS-1$
    UnaryFromClause g2 = new UnaryFromClause(new GroupSymbol("g2"));     //$NON-NLS-1$
    UnaryFromClause g3 = new UnaryFromClause(new GroupSymbol("g3")); //$NON-NLS-1$
    UnaryFromClause g4 = new UnaryFromClause(new GroupSymbol("g4")); //$NON-NLS-1$
    UnaryFromClause g5 = new UnaryFromClause(new GroupSymbol("g5")); //$NON-NLS-1$
    UnaryFromClause g6 = new UnaryFromClause(new GroupSymbol("g6"));     //$NON-NLS-1$
    JoinPredicate jp = new JoinPredicate(g2, g3, JoinType.JOIN_CROSS);
    JoinPredicate jp2 = new JoinPredicate(g1, jp, JoinType.JOIN_CROSS);
    JoinPredicate jp3 = new JoinPredicate(g5, g6, JoinType.JOIN_CROSS);
    From from = new From();
    from.addClause(jp2);

View Full Code Here

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

         query);
  }
  
  /** SELECT * FROM g1, g2 inner join g3 on g2.a=g3.a */
  @Test public void testMixedJoin3() {
    UnaryFromClause g1 = new UnaryFromClause(new GroupSymbol("g1")); //$NON-NLS-1$
    UnaryFromClause g2 = new UnaryFromClause(new GroupSymbol("g2"));     //$NON-NLS-1$
    UnaryFromClause g3 = new UnaryFromClause(new GroupSymbol("g3")); //$NON-NLS-1$
    CompareCriteria jcrit = new CompareCriteria(
      new ElementSymbol("g2.a"), //$NON-NLS-1$
      CompareCriteria.EQ,
      new ElementSymbol("g3.a")); //$NON-NLS-1$
    ArrayList<Criteria> crits = new ArrayList<Criteria>();

View Full Code Here

0 1 2 3 4 5

TOP

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.