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)

    select.addSymbol(new ElementSymbol("a")); //$NON-NLS-1$
    
    GroupBy groupBy = new GroupBy();
    groupBy.addSymbol(new ElementSymbol("a")); //$NON-NLS-1$
    
    Criteria having = new CompareCriteria(
      new AggregateSymbol("count", "COUNT", false, new ElementSymbol("b", false)), //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
      CompareCriteria.GT,
      new Constant(new Integer(0)) );
        
    Query query = new Query();

View Full Code Here

    groupBy.addSymbol(new ElementSymbol("a")); //$NON-NLS-1$
    groupBy.addSymbol(new ElementSymbol("b")); //$NON-NLS-1$
    
    CompoundCriteria having = new CompoundCriteria();
    having.setOperator(CompoundCriteria.AND);
    having.addCriteria(new CompareCriteria(
      new AggregateSymbol("count", "COUNT", false, new ElementSymbol("b", false)), //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
      CompareCriteria.GT,
      new Constant(new Integer(0)) ));
    having.addCriteria(new CompareCriteria(
      new Function("+", new Expression[] { new ElementSymbol("b", false), new Constant(new Integer(5)) }), //$NON-NLS-1$ //$NON-NLS-2$
      CompareCriteria.GT,
      new Constant(new Integer(0)) ));
        
    Query query = new Query();

View Full Code Here

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


    Expression ex = new ElementSymbol("value"); //$NON-NLS-1$
    Criteria crit = new CompareCriteria(a, CompareCriteria.NE, ex);


    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("value"); //$NON-NLS-1$
        Criteria crit = new CompareCriteria(a, CompareCriteria.NE, 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 crit = new CompareCriteria(a, CompareCriteria.EQ, new Constant(new Integer(5)));


    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 crit = new CompareCriteria(a, CompareCriteria.EQ, new Constant(new Integer(5)));


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

View Full Code Here

        Query query = new Query();
        query.setSelect(select);
        query.setFrom(from);
        
        ElementSymbol elem = new ElementSymbol("ab.cd.@ef"); //$NON-NLS-1$
        query.setCriteria(new CompareCriteria(elem, CompareCriteria.EQ, new Constant("abc"))); //$NON-NLS-1$


        helpTest("SELECT * FROM model.doc WHERE ab.cd.@ef = 'abc'",  //$NON-NLS-1$
                 "SELECT * FROM model.doc WHERE ab.cd.@ef = 'abc'",  //$NON-NLS-1$
                 query);   
    }

View Full Code Here

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


    Expression constant = new Constant("value"); //$NON-NLS-1$
    Criteria crit = new CompareCriteria(a, CompareCriteria.NE, 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.LT, 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.GT, constant);


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

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.