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

org.teiid.query.sql.lang.SubqueryCompareCriteria

This class implements a quantified comparison predicate. This is a criteria which represents a simple operator relationship between an expression and either a scalar subquery or a table subquery preceded by one of the possible quantifiers.

The quantifiers are:

{@link #NO_QUANTIFIER}, meaning the subquery has no quantifier and therefore must be a scalar subquery
{@link #SOME} and {@link #ANY}, which are synonymous - the criteria is true if there is at least one comparison between the left expression and the values of the subquery. The criteria is false if the subquery returns no rows.
{@link #ALL}

Some examples are:

ticker = ANY (Select ... FROM ... WHERE ... )
price >= ALL (Select ... FROM ... WHERE ... )
revenue < (Select ... FROM ... WHERE ... )

        q1.setSelect(s1);
        q1.setFrom(f1);


        ElementSymbol expr = new ElementSymbol("e2"); //$NON-NLS-1$


        SubqueryCompareCriteria scc = new SubqueryCompareCriteria(expr, q1, SubqueryCompareCriteria.LE, SubqueryCompareCriteria.SOME);


        helpTest(scc, "e2 <= SOME (SELECT e1 FROM m.g1)");             //$NON-NLS-1$
    }

        Select s2 = new Select();
        s2.addSymbol(new ElementSymbol("e1")); //$NON-NLS-1$
        s2.addSymbol(new ExpressionSymbol("blargh", new ScalarSubquery(q1))); //$NON-NLS-1$
        From f2 = new From();
        f2.addGroup(new GroupSymbol("m.g2"));        //$NON-NLS-1$
        Criteria left = new SubqueryCompareCriteria(new ElementSymbol("e3"), q1, SubqueryCompareCriteria.GE, SubqueryCompareCriteria.ANY); //$NON-NLS-1$
        Criteria right = new ExistsCriteria(q1);
        Criteria outer = new CompoundCriteria(CompoundCriteria.AND, left, right);
        Query q2 = new Query();
        q2.setSelect(s2);
        q2.setFrom(f2);

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

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