Examples of org.teiid.query.sql.symbol.AllSymbol

org.teiid.query.sql.symbol.AllSymbol

This is a subclass of Symbol representing *, which contains all of the elements from all groups in the query. The name of this symbol is always "*", when resolved it contains a set of Element Symbols referred to by the AllSymbol

      
  // ################################## ACTUAL TESTS ################################
  
  public void testGetProjectedNoElements() {    
      Select select = new Select();
      select.addSymbol(new AllSymbol());
      
      List projectedSymbols = select.getProjectedSymbols();
      assertEquals("Did not get empty list for select * with no elements: ", new ArrayList(), projectedSymbols); //$NON-NLS-1$
  }

View Full Code Here

    List symbols = new ArrayList();
    symbols.add(new ElementSymbol("a")); //$NON-NLS-1$
    symbols.add(new ElementSymbol("b")); //$NON-NLS-1$


      Select select = new Select();
      AllSymbol all = new AllSymbol();
      all.setElementSymbols(symbols);
      select.addSymbol(all);
      
      List projectedSymbols = select.getProjectedSymbols();
      assertEquals("Did not get correct list for select *: ", symbols, projectedSymbols); //$NON-NLS-1$
  }

View Full Code Here

    helpTest(select, getSymbolMap());   
  }


  public void testVisitSelect2() { 
    Select select = new Select();
    AllSymbol all = new AllSymbol();
    select.addSymbol(all);
    helpTest(select, getSymbolMap());   
  }

View Full Code Here

    helpTest(select, getSymbolMap());   
  }


  public void testVisitSelect3() { 
    Select select = new Select();
    AllSymbol all = new AllSymbol();
    all.addElementSymbol(exampleElement(true, 0));
    select.addSymbol(all);
    helpTest(select, getSymbolMap());   
  }

View Full Code Here

    AliasSymbol as = new AliasSymbol("abc", exampleElement(true, 0)); //$NON-NLS-1$
    helpTest(as, getSymbolMap());
  }
  
   public void testVisitAllSymbol() {
     AllSymbol as = new AllSymbol();
     ArrayList elements = new ArrayList();
     elements.add(exampleElement(true, 0));    
     elements.add(exampleElement(true, 1));         
     as.setElementSymbols(elements);
     helpTest(as, getSymbolMap());
   }

View Full Code Here

    helpTest(ob, "ORDER BY e1 DESC, x DESC");     //$NON-NLS-1$
  }


  public void testQuery1() {
    Select select = new Select();
    select.addSymbol(new AllSymbol());
    From from = new From();
    from.addGroup(new GroupSymbol("m.g")); //$NON-NLS-1$
    Query query = new Query();
    query.setSelect(select);
    query.setFrom(from);

View Full Code Here

    helpTest(query, "SELECT * FROM m.g");         //$NON-NLS-1$
  }


  public void testQuery2() {
    Select select = new Select();
    select.addSymbol(new AllSymbol());
    From from = new From();
    from.addGroup(new GroupSymbol("m.g")); //$NON-NLS-1$
    CompareCriteria cc = new CompareCriteria(new ElementSymbol("e1"), CompareCriteria.EQ, new Constant(new Integer(5))); //$NON-NLS-1$
    GroupBy groupBy = new GroupBy();
    groupBy.addSymbol(new ElementSymbol("e1")); //$NON-NLS-1$

View Full Code Here

    helpTest(query, "SELECT * FROM m.g WHERE e1 = 5 GROUP BY e1 HAVING e1 > 0 ORDER BY e1");         //$NON-NLS-1$
  }


  public void testQuery3() {
    Select select = new Select();
    select.addSymbol(new AllSymbol());
    From from = new From();
    from.addGroup(new GroupSymbol("m.g")); //$NON-NLS-1$
    GroupBy groupBy = new GroupBy();
    groupBy.addSymbol(new ElementSymbol("e1")); //$NON-NLS-1$
    CompareCriteria having = new CompareCriteria(new ElementSymbol("e1"), CompareCriteria.GT, new Constant(new Integer(0))); //$NON-NLS-1$

View Full Code Here

    helpTest(query, "SELECT * FROM m.g GROUP BY e1 HAVING e1 > 0 ORDER BY e1");         //$NON-NLS-1$
  }


  public void testQuery4() {
    Select select = new Select();
    select.addSymbol(new AllSymbol());
    From from = new From();
    from.addGroup(new GroupSymbol("m.g")); //$NON-NLS-1$
    CompareCriteria cc = new CompareCriteria(new ElementSymbol("e1"), CompareCriteria.EQ, new Constant(new Integer(5))); //$NON-NLS-1$
    CompareCriteria having = new CompareCriteria(new ElementSymbol("e1"), CompareCriteria.GT, new Constant(new Integer(0))); //$NON-NLS-1$
    OrderBy orderBy = new OrderBy();

View Full Code Here

    helpTest(query, "SELECT * FROM m.g WHERE e1 = 5 HAVING e1 > 0 ORDER BY e1");         //$NON-NLS-1$
  }


  public void testQuery5() {
    Select select = new Select();
    select.addSymbol(new AllSymbol());
    From from = new From();
    from.addGroup(new GroupSymbol("m.g")); //$NON-NLS-1$
    CompareCriteria cc = new CompareCriteria(new ElementSymbol("e1"), CompareCriteria.EQ, new Constant(new Integer(5))); //$NON-NLS-1$
    GroupBy groupBy = new GroupBy();
    groupBy.addSymbol(new ElementSymbol("e1")); //$NON-NLS-1$

View Full Code Here

0 1 2 3 4 5 6 7

TOP

Related Classes of org.teiid.query.sql.symbol.AllSymbol

org.teiid.cdk.CommandBuilder

org.teiid.query.optimizer.relational.RelationalPlanner

org.teiid.query.optimizer.relational.rules.TestRulePlaceAccess

org.teiid.query.parser.TestOptionsAndHints

org.teiid.query.parser.TestParser

org.teiid.query.parser.TestSetQueryParsing

org.teiid.query.resolver.command.XMLQueryResolver

org.teiid.query.sql.lang.TestSelect

org.teiid.query.sql.visitor.TestSQLStringVisitor

org.teiid.query.sql.visitor.TestStaticSymbolMappingVisitor

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.