Package org.teiid.query.sql.lang

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

361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
              continue;
            }
            if(!(theCrit instanceof CompareCriteria)) {
                continue;
            }
            CompareCriteria crit = (CompareCriteria) theCrit;
            if (crit.getOperator() == CompareCriteria.EQ) {
                if (srcToTgt == null) {
                    srcToTgt = new HashMap<Expression, Expression>();
              }
                srcToTgt.put(crit.getLeftExpression(), crit.getRightExpression());
                srcToTgt.put(crit.getRightExpression(), crit.getLeftExpression());
            }
        }
        if (srcToTgt == null) {
            return Collections.emptyMap();
        }
View Full Code Here
1734
1735
1736
1737
1738
1739
1740
1741
        helpTestRewriteCriteria("case 0 when pm1.g1.e2 then 1 else 2 end = 1", "CASE WHEN pm1.g1.e2 = 0 THEN 1 ELSE 2 END = 1"); //$NON-NLS-1$ //$NON-NLS-2$
    }
   
    @Test public void testRewriteSearchedCaseExpr4() {
        String criteria = "lookup('pm1.g1', 'e2', 'e1', '2') = 0"; //$NON-NLS-1$
        CompareCriteria expected = (CompareCriteria)parseCriteria(criteria, FakeMetadataFactory.example1Cached());
        helpTestRewriteCriteria("lookup('pm1.g1', 'e2', 'e1', case 0 when 1 then pm1.g1.e1 else 2 end) = 0", expected, FakeMetadataFactory.example1Cached()); //$NON-NLS-1$
    }
View Full Code Here
2318
2319
2320
2321
2322
2323
2324
2325
    /**
     * Test ensures that '22.0' is a valid long via bigdecimal
     */
    @Test public void testRewriteBigDecimal() {
      String original = "convert(BQT1.SmallA.LongNum, bigdecimal) = '22.0'"; //$NON-NLS-1$
      CompareCriteria crit = new CompareCriteria(new ElementSymbol("BQT1.SmallA.LongNum"), CompareCriteria.EQ, new Constant(new Long(22))); //$NON-NLS-1$
      helpTestRewriteCriteria(original, crit, FakeMetadataFactory.exampleBQTCached());
    }
View Full Code Here
601
602
603
604
605
606
607
608
609
610
611
    } else {
        // if the source has no rows we need to insert a select node with criteria count(*)>0
        PlanNode selectNode = NodeFactory.getNewNode(NodeConstants.Types.SELECT);
        AggregateSymbol count = new AggregateSymbol("stagedAgg", NonReserved.COUNT, false, null); //$NON-NLS-1$
        aggregates.add(count); //consider the count aggregate for the push down call below
        selectNode.setProperty(NodeConstants.Info.SELECT_CRITERIA, new CompareCriteria(count, CompareCriteria.GT,
                                                                                       new Constant(new Integer(0))));
        selectNode.setProperty(NodeConstants.Info.IS_HAVING, Boolean.TRUE);
        stageGroup.addAsParent(selectNode);
    }
    return stageGroup;
View Full Code Here
834
835
836
837
838
839
840
841
842
843
844
                }
                Expression n = new Constant(0);
                if (aggFunction == Type.STDDEV_SAMP || aggFunction == Type.VAR_SAMP) {
                  n = new Constant(1);
                }
                result = new SearchedCaseExpression(Arrays.asList(new CompareCriteria(sumCountAgg, CompareCriteria.GT, n)), Arrays.asList(result));
                ResolverVisitor.resolveLanguageObject(result, metadata);

                newExpression = result;
                nestedAggregates.add(countAgg);
                nestedAggregates.add(sumAgg);
View Full Code Here
107
108
109
110
111
112
113
114
115
116
117
        es1.setType(DataTypeManager.DefaultDataClasses.INTEGER);

        List elements = new ArrayList();
        elements.add(es1);
       
        CompareCriteria crit = new CompareCriteria(new Constant(0), CompareCriteria.EQ, new Constant(new Integer(1)));
       
        List childElements = new ArrayList();
        childElements.add(es1);
       
      RelationalNode child = new RelationalNode(0) {
View Full Code Here
143
144
145
146
147
148
149
150
151
152
153
        es1.setType(DataTypeManager.DefaultDataClasses.INTEGER);

        List elements = new ArrayList();
        elements.add(es1);
       
        CompareCriteria crit = new CompareCriteria(es1, CompareCriteria.EQ, new Constant(new Integer(1)));
       
        List[] data = new List[] {
          Arrays.asList(1),
          Arrays.asList(1),
          Arrays.asList(1)
View Full Code Here
179
180
181
182
183
184
185
186
187
188
189
        List elements = new ArrayList();
        elements.add(es1);
       
        List[] data = new List[0];
       
        CompareCriteria crit = new CompareCriteria(es1, CompareCriteria.EQ, new Constant(new Integer(1)));
       
        List childElements = new ArrayList();
        childElements.add(es1);
        childElements.add(es2);
       
View Full Code Here
199
200
201
202
203
204
205
206
207
208
209
        es2.setType(DataTypeManager.DefaultDataClasses.STRING);
       
        List elements = new ArrayList();
        elements.add(es1);
       
        CompareCriteria crit = new CompareCriteria(es1, CompareCriteria.EQ, new Constant(new Integer(1)));
       
        List[] data = new List[20];
        for(int i=0; i<20; i++) {
            data[i] = new ArrayList();
            data[i].add(new Integer((i*51) % 11));
View Full Code Here
238
239
240
241
242
243
244
245
246
247
248
        Function func = new Function("lookup", new Expression[] { new Constant("pm1.g1"), new Constant("e2"), new Constant("e1"), es1 }); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ //$NON-NLS-4$
        FunctionDescriptor desc = FakeMetadataFactory.SFM.getSystemFunctionLibrary().findFunction("lookup", new Class[] { String.class, String.class, String.class, Integer.class } ); //$NON-NLS-1$
        func.setFunctionDescriptor(desc);
        func.setType(DataTypeManager.DefaultDataClasses.INTEGER);
        CompareCriteria crit = new CompareCriteria(func, CompareCriteria.EQ, new Constant(new Integer(1)));
       
        List[] data = new List[20];
        for(int i=0; i<20; i++) {
            data[i] = new ArrayList();
            data[i].add(new Integer((i*51) % 11));
View Full Code Here
TOP

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

  • org.teiid.dqp.internal.datamgr.TestCompoundCriteriaImpl
  • org.teiid.dqp.internal.datamgr.TestJoinImpl
  • org.teiid.dqp.internal.datamgr.TestSearchedCaseExpressionImpl
  • org.teiid.dqp.internal.datamgr.TestUpdateImpl
  • org.teiid.query.optimizer.relational.PartitionAnalyzer
  • org.teiid.query.optimizer.relational.rules.JoinRegion
  • org.teiid.query.optimizer.relational.rules.NewCalculateCostUtil
  • org.teiid.query.optimizer.relational.rules.RuleChooseJoinStrategy
  • org.teiid.query.optimizer.relational.rules.RuleCopyCriteria
  • org.teiid.query.optimizer.relational.rules.RuleImplementJoinStrategy
    • 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.