Package org.teiid.query.sql.lang

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

73
74
75
76
77
78
79
80
81
82
        }
    }
   
    @Test public void testOpen_Defect16059() throws Exception {
      Query query = (Query)TestResolver.helpResolve("SELECT e1, e2 FROM pm1.g1 WHERE e2 = 5 AND ? IS NULL", FakeMetadataFactory.example1Cached()); //$NON-NLS-1$
        IsNullCriteria nullCrit = (IsNullCriteria)((CompoundCriteria)query.getCriteria()).getCriteria(1);
        nullCrit.setExpression(new Constant(null));
       
        helpTestOpen(query, "SELECT e1, e2 FROM pm1.g1 WHERE e2 = 5", true); //$NON-NLS-1$
    }
View Full Code Here
81
82
83
84
85
86
87
88
89
90
        helpTestOpen(query, "SELECT e1, e2 FROM pm1.g1 WHERE e2 = 5", true); //$NON-NLS-1$
    }
   
    @Test public void testOpen_Defect16059_2() throws Exception {
      Query query = (Query)TestResolver.helpResolve("SELECT e1, e2 FROM pm1.g1 WHERE e2 = 5 AND ? IS NOT NULL", FakeMetadataFactory.example1Cached()); //$NON-NLS-1$
        IsNullCriteria nullCrit = (IsNullCriteria)((CompoundCriteria)query.getCriteria()).getCriteria(1);
        nullCrit.setExpression(new Constant(null));
       
        helpTestOpen(query, null, false);
    }
View Full Code Here
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
     */
    Map<Expression, Expression> buildElementMap(Collection<Criteria> crits) {
        Map<Expression, Expression> srcToTgt = null;
        for (Criteria theCrit : crits) {
            if (theCrit instanceof IsNullCriteria) {
              IsNullCriteria isNull = (IsNullCriteria)theCrit;
              if (!isNull.isNegated() && isNull.getExpression() instanceof ElementSymbol) {
                if (srcToTgt == null) {
                  srcToTgt = new HashMap<Expression, Expression>();
                }
                srcToTgt.put(isNull.getExpression(), new Constant(null, isNull.getExpression().getType()));
              }
              continue;
            }
            if(!(theCrit instanceof CompareCriteria)) {
                continue;
View Full Code Here
258
259
260
261
262
263
264
265
266
      e1.setGroupSymbol(new GroupSymbol("g1"));
        Criteria crit = new SetCriteria(e1, Collections.EMPTY_LIST); //$NON-NLS-1$
       
        Criteria actual = QueryRewriter.rewriteCriteria(crit, null, null, null);
       
        IsNullCriteria inc = new IsNullCriteria(e1);
        inc.setNegated(true);
        assertEquals(inc, actual);
    }
View Full Code Here
420
421
422
423
424
425
426
427
428
429
430
          } else {
            if (agg.getAggregateFunction() == Type.COUNT) {
              if (agg.getExpression() == null) {
              projectedViewSymbols.add(new ExpressionSymbol("stagedAgg", new Constant(1))); //$NON-NLS-1$
              } else {
                SearchedCaseExpression count = new SearchedCaseExpression(Arrays.asList(new IsNullCriteria(agg.getExpression())), Arrays.asList(new Constant(Integer.valueOf(0))));
                count.setElseExpression(new Constant(Integer.valueOf(1)));
                count.setType(DataTypeManager.DefaultDataClasses.INTEGER);
              projectedViewSymbols.add(new ExpressionSymbol("stagedAgg", count)); //$NON-NLS-1$
              }
            } else { //min, max, sum
View Full Code Here
1987
1988
1989
1990
1991
1992
1993
1994
1995
1996
1997
        Select select = new Select();
        ElementSymbol a = new ElementSymbol("a");  //$NON-NLS-1$
        select.addSymbol(a);

        Criteria crit = new IsNullCriteria(a);

        Query query = new Query();
        query.setSelect(select);
        query.setFrom(from);
        query.setCriteria(crit);
View Full Code Here
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
        Select select = new Select();
        ElementSymbol a = new ElementSymbol("a");  //$NON-NLS-1$
        select.addSymbol(a);

        IsNullCriteria crit = new IsNullCriteria(a);
        crit.setNegated(true);

        Query query = new Query();
        query.setSelect(select);
        query.setFrom(from);
        query.setCriteria(crit);
View Full Code Here
2030
2031
2032
2033
2034
2035
2036
2037
2038
2039
2040
    Select select = new Select();
    ElementSymbol a = new ElementSymbol("a");  //$NON-NLS-1$
    select.addSymbol(a);

    Criteria crit = new NotCriteria(new IsNullCriteria(a));

    Query query = new Query();
    query.setSelect(select);
    query.setFrom(from);
    query.setCriteria(crit);
View Full Code Here
6078
6079
6080
6081
6082
6083
6084
        CompareCriteria c2 = new CompareCriteria(new ElementSymbol("e2"), CompareCriteria.EQ, new Constant(new Integer(1))); //$NON-NLS-1$
        helpTestCompoundNonJoinCriteria("e2 = 1", c2);     //$NON-NLS-1$
    }
   
    @Test public void testCompoundNonJoinCriteriaInFromWithIsNull() {       
        helpTestCompoundNonJoinCriteria("e2 IS NULL", new IsNullCriteria(new ElementSymbol("e2")));     //$NON-NLS-1$ //$NON-NLS-2$
    }
View Full Code Here
38
39
40
41
42
43
44
45
46
    public TestIsNullCriteriaImpl(String name) {
        super(name);
    }

    public static IsNullCriteria helpExample(boolean negated) {
      IsNullCriteria crit = new IsNullCriteria(TestElementImpl.helpExample("vm1.g1", "e1")); //$NON-NLS-1$ //$NON-NLS-2$
        crit.setNegated(negated);
        return crit;
    }
View Full Code Here
TOP

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

  • org.teiid.dqp.internal.datamgr.TestIsNullCriteriaImpl
  • org.teiid.query.optimizer.relational.rules.NewCalculateCostUtil
  • org.teiid.query.optimizer.relational.rules.RuleCopyCriteria
  • org.teiid.query.optimizer.relational.rules.RulePushAggregates
  • org.teiid.query.optimizer.relational.rules.TestFrameUtil
  • org.teiid.query.optimizer.relational.rules.TestRuleChooseDependent
  • org.teiid.query.parser.TestParser
  • org.teiid.query.processor.eval.TestCriteriaEvaluator
  • org.teiid.query.processor.eval.TestExpressionEvaluator
  • org.teiid.query.processor.relational.TestAccessNode
    • 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.