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

org.teiid.query.sql.lang.SetCriteria
A criteria which is true is the expression's value is a member in a list of values. This criteria can be represented as " IN (, ...)".

        Criteria atomicCrit1 = null;
        Collection values = new LinkedList();
        values.add(new Constant(new Integer(3)));
        values.add(new Constant(new Integer(4)));
        values.add(new Constant(new Integer(5)));
        Criteria atomicCrit2 = new SetCriteria(g2e1, values);
        int expected = LEFT_SIDE;
        helpTestChooseSiblingAndMarkDependent(group1, atomicCrit1, group2, atomicCrit2, crits, expected);        
        expected = RIGHT_SIDE;
        helpTestChooseSiblingAndMarkDependent(group2, atomicCrit2, group1, atomicCrit1, crits, expected);        
    }

View Full Code Here

        Expression constant1 = new Constant(new Integer(1000));
        Expression constant2 = new Constant(new Integer(5000));
        Collection constants = new ArrayList(2);
        constants.add(constant1);
        constants.add(constant2);
        Criteria crit = new SetCriteria(new ElementSymbol("b"), constants); //$NON-NLS-1$


        Query query = new Query();
        query.setSelect(select);
        query.setFrom(from);
        query.setCriteria(crit);

View Full Code Here

        Expression constant1 = new Constant(new Integer(1000));
        Expression constant2 = new Constant(new Integer(5000));
        Collection constants = new ArrayList(2);
        constants.add(constant1);
        constants.add(constant2);
        SetCriteria crit = new SetCriteria(new ElementSymbol("b"), constants); //$NON-NLS-1$
        crit.setNegated(true);
        Query query = new Query();
        query.setSelect(select);
        query.setFrom(from);
        query.setCriteria(crit);
        helpTest("SELECT a FROM db.g WHERE b NOT IN (1000,5000)",  //$NON-NLS-1$

View Full Code Here


    @Test public void testCompoundNonJoinCriteriaInFromUWithIN() {        
        Collection values = new ArrayList();
        values.add(new Constant(new Integer(0)));
        values.add(new Constant(new Integer(1)));
        PredicateCriteria crit = new SetCriteria(new ElementSymbol("e2"), values); //$NON-NLS-1$
        helpTestCompoundNonJoinCriteria("e2 IN (0, 1)", crit);     //$NON-NLS-1$
    }

View Full Code Here

            if (!(criteria instanceof AbstractSetCriteria)) {
                continue;
            }
            
            if (criteria instanceof SetCriteria) {
                SetCriteria setCriteria = (SetCriteria)criteria;
                if (setCriteria.isNegated() || setCriteria.getNumberOfValues() <= maxSetSize) {
                    continue;
                }
                SetState state = new SetState();
                setStates.put(i, state);
                LinkedHashSet<Object> values = new LinkedHashSet<Object>();
                for (Expression expr : (Collection<Expression>)setCriteria.getValues()) {
          values.add(eval.evaluate(expr, null));
        }
                state.valueIterator = new CollectionValueIterator(values);
                sources.add(Arrays.asList(state));
            } else if (criteria instanceof DependentSetCriteria) {

View Full Code Here

          for (int j = 0; j < maxSize && iter.hasNext(); j++) {
            Object val = iter.next();
                  vals.add(newConstant(val));
              }
              
              SetCriteria sc = new SetCriteria();
              sc.setExpression(crit.getExpression());
              sc.setValues(vals);
              orCrits.add(sc);
      }
      }
      if (orCrits.size() == 1) {
        return orCrits.get(0);

View Full Code Here

        
        Map map = new HashMap();
        map.put(e1, e2);
        map.put(c2, c3);
        
        SetCriteria before = new SetCriteria(e1, values);
        SetCriteria after = new SetCriteria(e2, mappedValues);
        helpTest(before, map, after);
    }

View Full Code Here

    
    helpTest(select, "SELECT e1, e2"); //$NON-NLS-1$
  }


  public void testSetCriteria1() {
    SetCriteria sc = new SetCriteria();
    sc.setExpression(new ElementSymbol("e1"));     //$NON-NLS-1$
    sc.setValues(new ArrayList());
    
    helpTest(sc, "e1 IN ()"); //$NON-NLS-1$
  }

View Full Code Here

    
    helpTest(sc, "e1 IN ()"); //$NON-NLS-1$
  }


  public void testSetCriteria2() {
    SetCriteria sc = new SetCriteria();
    sc.setExpression(new ElementSymbol("e1"));   //$NON-NLS-1$
    ArrayList values = new ArrayList();  
    values.add(new ElementSymbol("e2")); //$NON-NLS-1$
    values.add(new Constant("abc")); //$NON-NLS-1$
    sc.setValues(values);
    
    helpTest(sc, "e1 IN (e2, 'abc')"); //$NON-NLS-1$
  }

View Full Code Here

    
    helpTest(sc, "e1 IN (e2, 'abc')"); //$NON-NLS-1$
  }


  public void testSetCriteria3() {
    SetCriteria sc = new SetCriteria();
    sc.setExpression(new ElementSymbol("e1"));   //$NON-NLS-1$
    ArrayList values = new ArrayList();  
    values.add(null);
    values.add(new Constant("b")); //$NON-NLS-1$
    sc.setValues(values);
    
    helpTest(sc, "e1 IN (<undefined>, 'b')"); //$NON-NLS-1$
  }

View Full Code Here

0 1 2

TOP

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

org.teiid.dqp.internal.datamgr.TestInCriteriaImpl

org.teiid.query.eval.Evaluator

org.teiid.query.optimizer.relational.PartitionAnalyzer

org.teiid.query.optimizer.relational.rules.NewCalculateCostUtil

org.teiid.query.optimizer.relational.rules.TestRuleChooseDependent

org.teiid.query.parser.TestParser

org.teiid.query.processor.eval.TestCriteriaEvaluator

org.teiid.query.processor.relational.DependentCriteriaProcessor

org.teiid.query.processor.relational.TestDependentCriteriaProcessor

org.teiid.query.rewriter.QueryRewriter

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.