Examples of ElementSymbol

org.teiid.query.sql.symbol.ElementSymbol

This is a subclass of Symbol representing a single element. An ElementSymbol also is an expression and thus has a type. Element symbols have a variety of attributes that determine how they are displayed - a flag for displaying fully qualified and an optional vdb name.

The "isExternalReference" property indicates whether the element symbol refers to an element from a group outside the current command. Typically this is set to false. Common uses when this is set to true are for variables used within a command, correlated elements within a command, etc.

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

        helpResolveException("SELECT portfoliob.e1 FROM ((pm1.g1 AS portfoliob JOIN pm1.g2 AS portidentb ON portfoliob.e1 = portidentb.e1) RIGHT OUTER JOIN pm1.g3 AS identifiersb ON portidentb.e1 = 'ISIN' and portidentb.e2 = identifiersb.e2) RIGHT OUTER JOIN pm1.g1 AS issuesb ON a.identifiersb.e1 = issuesb.e1"); //$NON-NLS-1$
    }       


    @Test public void testCriteria1() {                  
        CompareCriteria expected = new CompareCriteria();
        ElementSymbol es = new ElementSymbol("pm1.g1.e1"); //$NON-NLS-1$
        GroupSymbol gs = new GroupSymbol("pm1.g1"); //$NON-NLS-1$
        es.setGroupSymbol(gs);
        expected.setLeftExpression(es);
        expected.setOperator(CompareCriteria.EQ);
        expected.setRightExpression(new Constant("abc")); //$NON-NLS-1$


        Criteria actual = helpResolveCriteria("pm1.g1.e1 = 'abc'"); //$NON-NLS-1$

View Full Code Here

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

        Query resolvedQuery = (Query) helpResolve("select * from (EXEC pm1.sq2('abc')) as x"); //$NON-NLS-1$
        helpCheckFrom(resolvedQuery, new String[] { "x" }); //$NON-NLS-1$
        
        List elements = (List) ElementCollectorVisitor.getElements(resolvedQuery.getSelect(), false);
        
        ElementSymbol elem1 = (ElementSymbol)elements.get(0);
        assertEquals("Did not get expected element", "x.e1", elem1.getName() ); //$NON-NLS-1$ //$NON-NLS-2$
        assertEquals("Did not get expected type", DataTypeManager.DefaultDataClasses.STRING, elem1.getType()); //$NON-NLS-1$


        ElementSymbol elem2 = (ElementSymbol)elements.get(1);
        assertEquals("Did not get expected element", "x.e2", elem2.getName() ); //$NON-NLS-1$ //$NON-NLS-2$
        assertEquals("Did not get expected type", DataTypeManager.DefaultDataClasses.INTEGER, elem2.getType()); //$NON-NLS-1$
    }

