Package org.teiid.query.sql.lang

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

5026
5027
5028
5029
5030
5031
5032
5033
5034
5035
5036
        Expression expr = new ElementSymbol("b"); //$NON-NLS-1$
             
        StoredProcedure exec = new StoredProcedure();
        exec.setProcedureName("m.sq1");               //$NON-NLS-1$
        Query query = new Query(new Select(Arrays.asList(new AllSymbol())), new From(Arrays.asList(new SubqueryFromClause("x", exec))), null, null, null);
        SubquerySetCriteria subCrit = new SubquerySetCriteria(expr, query);
      
        Query outer = new Query();
        outer.setSelect(select);
        outer.setFrom(from);
        outer.setCriteria(subCrit);
View Full Code Here
5068
5069
5070
5071
5072
5073
5074
5075
5076
5077
5078
        u2f.addClause(new UnaryFromClause(new GroupSymbol("db.g3"))); //$NON-NLS-1$
        u2.setFrom(u2f);

        SetQuery union = new SetQuery(Operation.UNION, true, u1, u2);       
                      
        SubquerySetCriteria subCrit = new SubquerySetCriteria(expr, union);
      
        Query outer = new Query();
        outer.setSelect(select);
        outer.setFrom(from);
        outer.setCriteria(subCrit);
View Full Code Here
933
934
935
936
937
938
939
940
        q1.setSelect(s1);
        q1.setFrom(f1);

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

        SubquerySetCriteria ssc = new SubquerySetCriteria(expr, q1);
        helpTest(ssc, "e2 IN (SELECT e1 FROM m.g1)");             //$NON-NLS-1$
    }
View Full Code Here
948
949
950
951
952
953
954
955
956
        q1.setSelect(s1);
        q1.setFrom(f1);

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

        SubquerySetCriteria ssc = new SubquerySetCriteria(expr, q1);
        ssc.setNegated(true);
        helpTest(ssc, "e2 NOT IN (SELECT e1 FROM m.g1)");             //$NON-NLS-1$
    }
View Full Code Here
54
55
56
57
58
59
60
        crit.setLeftExpression(new ElementSymbol("a")); //$NON-NLS-1$
        crit.setRightExpression(new Constant(new Integer(5)));
        crit.setOperator(CompareCriteria.EQ);
        query.setCriteria(crit);               
       
        return new SubquerySetCriteria(new ElementSymbol("temp"), query); //$NON-NLS-1$
    }
View Full Code Here
72
73
74
75
76
77
78
        crit.setLeftExpression(new ElementSymbol("a")); //$NON-NLS-1$
        crit.setRightExpression(new Constant(new Integer(5)));
        crit.setOperator(CompareCriteria.EQ);
        query.setCriteria(crit);
       
        return new SubquerySetCriteria(new ElementSymbol("temp2"), query); //$NON-NLS-1$
    }
View Full Code Here
78
79
80
81
82
83
84
85
86
    }

    // ################################## ACTUAL TESTS ################################
   
    public void testEquals1() {
        SubquerySetCriteria c1 = example1();
        SubquerySetCriteria c2 = example1();
        assertTrue("Equivalent set criteria should have been equal.", c1.equals(c2)); //$NON-NLS-1$
    }
View Full Code Here
84
85
86
87
88
89
90
91
92
        SubquerySetCriteria c2 = example1();
        assertTrue("Equivalent set criteria should have been equal.", c1.equals(c2)); //$NON-NLS-1$
    }

    public void testEquals2() {
        SubquerySetCriteria c1 = example1();
        SubquerySetCriteria c2 = (SubquerySetCriteria)c1.clone();
        assertTrue("Equivalent set criteria should have been equal.", c1.equals(c2)); //$NON-NLS-1$
    }
View Full Code Here
90
91
92
93
94
95
96
97
98
99
        SubquerySetCriteria c2 = (SubquerySetCriteria)c1.clone();
        assertTrue("Equivalent set criteria should have been equal.", c1.equals(c2)); //$NON-NLS-1$
    }

    public void testEquals3() {
        SubquerySetCriteria c1 = example1();
        SubquerySetCriteria c2 = (SubquerySetCriteria)c1.clone();
        c2.setNegated(true);
        assertFalse("Set criteria are not the same", c1.equals(c2)); //$NON-NLS-1$
    }
View Full Code Here
230
231
232
233
234
235
236
237
238
239
    select.addSymbol( exampleElement(true, 1) );
    helpTest(select,getSymbolMap());
  }

    public void testVisitSubquerySetCriteria() {
        SubquerySetCriteria ssc = new SubquerySetCriteria();
        ssc.setExpression(new Function("length", new Expression[] {exampleElement(true, 0)})); //$NON-NLS-1$
        ssc.setCommand(new Query());
        helpTest(ssc,getSymbolMap());
    }
View Full Code Here
TOP

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

  • org.teiid.dqp.internal.datamgr.TestSubqueryInCriteriaImpl
  • org.teiid.query.optimizer.relational.rules.NewCalculateCostUtil
  • org.teiid.query.optimizer.relational.rules.RuleMergeCriteria
  • org.teiid.query.parser.TestParser
  • org.teiid.query.resolver.TestResolver
  • org.teiid.query.rewriter.QueryRewriter
  • org.teiid.query.sql.lang.TestSubquerySetCriteria
  • org.teiid.query.sql.symbol.Expression
  • org.teiid.query.sql.visitor.TestSQLStringVisitor
  • org.teiid.query.sql.visitor.TestStaticSymbolMappingVisitor
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.