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

org.teiid.query.sql.lang.CompareCriteria
A criteria which represents a simple operator relationship between two expressions. There are 6 operator types. Each side of the comparison may be an expression, which could be an element, a constant, or a function.

Some examples are:
- ticker = 'IBM'
- price >= 50
- revenue < 0
- 5 <= length(companyName)

            }
            if (compCrit.getOperator() == CompoundCriteria.OR) {
              savedElements.addAll(elements);
            }
        } else if(criteria instanceof CompareCriteria) {
            CompareCriteria compCrit = (CompareCriteria)criteria;
            if (compCrit.getOperator() == CompareCriteria.EQ){
                ElementCollectorVisitor.getElements(compCrit, elements);
            }                 
        } else if(criteria instanceof MatchCriteria) {
            MatchCriteria matchCriteria = (MatchCriteria)criteria;
            if (!matchCriteria.isNegated()) {

View Full Code Here

            ndv = Math.max(ndv, 1);
        } 
                
        boolean isNegatedPredicateCriteria = false;
        if(predicateCriteria instanceof CompareCriteria) {
            CompareCriteria compCrit = (CompareCriteria) predicateCriteria;
                        
            if (compCrit.getOperator() == CompareCriteria.EQ || compCrit.getOperator() == CompareCriteria.NE){
                if (unknownChildCost && (!usesKey || multiGroup)) {
                    return UNKNOWN_VALUE;
                }
                cost = childCost / ndv;
                if (compCrit.getOperator() == CompareCriteria.NE) {
                    isNegatedPredicateCriteria = true;
                }
            } else { //GE, LE, GT, LT
                cost = getCostForComparison(childCost, metadata, compCrit, unknownChildCost);
            }

View Full Code Here


    public static List getWhenCriteria(int criteria) {
        ArrayList list = new ArrayList();
        ElementSymbol x = TestElementImpl.helpExample("vm1.g1", "e1"); //$NON-NLS-1$ //$NON-NLS-2$
        for (int i = 0; i < criteria; i++) {
            list.add(new CompareCriteria(x, CompareCriteria.EQ, new Constant(new Integer(i))));
        }
        return list;
    }

View Full Code Here


    public static JoinPredicate helpExample(JoinType type) {
        ElementSymbol e1 = TestElementImpl.helpExample("vm1.g1", "e1"); //$NON-NLS-1$ //$NON-NLS-2$
        ElementSymbol e2 = TestElementImpl.helpExample("vm1.g2", "e1"); //$NON-NLS-1$ //$NON-NLS-2$
        ArrayList criteria = new ArrayList();
        criteria.add(new CompareCriteria(e1, CompareCriteria.EQ, e2));
        return new JoinPredicate(new UnaryFromClause(e1.getGroupSymbol()),
                                 new UnaryFromClause(e2.getGroupSymbol()),
                                 type,
                                 criteria);
    }

View Full Code Here

            case FUNCTION_CRITERIA :
                Function func = new Function("lookup", new Expression[] { new Constant("pm1.g1"), new Constant("e2"), new Constant("e1"), es1 }); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ //$NON-NLS-4$
                FunctionDescriptor desc = FakeMetadataFactory.SFM.getSystemFunctionLibrary().findFunction("lookup", new Class[] { String.class, String.class, String.class, Integer.class }); //$NON-NLS-1$
                func.setFunctionDescriptor(desc);
                func.setType(DataTypeManager.DefaultDataClasses.INTEGER);
                CompareCriteria joinCriteria = new CompareCriteria(es2, CompareCriteria.EQ, func);
                join.setJoinCriteria(joinCriteria);
                break;
        }
    }

View Full Code Here

    Select select = new Select();
    ElementSymbol a = new ElementSymbol("a");  //$NON-NLS-1$
    select.addSymbol(a);


    Expression constant = new Constant(new Integer(1000));
    Criteria crit = new CompareCriteria(a, CompareCriteria.LE, constant);


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

View Full Code Here

    Select select = new Select();
    ElementSymbol a = new ElementSymbol("a");  //$NON-NLS-1$
    select.addSymbol(a);


    Expression constant = new Constant(new Integer(1000));
    Criteria crit = new CompareCriteria(a, CompareCriteria.GE, constant);


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

View Full Code Here


    Select select = new Select();
    ElementSymbol a = new ElementSymbol("a");  //$NON-NLS-1$
    select.addSymbol(a);


    Criteria crit1 = new CompareCriteria(new ElementSymbol("b"), CompareCriteria.EQ, new ElementSymbol("x")); //$NON-NLS-1$ //$NON-NLS-2$
    Expression constant = new Constant(new Integer(1000));
    Criteria crit2 = new CompareCriteria(a, CompareCriteria.EQ, constant);
    Criteria crit = new CompoundCriteria(CompoundCriteria.AND, crit1, crit2);


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

View Full Code Here


    Select select = new Select();
    ElementSymbol a = new ElementSymbol("a");  //$NON-NLS-1$
    select.addSymbol(a);


    Criteria crit = new CompareCriteria(new ElementSymbol("b"), CompareCriteria.EQ, new ElementSymbol("aString")); //$NON-NLS-1$ //$NON-NLS-2$


    ArrayList elements = new ArrayList();
    elements.add(new ElementSymbol("c")); //$NON-NLS-1$
    OrderBy orderBy = new OrderBy(elements);

View Full Code Here


    Select select = new Select();
    ElementSymbol a = new ElementSymbol("a");  //$NON-NLS-1$
    select.addSymbol(a);


    Criteria crit = new CompareCriteria(new ElementSymbol("b"), CompareCriteria.EQ, new ElementSymbol("aString")); //$NON-NLS-1$ //$NON-NLS-2$


    Query query = new Query(select, from, crit, orderBy, null);
    return query;
  }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

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

org.teiid.dqp.internal.datamgr.TestCompoundCriteriaImpl

org.teiid.dqp.internal.datamgr.TestJoinImpl

org.teiid.dqp.internal.datamgr.TestSearchedCaseExpressionImpl

org.teiid.dqp.internal.datamgr.TestUpdateImpl

org.teiid.query.optimizer.relational.PartitionAnalyzer

org.teiid.query.optimizer.relational.rules.JoinRegion

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

org.teiid.query.optimizer.relational.rules.RuleChooseJoinStrategy

org.teiid.query.optimizer.relational.rules.RuleCopyCriteria

org.teiid.query.optimizer.relational.rules.RuleImplementJoinStrategy

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.