View Full Code Here

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

        // resolve
        try {
            // Construct command metadata
            GroupSymbol sqGroup = new GroupSymbol("pm1.sq5"); //$NON-NLS-1$
            ArrayList sqParams = new ArrayList();
            ElementSymbol in = new ElementSymbol("pm1.sq5.in1"); //$NON-NLS-1$
            in.setType(DataTypeManager.DefaultDataClasses.STRING);
            sqParams.add(in);
            Map externalMetadata = new HashMap();
            externalMetadata.put(sqGroup, sqParams);


            QueryResolver.resolveCommand(command, metadata);

View Full Code Here

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

    @Test public void testSubQueryINClause1(){
    //select e1 from pm1.g1 where e2 in (select e2 from pm4.g1)


    //sub command
    Select innerSelect = new Select();
    ElementSymbol e2inner = new ElementSymbol("e2"); //$NON-NLS-1$
    innerSelect.addSymbol(e2inner);
    From innerFrom = new From();
    GroupSymbol pm4g1 = new GroupSymbol("pm4.g1"); //$NON-NLS-1$
    innerFrom.addGroup(pm4g1);
    Query innerQuery = new Query();
    innerQuery.setSelect(innerSelect);
    innerQuery.setFrom(innerFrom);
    
    //outer command
    Select outerSelect = new Select();
    ElementSymbol e1 = new ElementSymbol("e1"); //$NON-NLS-1$
      outerSelect.addSymbol(e1);
    From outerFrom = new From();
      GroupSymbol pm1g1 = new GroupSymbol("pm1.g1"); //$NON-NLS-1$
    outerFrom.addGroup(pm1g1);
      ElementSymbol e2outer = new ElementSymbol("e2"); //$NON-NLS-1$
    SubquerySetCriteria crit = new SubquerySetCriteria(e2outer, innerQuery);
      Query outerQuery = new Query();
      outerQuery.setSelect(outerSelect);
      outerQuery.setFrom(outerFrom);
      outerQuery.setCriteria(crit);

View Full Code Here

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

  @Test public void testSubQueryINClauseImplicitConversion(){
    //select e1 from pm1.g1 where e2 in (select e1 from pm4.g1)
  
    //sub command
    Select innerSelect = new Select();
    ElementSymbol e1inner = new ElementSymbol("e1"); //$NON-NLS-1$
    innerSelect.addSymbol(e1inner);
    From innerFrom = new From();
    GroupSymbol pm4g1 = new GroupSymbol("pm4.g1"); //$NON-NLS-1$
    innerFrom.addGroup(pm4g1);
    Query innerQuery = new Query();
    innerQuery.setSelect(innerSelect);
    innerQuery.setFrom(innerFrom);
    
    //outer command
    Select outerSelect = new Select();
    ElementSymbol e1 = new ElementSymbol("e1"); //$NON-NLS-1$
    outerSelect.addSymbol(e1);
    From outerFrom = new From();
    GroupSymbol pm1g1 = new GroupSymbol("pm1.g1"); //$NON-NLS-1$
    outerFrom.addGroup(pm1g1);
    ElementSymbol e2 = new ElementSymbol("e2"); //$NON-NLS-1$
    SubquerySetCriteria crit = new SubquerySetCriteria(e2, innerQuery);
    Query outerQuery = new Query();
    outerQuery.setSelect(outerSelect);
    outerQuery.setFrom(outerFrom);
    outerQuery.setCriteria(crit);

View Full Code Here

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

  @Test public void testSubQueryINClauseNoConversionFails(){
    //select e1 from pm1.g1 where e1 in (select e2 from pm4.g1)


    //sub command
    Select innerSelect = new Select();
    ElementSymbol e2inner = new ElementSymbol("e2"); //$NON-NLS-1$
    innerSelect.addSymbol(e2inner);
    From innerFrom = new From();
    GroupSymbol pm4g1 = new GroupSymbol("pm4.g1"); //$NON-NLS-1$
    innerFrom.addGroup(pm4g1);
    Query innerQuery = new Query();
    innerQuery.setSelect(innerSelect);
    innerQuery.setFrom(innerFrom);


    //outer command
    Select outerSelect = new Select();
    ElementSymbol e1 = new ElementSymbol("e1"); //$NON-NLS-1$
    outerSelect.addSymbol(e1);
    From outerFrom = new From();
    GroupSymbol pm1g1 = new GroupSymbol("pm1.g1"); //$NON-NLS-1$
    outerFrom.addGroup(pm1g1);
    SubquerySetCriteria crit = new SubquerySetCriteria(e1, innerQuery);

View Full Code Here

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

        }
    }
    
    @Test public void testStringConversion1() {
    // Expected left expression
        ElementSymbol e1 = new ElementSymbol("pm3.g1.e2"); //$NON-NLS-1$
        e1.setType(DataTypeManager.DefaultDataClasses.DATE);
      
        // Expected right expression
        Class srcType = DataTypeManager.DefaultDataClasses.STRING;
        String tgtTypeName = DataTypeManager.DefaultDataTypes.DATE;
        Expression expression = new Constant("2003-02-27"); //$NON-NLS-1$

View Full Code Here

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

    assertEquals("Did not match expected criteria", expected, actual); //$NON-NLS-1$
    }
    
  @Test public void testStringConversion2() {
    // Expected left expression
    ElementSymbol e1 = new ElementSymbol("pm3.g1.e2"); //$NON-NLS-1$
    e1.setType(DataTypeManager.DefaultDataClasses.DATE);
      
    // Expected right expression
    Class srcType = DataTypeManager.DefaultDataClasses.STRING;
    String tgtTypeName = DataTypeManager.DefaultDataTypes.DATE;
    Expression expression = new Constant("2003-02-27"); //$NON-NLS-1$

View Full Code Here

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

  private void updatePartitionInfo(
      Map<ElementSymbol, List<Set<Constant>>> partitionInfo,
      List<int[]> matches, SymbolMap symbolmap,
      HashMap<ElementSymbol, List<Set<Constant>>> newPartitionInfo, int start, int index) {
    for (Map.Entry<ElementSymbol, List<Set<Constant>>> entry : partitionInfo.entrySet()) {
      ElementSymbol newSymbol = symbolmap.getKeys().get(start++);
      List<Set<Constant>> values = newPartitionInfo.get(newSymbol);
      if (values == null) {
        values = new ArrayList<Set<Constant>>(matches.size());
        newPartitionInfo.put(newSymbol, values);
      }

View Full Code Here

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

    List<int[]> matches = null;
    for (int i = 0; i < expr.size() && matches == null; i++) {
      if (!(expr.get(i) instanceof ElementSymbol) || !(exprOther.get(i) instanceof ElementSymbol)) {
        continue;
      }
      ElementSymbol es = (ElementSymbol)expr.get(i);
      ElementSymbol esOther = (ElementSymbol)exprOther.get(i);
      List<Set<Constant>> partLists = partitionInfo.get(es);
      List<Set<Constant>> partListsOther = partitionInfoOther.get(esOther);
      if (partLists == null || partListsOther == null) {
        continue;
      }

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.