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 ... )

        values.add("c"); //$NON-NLS-1$
        helpTestCompareSubqueryCriteria(crit, true, values); 
    }


    @Test public void testCompareSubqueryCriteriaNulls3() throws Exception {
        SubqueryCompareCriteria crit = helpGetCompareSubqueryCriteria(SubqueryCompareCriteria.EQ, SubqueryCompareCriteria.ALL);
        ArrayList values = new ArrayList();
        values.add(null);
        values.add(null);
        helpTestCompareSubqueryCriteria(crit, null, values); 
    }

View Full Code Here

        values.add(null);
        helpTestCompareSubqueryCriteria(crit, null, values); 
    }


    @Test public void testCompareSubqueryCriteriaNulls4() throws Exception {
        SubqueryCompareCriteria crit = helpGetCompareSubqueryCriteria(SubqueryCompareCriteria.EQ, SubqueryCompareCriteria.SOME);
        ArrayList values = new ArrayList();
        values.add(null);
        values.add(null);
        helpTestCompareSubqueryCriteria(crit, null, values); 
    }

View Full Code Here

        values.add(null);
        helpTestCompareSubqueryCriteria(crit, null, values); 
    }


    @Test public void testCompareSubqueryCriteriaNulls5() throws Exception {
        SubqueryCompareCriteria crit = helpGetCompareSubqueryCriteria(SubqueryCompareCriteria.EQ, SubqueryCompareCriteria.SOME);
        ArrayList values = new ArrayList();
        values.add(null);
        values.add("a"); //$NON-NLS-1$
        values.add(null);
        helpTestCompareSubqueryCriteria(crit, true, values);

View Full Code Here

        values.add(null);
        helpTestCompareSubqueryCriteria(crit, true, values); 
    }


    @Test public void testCompareSubqueryCriteriaNulls6() throws Exception {
        SubqueryCompareCriteria crit = helpGetCompareSubqueryCriteria(SubqueryCompareCriteria.EQ, SubqueryCompareCriteria.SOME);
        ArrayList values = new ArrayList();
        values.add("a"); //$NON-NLS-1$
        values.add(null);
        values.add("a"); //$NON-NLS-1$
        helpTestCompareSubqueryCriteria(crit, true, values);

View Full Code Here


    /**
     * null is unknown
     */
    @Test public void testCompareSubqueryCriteriaNulls7() throws Exception{
        SubqueryCompareCriteria crit = helpGetCompareSubqueryCriteria(SubqueryCompareCriteria.LT, SubqueryCompareCriteria.ALL);
        ArrayList values = new ArrayList();
        values.add(null);
        values.add(null);
        helpTestCompareSubqueryCriteria(crit, null, values); 
    }

View Full Code Here


    /**
     * null is unknown
     */
    @Test public void testCompareSubqueryCriteriaNulls8() throws Exception {
        SubqueryCompareCriteria crit = helpGetCompareSubqueryCriteria(SubqueryCompareCriteria.GT, SubqueryCompareCriteria.ALL);
        ArrayList values = new ArrayList();
        values.add(null);
        values.add(null);
        helpTestCompareSubqueryCriteria(crit, null, values); 
    }

View Full Code Here


        Select s2 = new Select();
        s2.addSymbol(new ElementSymbol("e1")); //$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$
        Query q2 = new Query();
        q2.setSelect(s2);
        q2.setFrom(f2);
        q2.setCriteria(left);

View Full Code Here


        Select s2 = new Select();
        s2.addSymbol(new ElementSymbol("e1")); //$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.GT, SubqueryCompareCriteria.SOME); //$NON-NLS-1$
        Query q2 = new Query();
        q2.setSelect(s2);
        q2.setFrom(f2);
        q2.setCriteria(left);

View Full Code Here


        Select s2 = new Select();
        s2.addSymbol(new ElementSymbol("e1")); //$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.EQ, SubqueryCompareCriteria.ALL); //$NON-NLS-1$
        Query q2 = new Query();
        q2.setSelect(s2);
        q2.setFrom(f2);
        q2.setCriteria(left);

View Full Code Here

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


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


        SubqueryCompareCriteria scc = new SubqueryCompareCriteria(expr, q1, SubqueryCompareCriteria.EQ, SubqueryCompareCriteria.ANY);


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

View Full Code Here

0 1 2

TOP

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

org.teiid.dqp.internal.datamgr.TestSubqueryCompareCriteriaImpl

org.teiid.query.optimizer.relational.rules.RuleMergeCriteria

org.teiid.query.optimizer.relational.rules.TestGroupRecontext

org.teiid.query.parser.TestParser

org.teiid.query.processor.eval.TestCriteriaEvaluator

org.teiid.query.sql.symbol.Expression

org.teiid.query.sql.symbol.ScalarSubquery

org.teiid.query.sql.visitor.TestSQLStringVisitor

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.