Package org.teiid.query.sql.lang

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

770
771
772
773
774
775
776
777
778
779
780
            AbstractSetCriteria setCriteria = (AbstractSetCriteria)criteria;
            if (!setCriteria.isNegated()) {
                ElementCollectorVisitor.getElements(setCriteria.getExpression(), elements);
            }
        } else if(criteria instanceof IsNullCriteria) {
            IsNullCriteria isNullCriteria = (IsNullCriteria)criteria;
            if (!isNullCriteria.isNegated()) {
                ElementCollectorVisitor.getElements(isNullCriteria.getExpression(), elements);
            }
        }       
    }
View Full Code Here
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
            cost = childCost / 3;
           
            isNegatedPredicateCriteria = setCriteria.isNegated();

        } else if(predicateCriteria instanceof IsNullCriteria) {
            IsNullCriteria isNullCriteria = (IsNullCriteria)predicateCriteria;

            float nnv = getStat(Stat.NNV, elements, currentNode, childCost, metadata);
            if (nnv == UNKNOWN_VALUE) {
              if (unknownChildCost) {
                return UNKNOWN_VALUE;
              }
                cost = childCost / ndv;
            } else {
                cost = nnv;
            }
           
            isNegatedPredicateCriteria = isNullCriteria.isNegated();
        } else if (predicateCriteria instanceof DependentSetCriteria) {
          DependentSetCriteria dsc = (DependentSetCriteria)predicateCriteria;
         
          if (unknownChildCost) {
                return UNKNOWN_VALUE;
View Full Code Here
1356
1357
1358
1359
1360
1361
1362
1363
1364
1365
1366
1367
1368
1369
1370
     * Rewrite the given conjunct
     * @return null if the conjunct was internally handled
     */
    private Criteria rewriteAndConjunct(Criteria converted, Map<Expression, Criteria> exprMap, LinkedHashSet<Criteria> newCrits) throws ExpressionEvaluationException {
      if (converted instanceof IsNullCriteria) {
          IsNullCriteria inc = (IsNullCriteria)converted;
          if (!inc.isNegated()) {
              Criteria crit = exprMap.get(inc.getExpression());
              if (crit == null) {
                exprMap.put(inc.getExpression(), converted);
              } else if (!(crit instanceof IsNullCriteria)) {
                return FALSE_CRITERIA;
              }
          }
        } else if (converted instanceof SetCriteria) {
View Full Code Here
2160
2161
2162
2163
2164
2165
2166
2167
2168
2169
2170
2171
    if (nullPossible) {
      if (outcome) {
        if (processing) {
          return crit;
        }
        IsNullCriteria inc = new IsNullCriteria(a);
        inc.setNegated(true);
        return inc;
      }
    } else if (outcome) {
      return TRUE_CRITERIA;
    }
View Full Code Here
2471
2472
2473
2474
2475
2476
2477
2478
2479
2480
2481
        concat.setType(DataTypeManager.DefaultDataClasses.STRING);
        FunctionDescriptor descriptor =
          funcLibrary.findFunction(SourceSystemFunctions.CONCAT, new Class[] { DataTypeManager.DefaultDataClasses.STRING, DataTypeManager.DefaultDataClasses.STRING });
        concat.setFunctionDescriptor(descriptor);
       
        List when = Arrays.asList(new Criteria[] {new CompoundCriteria(CompoundCriteria.AND, new IsNullCriteria(args[0]), new IsNullCriteria(args[1]))});
        Constant nullConstant = new Constant(null, DataTypeManager.DefaultDataClasses.STRING);
        List then = Arrays.asList(new Expression[] {nullConstant});
        SearchedCaseExpression caseExpr = new SearchedCaseExpression(when, then);
        caseExpr.setElseExpression(concat);
        caseExpr.setType(DataTypeManager.DefaultDataClasses.STRING);
View Full Code Here
2567
2568
2569
2570
2571
2572
2573
2574
2575
2576
2577
              convertString(tokenizer.nextToken().trim());
            if (tokenizer.hasMoreTokens()) {
                resultString = convertString(tokenizer.nextToken().trim());
                Criteria crit;
                if (compareString == null) {
                  crit = new IsNullCriteria((Expression) exprs[0].clone());
                } else {
                  crit = new CompareCriteria((Expression) exprs[0].clone(), CompareCriteria.EQ, new Constant(compareString));
                }
                newWhens.add(crit);
                newThens.add(new Constant(resultString));
View Full Code Here
70
71
72
73
74
75
76
77
78
79
80
    private void helpTestMatch(String value, String pattern, char escape, boolean expectedMatch) throws ExpressionEvaluationException, BlockedException, TeiidComponentException {
        helpTestMatch(value, pattern, escape, false, expectedMatch);
    }
 
    private void helpTestIsNull(String value, boolean negated, boolean expectedMatch) throws ExpressionEvaluationException, BlockedException, TeiidComponentException {
        IsNullCriteria criteria = new IsNullCriteria(new Constant(value));
        criteria.setNegated(negated);
       
        boolean result = Evaluator.evaluate(criteria);
        assertEquals("Result did not match expected value", expectedMatch, result); //$NON-NLS-1$
    }
View Full Code Here
105
106
107
108
109
110
111
112
113
114
115
116
            continue;
          }
          this.addCondition(i, (Constant)cc.getRightExpression(), cc.getOperator());
          critIter.remove();
        } else if (criteria instanceof IsNullCriteria) {
          IsNullCriteria inc = (IsNullCriteria)criteria;
          if (inc.isNegated() || !inc.getExpression().equals(keyColumn)) {
            continue;
          }
          this.addCondition(i, new Constant(null), CompareCriteria.EQ);
          critIter.remove();
        } else {
View Full Code Here
197
198
199
200
201
202
203
204
205
206
207
       
        nullNode.addGroup(getGroup(1));
        joinNode.addFirstChild(nullNode);
       
        PlanNode childCriteria = NodeFactory.getNewNode(NodeConstants.Types.SELECT);
        childCriteria.setProperty(Info.SELECT_CRITERIA, new IsNullCriteria(new Constant(1)));
        childCriteria.addGroup(getGroup(2));
        joinNode.addLastChild(childCriteria);
       
        PlanNode childJoinNode = NodeFactory.getNewNode(NodeConstants.Types.JOIN);
        childJoinNode.setProperty(NodeConstants.Info.JOIN_TYPE, JoinType.JOIN_CROSS);
View Full Code Here
411
412
413
414
415
416
417
      Expression ex = TestFunctionResolving.getExpression("1/convert('3.0', bigdecimal)");
      assertEquals(new BigDecimal("0.3333333333333333"), Evaluator.evaluate(ex));
    }
   
    @Test public void testIsNull() throws Exception {
      assertEquals(Boolean.TRUE, Evaluator.evaluate(new IsNullCriteria(new Constant(null, DataTypeManager.DefaultDataClasses.BOOLEAN))));
    }
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.