Package org.teiid.query.sql.lang

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

1850
1851
1852
1853
1854
1855
1856
1857
1858
1859
1860
    }

    public void testLimit() {
        Query query = new Query();
        Select select = new Select(Arrays.asList(new Object[] {new AllSymbol()}));
        From from = new From(Arrays.asList(new UnaryFromClause(new GroupSymbol("a")))); //$NON-NLS-1$
        query.setSelect(select);
        query.setFrom(from);
        query.setLimit(new Limit(null, new Constant(new Integer(100))));
        helpTest(query, "SELECT * FROM a LIMIT 100"); //$NON-NLS-1$
    }
View Full Code Here
1860
1861
1862
1863
1864
1865
1866
1867
1868
1869
1870
    }
   
    public void testLimitWithOffset() {
        Query query = new Query();
        Select select = new Select(Arrays.asList(new Object[] {new AllSymbol()}));
        From from = new From(Arrays.asList(new UnaryFromClause(new GroupSymbol("a")))); //$NON-NLS-1$
        query.setSelect(select);
        query.setFrom(from);
        query.setLimit(new Limit(new Constant(new Integer(50)), new Constant(new Integer(100))));
        helpTest(query, "SELECT * FROM a LIMIT 50, 100"); //$NON-NLS-1$
    }
View Full Code Here
64
65
66
67
68
69
70
71
72
73
74
75
  public static JoinPredicate example(JoinType joinType, String joinOnElement) {
    JoinPredicate jp = new JoinPredicate();

    GroupSymbol g1 = new GroupSymbol("m.g1"); //$NON-NLS-1$
    GroupSymbol g2 = new GroupSymbol("m.g2"); //$NON-NLS-1$
    FromClause lc = new UnaryFromClause(g1);
    FromClause rc = new UnaryFromClause(g2);

    Expression le = new ElementSymbol("m.g1." + joinOnElement); //$NON-NLS-1$
    Expression re = new ElementSymbol("m.g2." + joinOnElement); //$NON-NLS-1$
    Criteria c1 = new CompareCriteria(le, CompareCriteria.EQ, re);
   
View Full Code Here
199
200
201
202
203
204
205
206
207
208
209
210
    TransformationMetadata indexMetadata = vdb.getAttachment(TransformationMetadata.class);
    Collection rows = new ArrayList();
    int oid = 1;
    if (command instanceof Query) {
      Query query = (Query)command;
      UnaryFromClause ufc = (UnaryFromClause)query.getFrom().getClauses().get(0);
      GroupSymbol group = ufc.getGroup();
      if (StringUtil.startsWithIgnoreCase(group.getNonCorrelationName(), CoreConstants.SYSTEM_ADMIN_MODEL)) {
        final SystemAdminTables sysTable = SystemAdminTables.valueOf(group.getNonCorrelationName().substring(CoreConstants.SYSTEM_ADMIN_MODEL.length() + 1).toUpperCase());
        switch (sysTable) {
        case MATVIEWS:
          for (Schema schema : getVisibleSchemas(vdb, metadata)) {
View Full Code Here
59
60
61
62
63
64
65
66
  }
 
  public static final AssignmentStatement sample2() {
      Query query = new Query();
      query.setSelect(new Select(Arrays.asList(new ElementSymbol("x")))); //$NON-NLS-1$
      query.setFrom(new From(Arrays.asList(new UnaryFromClause(new GroupSymbol("y"))))); //$NON-NLS-1$
      return new AssignmentStatement(new ElementSymbol("b"), query); //$NON-NLS-1$
  }
View Full Code Here
67
68
69
70
71
72
73
74
75
76
    helpTestGroups(gs, true, groups);
  }

  public void testUnaryFromClause() {
    GroupSymbol gs = exampleGroupSymbol(1);
    UnaryFromClause ufc = new UnaryFromClause(gs);
    Set groups = new HashSet();
    groups.add(gs);
    helpTestGroups(ufc, true, groups);
  }
View Full Code Here
76
77
78
79
80
81
82
83
84
85
86
  }
 
  public void testJoinPredicate1() {
    GroupSymbol gs1 = exampleGroupSymbol(1);
    GroupSymbol gs2 = exampleGroupSymbol(2);
    JoinPredicate jp = new JoinPredicate(new UnaryFromClause(gs1), new UnaryFromClause(gs2), JoinType.JOIN_CROSS);
   
    Set groups = new HashSet();
    groups.add(gs1);
    groups.add(gs2);
    helpTestGroups(jp, true, groups);
View Full Code Here
88
89
90
91
92
93
94
95
96
97
98
99
  public void testJoinPredicate2() {
    GroupSymbol gs1 = exampleGroupSymbol(1);
    GroupSymbol gs2 = exampleGroupSymbol(2);
    GroupSymbol gs3 = exampleGroupSymbol(3);
    JoinPredicate jp1 = new JoinPredicate(new UnaryFromClause(gs1), new UnaryFromClause(gs2), JoinType.JOIN_CROSS);
    JoinPredicate jp2 = new JoinPredicate(new UnaryFromClause(gs3), jp1, JoinType.JOIN_CROSS);
   
    Set groups = new HashSet();
    groups.add(gs1);
    groups.add(gs2);
    groups.add(gs3);
View Full Code Here
237
238
239
240
241
242
243
244
        ssc.setCommand(new Query());
        helpTest(ssc,getSymbolMap());
    }
 
  public void testVisitUnaryFromClause() {
    UnaryFromClause ufc = new UnaryFromClause(exampleGroup(true, 0));
    helpTest(ufc, getSymbolMap());   
  }
View Full Code Here
TOP

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

  • org.teiid.dqp.internal.datamgr.TestJoinImpl
  • org.teiid.dqp.internal.datamgr.TestQueryImpl
  • org.teiid.dqp.internal.process.DataTierManagerImpl
  • org.teiid.query.optimizer.relational.RelationalPlanner
  • org.teiid.query.optimizer.TriggerActionPlanner
  • org.teiid.query.optimizer.xml.SourceNodePlannerVisitor
  • org.teiid.query.optimizer.xml.XMLQueryPlanner
  • org.teiid.query.parser.TestOptionsAndHints
  • org.teiid.query.parser.TestParser
  • org.teiid.query.resolver.util.ResolverUtil
    • 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.