Package org.teiid.query.sql.lang

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

1139
1140
1141
1142
1143
1144
1145
1146
1147
1148
1149
      outerSelect.addSymbol(e1);
    From outerFrom = new From();
      GroupSymbol pm1g1 = new GroupSymbol("pm1.g1"); //$NON-NLS-1$
    outerFrom.addGroup(pm1g1);
      ElementSymbol e2outer = new ElementSymbol("e2"); //$NON-NLS-1$
    SubquerySetCriteria crit = new SubquerySetCriteria(e2outer, innerQuery);
      Query outerQuery = new Query();
      outerQuery.setSelect(outerSelect);
      outerQuery.setFrom(outerFrom);
      outerQuery.setCriteria(crit);
     
View Full Code Here
1190
1191
1192
1193
1194
1195
1196
1197
1198
1199
1200
    outerSelect.addSymbol(e1);
    From outerFrom = new From();
    GroupSymbol pm1g1 = new GroupSymbol("pm1.g1"); //$NON-NLS-1$
    outerFrom.addGroup(pm1g1);
    ElementSymbol e2 = new ElementSymbol("e2"); //$NON-NLS-1$
    SubquerySetCriteria crit = new SubquerySetCriteria(e2, innerQuery);
    Query outerQuery = new Query();
    outerQuery.setSelect(outerSelect);
    outerQuery.setFrom(outerFrom);
    outerQuery.setCriteria(crit);
   
View Full Code Here
1249
1250
1251
1252
1253
1254
1255
1256
1257
1258
1259
    ElementSymbol e1 = new ElementSymbol("e1"); //$NON-NLS-1$
    outerSelect.addSymbol(e1);
    From outerFrom = new From();
    GroupSymbol pm1g1 = new GroupSymbol("pm1.g1"); //$NON-NLS-1$
    outerFrom.addGroup(pm1g1);
    SubquerySetCriteria crit = new SubquerySetCriteria(e1, innerQuery);
    Query outerQuery = new Query();
    outerQuery.setSelect(outerSelect);
    outerQuery.setFrom(outerFrom);
    outerQuery.setCriteria(crit);
View Full Code Here
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
            cost = childCost * setCriteria.getNumberOfValues() / ndv;
           
            isNegatedPredicateCriteria = setCriteria.isNegated();
           
        } else if(predicateCriteria instanceof SubquerySetCriteria) {
            SubquerySetCriteria setCriteria = (SubquerySetCriteria) predicateCriteria;
           
            // TODO - use inner ProcessorPlan cardinality estimates
            // to determine the estimated number of values
            if (unknownChildCost) {
                return UNKNOWN_VALUE;
            }
            cost = childCost / 3;
           
            isNegatedPredicateCriteria = setCriteria.isNegated();

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

            float nnv = getStat(Stat.NNV, elements, currentNode, childCost, metadata);
View Full Code Here
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
  public PlannedResult findSubquery(Criteria crit) throws TeiidComponentException, QueryMetadataException {
    PlannedResult result = new PlannedResult();
    if (crit instanceof SubquerySetCriteria) {
      //convert to the quantified form
      SubquerySetCriteria ssc = (SubquerySetCriteria)crit;
      if (ssc.getSubqueryHint().isNoUnnest()) {
        return result;
      }
      result.not ^= ssc.isNegated();
      result.type = crit.getClass();
      result.mergeJoin = ssc.getSubqueryHint().isMergeJoin();
      if (!UNNEST && !result.mergeJoin) {
        return result;
      }
      crit = new SubqueryCompareCriteria(ssc.getExpression(), ssc.getCommand(), SubqueryCompareCriteria.EQ, SubqueryCompareCriteria.SOME);
    } else if (crit instanceof CompareCriteria) {
      if (!UNNEST) {
        return result;
      }
      //convert to the quantified form
View Full Code Here
44
45
46
47
48
49
50
51
52
    }

    public static SubquerySetCriteria helpExample() {
        ElementSymbol element = TestElementImpl.helpExample("g1", "e1"); //$NON-NLS-1$ //$NON-NLS-2$
        Query query = TestQueryImpl.helpExample(true);
        SubquerySetCriteria ssc = new SubquerySetCriteria(element, query);
        ssc.setNegated(true);
        return ssc;
    }
View Full Code Here
1171
1172
1173
1174
1175
1176
1177
1178
1179
1180
1181
1182
1183
1184
1185
1186
1187
          }
        }
              addImplicitLimit(exists, 1);
        }
    } else if (criteria instanceof SubquerySetCriteria) {
        SubquerySetCriteria sub = (SubquerySetCriteria)criteria;
        if (rewriteLeftExpression(sub)) {
          return UNKNOWN_CRITERIA;
        }
        rewriteSubqueryContainer(sub, true);
        if (!RelationalNodeUtil.shouldExecute(sub.getCommand(), false, true)) {
          return getSimpliedCriteria(criteria, sub.getExpression(), !sub.isNegated(), true);
        }
        } else if (criteria instanceof DependentSetCriteria) {
            criteria = rewriteDependentSetCriteria((DependentSetCriteria)criteria);
        } else if (criteria instanceof ExpressionCriteria) {
          return new CompareCriteria(((ExpressionCriteria) criteria).getExpression(), CompareCriteria.EQ, new Constant(Boolean.TRUE));
View Full Code Here
1589
1590
1591
1592
1593
1594
1595
1596
1597
1598
1599
1600
     */
    private Criteria rewriteCriteria(SubqueryCompareCriteria criteria) throws TeiidComponentException, TeiidProcessingException{
     
      if (criteria.getCommand().getProcessorPlan() == null && criteria.getPredicateQuantifier() != SubqueryCompareCriteria.ALL) {
        if (criteria.getOperator() == CompareCriteria.EQ || criteria.getOperator() == CompareCriteria.NE) {
          SubquerySetCriteria result = new SubquerySetCriteria(criteria.getLeftExpression(), criteria.getCommand());
          result.setNegated(criteria.getOperator() == CompareCriteria.NE);
          return rewriteCriteria(result);
        }
        CompareCriteria cc = new CompareCriteria();
        cc.setLeftExpression(criteria.getLeftExpression());
        Query q = createInlineViewQuery(new GroupSymbol("X"), criteria.getCommand(), metadata, criteria.getCommand().getProjectedSymbols()); //$NON-NLS-1$
View Full Code Here
4974
4975
4976
4977
4978
4979
4980
4981
4982
4983
4984
4985
           
        Query query = new Query();
        query.setSelect(select);
        query.setFrom(from);
        query.setCriteria(criteria);
        SubquerySetCriteria subCrit = new SubquerySetCriteria(expr, query);
        subCrit.getSubqueryHint().setMergeJoin(semiJoin);
        Query outer = new Query();
        outer.setSelect(select);
        outer.setFrom(from);
        outer.setCriteria(subCrit);
    return outer;
View Full Code Here
5001
5002
5003
5004
5005
5006
5007
5008
5009
5010
5011
5012
           
        Query query = new Query();
        query.setSelect(select);
        query.setFrom(from);
        query.setCriteria(criteria);
        SubquerySetCriteria subCrit = new SubquerySetCriteria(expr, query);
        subCrit.setNegated(true);
        Query outer = new Query();
        outer.setSelect(select);
        outer.setFrom(from);
        outer.setCriteria(subCrit);
                    
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.