Package org.teiid.query.sql.lang

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

2559
2560
2561
2562
2563
2564
2565
2566
2567
2568
2569
2570
2571
2572
    Select select = new Select();
    ElementSymbol a = new ElementSymbol("a");  //$NON-NLS-1$
    select.addSymbol(a);

    Criteria crit1 = new CompareCriteria(new ElementSymbol("b"), CompareCriteria.EQ, new ElementSymbol("x")); //$NON-NLS-1$ //$NON-NLS-2$
    Expression constant = new Constant(new Integer(1000));
    Criteria crit2 = new CompareCriteria(a, CompareCriteria.EQ, constant);
    Criteria crit = new CompoundCriteria(CompoundCriteria.AND, crit1, crit2);

    Query query = new Query();
    query.setSelect(select);
    query.setFrom(from);
    query.setCriteria(crit);
View Full Code Here
2587
2588
2589
2590
2591
2592
2593
2594
2595
2596
2597
        Expression constant1 = new Constant(new Integer(1000));
        Expression constant2 = new Constant(new Integer(5000));
        Collection constants = new ArrayList(2);
        constants.add(constant1);
        constants.add(constant2);
        Criteria crit = new SetCriteria(new ElementSymbol("b"), constants); //$NON-NLS-1$

        Query query = new Query();
        query.setSelect(select);
        query.setFrom(from);
        query.setCriteria(crit);
View Full Code Here
2635
2636
2637
2638
2639
2640
2641
2642
2643
2644
2645
    Select select = new Select();
    ElementSymbol a = new ElementSymbol("a");  //$NON-NLS-1$
    select.addSymbol(a);

    Criteria crit = new CompareCriteria(new ElementSymbol("b"), CompareCriteria.EQ, new ElementSymbol("aString")); //$NON-NLS-1$ //$NON-NLS-2$

    ArrayList elements = new ArrayList();
    elements.add(new ElementSymbol("c")); //$NON-NLS-1$
    OrderBy orderBy = new OrderBy(elements);
View Full Code Here
2669
2670
2671
2672
2673
2674
2675
2676
2677
2678
    Select select = new Select();
    ElementSymbol a = new ElementSymbol("a");  //$NON-NLS-1$
    select.addSymbol(a);

    Criteria crit = new CompareCriteria(new ElementSymbol("b"), CompareCriteria.EQ, new ElementSymbol("aString")); //$NON-NLS-1$ //$NON-NLS-2$

    Query query = new Query(select, from, crit, orderBy, null);
    return query;
  } 
View Full Code Here
2748
2749
2750
2751
2752
2753
2754
2755
2756
2757
2758
        Select select = new Select();
        ElementSymbol a = new ElementSymbol("a");  //$NON-NLS-1$
        select.addSymbol(a);

        Expression string1 = new Constant("aString"); //$NON-NLS-1$
        Criteria crit = new MatchCriteria(new ElementSymbol("b"), string1); //$NON-NLS-1$

        Query query = new Query();
        query.setSelect(select);
        query.setFrom(from);
        query.setCriteria(crit);
View Full Code Here
2792
2793
2794
2795
2796
2797
2798
2799
2800
2801
2802
    Select select = new Select();
    ElementSymbol a = new ElementSymbol("a");  //$NON-NLS-1$
    select.addSymbol(a);

    Expression string1 = new Constant("#String"); //$NON-NLS-1$
    Criteria crit = new MatchCriteria(new ElementSymbol("b"), string1, '#'); //$NON-NLS-1$

    Query query = new Query();
    query.setSelect(select);
    query.setFrom(from);
    query.setCriteria(crit);
View Full Code Here
2873
2874
2875
2876
2877
2878
2879
2880
2881
2882
2883
        Select select = new Select();
        ElementSymbol a = new ElementSymbol("a");  //$NON-NLS-1$
        select.addSymbol(a);

        ElementSymbol x = new ElementSymbol("x"); //$NON-NLS-1$
        Criteria crit = new MatchCriteria(a, x);

        Query query = new Query();
        query.setSelect(select);
        query.setFrom(from);
        query.setCriteria(crit);
View Full Code Here
2922
2923
2924
2925
2926
2927
2928
2929
2930
2931
2932
        Select select = new Select();
        ElementSymbol a = new ElementSymbol("a");  //$NON-NLS-1$
        select.addSymbol(a);

        Reference ref1 = new Reference(0);
        Criteria crit = new MatchCriteria(new ElementSymbol("b"), ref1); //$NON-NLS-1$

        Query query = new Query();
        query.setSelect(select);
        query.setFrom(from);
        query.setCriteria(crit);
View Full Code Here
2945
2946
2947
2948
2949
2950
2951
2952
2953
2954
2955
        Reference ref0 = new Reference(0);
        ExpressionSymbol expr = new ExpressionSymbol("expr", ref0); //$NON-NLS-1$
        select.addSymbol(expr);

        Reference ref1 = new Reference(1);
        Criteria crit = new MatchCriteria(new ElementSymbol("b"), ref1); //$NON-NLS-1$

        Query query = new Query();
        query.setSelect(select);
        query.setFrom(from);
        query.setCriteria(crit);
View Full Code Here
3188
3189
3190
3191
3192
3193
3194
3195
3196
3197
3198
     
        Block elseBlock = new Block();
        elseBlock.addStatement(elseStmt);
   
        ElementSymbol c = new ElementSymbol("c");     //$NON-NLS-1$
        Criteria crit = new CompareCriteria(c, CompareCriteria.EQ,
            new Constant(new Integer(5)));
           
        IfStatement stmt = new IfStatement(crit, ifBlock, elseBlock);
                       
        helpStmtTest("IF(c = 5) BEGIN DECLARE short a; END ELSE BEGIN DECLARE short b; END", //$NON-NLS-1$
View Full Code Here
TOP

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

  • org.teiid.dqp.internal.datamgr.LanguageBridgeFactory
  • org.teiid.query.eval.Evaluator
  • org.teiid.query.optimizer.relational.PlanToProcessConverter
  • org.teiid.query.optimizer.relational.plantree.PlanNode
  • org.teiid.query.optimizer.relational.rules.FrameUtil
  • org.teiid.query.optimizer.relational.rules.JoinRegion
  • org.teiid.query.optimizer.relational.rules.JoinUtil
  • org.teiid.query.optimizer.relational.rules.NewCalculateCostUtil
  • org.teiid.query.optimizer.relational.rules.RuleAccessPatternValidation
  • org.teiid.query.optimizer.relational.rules.RuleAssignOutputElements
    • 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.