Package org.teiid.query.sql.lang

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

1817
1818
1819
1820
1821
1822
1823
1824
1825
        Select s2 = new Select();
        s2.addSymbol(new AliasSymbol("FOO", new ExpressionSymbol("xxx", new Constant("B")))); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
        Query q2 = new Query();
        q2.setSelect(s2);
       
        SetQuery sq = new SetQuery(Operation.UNION, false, q1, q2);

        helpTest(sq, expected);       
    }
View Full Code Here
1842
1843
1844
1845
1846
1847
1848
1849
1850
        Select s2 = new Select();
        s2.addSymbol(new AliasSymbol("FOO", new ExpressionSymbol("yyy", new Constant("B")))); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
        Query q2 = new Query();
        q2.setSelect(s2);
       
        SetQuery sq = new SetQuery(Operation.UNION, false, q1, q2);

        helpTest(sq, expected);       
    }
View Full Code Here
64
65
66
67
68
69
70
71
72
73
        q2.setSelect(select);       
        from = new From();
        from.addGroup(new GroupSymbol("h")); //$NON-NLS-1$
        q2.setFrom(from);
       
        SetQuery sq = new SetQuery(Operation.UNION);
        sq.setLeftQuery(q1);
        sq.setRightQuery(q2);
        return sq;
  }
View Full Code Here
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
        q2.setSelect(select);       
        from = new From();
        from.addGroup(new GroupSymbol("h")); //$NON-NLS-1$
        q2.setFrom(from);
  
        SetQuery sq = new SetQuery(Operation.INTERSECT);
        sq.setAll(false);
        sq.setLeftQuery(q1);
        sq.setRightQuery(q2);

        OrderBy orderBy = new OrderBy();
        orderBy.addVariable(new ElementSymbol("x")); //$NON-NLS-1$
        sq.setOrderBy(orderBy); 
        return sq;   
  }
View Full Code Here
117
118
119
120
121
122
123
124
125
126
  }
 
  // ################################## ACTUAL TESTS ################################
 
  public void test1() {   
        SetQuery sq = sample1();
        assertEquals("Union string doesn't match expected: ",  //$NON-NLS-1$
                     "SELECT x FROM g UNION ALL SELECT y FROM h",  //$NON-NLS-1$
                     sq.toString());
  }
View Full Code Here
141
142
143
144
145
146
147
148
149
150
151
152
153
154
        q2.setSelect(select);       
        from = new From();
        from.addGroup(new GroupSymbol("h")); //$NON-NLS-1$
        q2.setFrom(from);
  
        SetQuery sq = new SetQuery(Operation.INTERSECT);
        sq.setAll(false);
        sq.setLeftQuery(q1);
        sq.setRightQuery(q2);
       
        assertEquals("Query combiner string doesn't match expected: ",  //$NON-NLS-1$
                     "SELECT x FROM g INTERSECT SELECT y FROM h",  //$NON-NLS-1$
                     sq.toString());
  }
View Full Code Here
152
153
154
155
156
157
158
159
160
161
162
                     "SELECT x FROM g INTERSECT SELECT y FROM h",  //$NON-NLS-1$
                     sq.toString());
  }

  public void test3() {
        SetQuery sq = sample2();
               
        assertEquals("Query combiner string doesn't match expected: ",  //$NON-NLS-1$
                     "SELECT x FROM g INTERSECT SELECT y FROM h ORDER BY x",  //$NON-NLS-1$
                     sq.toString());
  }
View Full Code Here
123
124
125
126
127
128
129
130
131
132
133
134
    // Get group ID from atomic command
    GroupSymbol group = null;
    if(command instanceof Query){
      group = getQueryGroup((Query)command);   
        }else if(command instanceof SetQuery) {
            SetQuery union = (SetQuery) command;           
            group = getQueryGroup(union.getProjectedQuery());
    } else if (command instanceof ProcedureContainer) {
      group = ((ProcedureContainer) command).getGroup();
    } else if ( command instanceof BatchedUpdateCommand ) {
      BatchedUpdateCommand buc = (BatchedUpdateCommand)command;
        if ( buc.getUpdateCommands().get(0) instanceof Update ) {
View Full Code Here
TOP

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

  • org.teiid.query.optimizer.relational.PartitionAnalyzer
  • org.teiid.query.optimizer.relational.RelationalPlanner
  • org.teiid.query.optimizer.relational.rules.RuleCollapseSource
  • org.teiid.query.optimizer.relational.rules.RuleValidateWhereAll
  • org.teiid.query.parser.SQLParserUtil
  • org.teiid.query.parser.TestOptionsAndHints
  • org.teiid.query.parser.TestParser
  • org.teiid.query.parser.TestSetQueryParsing
  • org.teiid.query.processor.FakeDataManager
  • org.teiid.query.processor.relational.RelationalNodeUtil
    • 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.