Package org.teiid.query.sql.lang

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

301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
  /** SELECT * FROM (g1 cross join g2) cross join (g3 cross join g4) */
  @Test public void testMultiCrossJoin2() {
    UnaryFromClause g1 = new UnaryFromClause(new GroupSymbol("g1")); //$NON-NLS-1$
    UnaryFromClause g2 = new UnaryFromClause(new GroupSymbol("g2"));     //$NON-NLS-1$
    JoinPredicate jp = new JoinPredicate(g1, g2, JoinType.JOIN_CROSS);
    UnaryFromClause g3 = new UnaryFromClause(new GroupSymbol("g3")); //$NON-NLS-1$
    UnaryFromClause g4 = new UnaryFromClause(new GroupSymbol("g4"));     //$NON-NLS-1$
    JoinPredicate jp2 = new JoinPredicate(g3, g4, JoinType.JOIN_CROSS);
    JoinPredicate jp3 = new JoinPredicate(jp, jp2, JoinType.JOIN_CROSS);   
    From from = new From();
    from.addClause(jp3); 

    AllSymbol all = new AllSymbol();
    Select select = new Select();
View Full Code Here
327
328
329
330
331
332
333
334
335
336
337
338
  /** SELECT * FROM g1 cross join (g2 cross join g3) */
  @Test public void testMultiCrossJoin3() {
    UnaryFromClause g1 = new UnaryFromClause(new GroupSymbol("g1")); //$NON-NLS-1$
    UnaryFromClause g2 = new UnaryFromClause(new GroupSymbol("g2"));     //$NON-NLS-1$
    UnaryFromClause g3 = new UnaryFromClause(new GroupSymbol("g3")); //$NON-NLS-1$
    JoinPredicate jp = new JoinPredicate(g2, g3, JoinType.JOIN_CROSS);
    JoinPredicate jp2 = new JoinPredicate(g1, jp, JoinType.JOIN_CROSS);
    From from = new From();
    from.addClause(jp2); 

    AllSymbol all = new AllSymbol();
    Select select = new Select();
View Full Code Here
350
351
352
353
354
355
356
357
358
359
360
361
  /** SELECT * FROM g1 cross join (g2 cross join g3), g4 */
  @Test public void testMixedJoin() {
    UnaryFromClause g1 = new UnaryFromClause(new GroupSymbol("g1")); //$NON-NLS-1$
    UnaryFromClause g2 = new UnaryFromClause(new GroupSymbol("g2"));     //$NON-NLS-1$
    UnaryFromClause g3 = new UnaryFromClause(new GroupSymbol("g3")); //$NON-NLS-1$
    JoinPredicate jp = new JoinPredicate(g2, g3, JoinType.JOIN_CROSS);
    JoinPredicate jp2 = new JoinPredicate(g1, jp, JoinType.JOIN_CROSS);
    From from = new From();
    from.addClause(jp2);
    from.addClause(new UnaryFromClause(new GroupSymbol("g4")));   //$NON-NLS-1$

    AllSymbol all = new AllSymbol();
View Full Code Here
377
378
379
380
381
382
383
384
385
386
387
388
389
    UnaryFromClause g2 = new UnaryFromClause(new GroupSymbol("g2"));     //$NON-NLS-1$
    UnaryFromClause g3 = new UnaryFromClause(new GroupSymbol("g3")); //$NON-NLS-1$
    UnaryFromClause g4 = new UnaryFromClause(new GroupSymbol("g4")); //$NON-NLS-1$
    UnaryFromClause g5 = new UnaryFromClause(new GroupSymbol("g5")); //$NON-NLS-1$
    UnaryFromClause g6 = new UnaryFromClause(new GroupSymbol("g6"));     //$NON-NLS-1$
    JoinPredicate jp = new JoinPredicate(g2, g3, JoinType.JOIN_CROSS);
    JoinPredicate jp2 = new JoinPredicate(g1, jp, JoinType.JOIN_CROSS);
    JoinPredicate jp3 = new JoinPredicate(g5, g6, JoinType.JOIN_CROSS);
    From from = new From();
    from.addClause(jp2);
    from.addClause(g4);
    from.addClause(jp3); 
View Full Code Here
409
410
411
412
413
414
415
416
417
418
419
      new ElementSymbol("g2.a"), //$NON-NLS-1$
      CompareCriteria.EQ,
      new ElementSymbol("g3.a")); //$NON-NLS-1$
    ArrayList<Criteria> crits = new ArrayList<Criteria>();
    crits.add(jcrit);   
    JoinPredicate jp = new JoinPredicate(g2, g3, JoinType.JOIN_INNER, crits);
    From from = new From();
    from.addClause(g1);
    from.addClause(jp);

    AllSymbol all = new AllSymbol();
View Full Code Here
436
437
438
439
440
441
442
443
444
445
446
      new ElementSymbol("myG.x"), //$NON-NLS-1$
      CompareCriteria.EQ,
      new ElementSymbol("myH.x")); //$NON-NLS-1$
    ArrayList<Criteria> crits = new ArrayList<Criteria>();
    crits.add(jcrit);   
    JoinPredicate jp = new JoinPredicate(g, h, JoinType.JOIN_RIGHT_OUTER, crits);
    From from = new From();
    from.addClause(jp);

    AliasSymbol as = new AliasSymbol("myA", new ElementSymbol("myG.a")); //$NON-NLS-1$ //$NON-NLS-2$
    Select select = new Select();
View Full Code Here
463
464
465
466
467
468
469
470
471
472
473
      new ElementSymbol("myG.x"), //$NON-NLS-1$
      CompareCriteria.EQ,
      new ElementSymbol("myH.x")); //$NON-NLS-1$
    ArrayList<Criteria> crits = new ArrayList<Criteria>();
    crits.add(jcrit);   
    JoinPredicate jp = new JoinPredicate(g, h, JoinType.JOIN_RIGHT_OUTER, crits);
    From from = new From();
    from.addClause(jp);

    AliasSymbol as = new AliasSymbol("myA", new ElementSymbol("myG.a")); //$NON-NLS-1$ //$NON-NLS-2$
    Select select = new Select();
View Full Code Here
490
491
492
493
494
495
496
497
498
499
500
      new ElementSymbol("myG.x"), //$NON-NLS-1$
      CompareCriteria.EQ,
      new ElementSymbol("myH.x")); //$NON-NLS-1$
    ArrayList<Criteria> crits = new ArrayList<Criteria>();
    crits.add(jcrit);   
    JoinPredicate jp = new JoinPredicate(g, h, JoinType.JOIN_LEFT_OUTER, crits);
    From from = new From();
    from.addClause(jp);

    AliasSymbol as = new AliasSymbol("myA", new ElementSymbol("myG.a")); //$NON-NLS-1$ //$NON-NLS-2$
    Select select = new Select();
View Full Code Here
517
518
519
520
521
522
523
524
525
526
527
      new ElementSymbol("myG.x"), //$NON-NLS-1$
      CompareCriteria.EQ,
      new ElementSymbol("myH.x")); //$NON-NLS-1$
    ArrayList<Criteria> crits = new ArrayList<Criteria>();
    crits.add(jcrit);   
    JoinPredicate jp = new JoinPredicate(g, h, JoinType.JOIN_LEFT_OUTER, crits);
    From from = new From();
    from.addClause(jp);

    AliasSymbol as = new AliasSymbol("myA", new ElementSymbol("myG.a")); //$NON-NLS-1$ //$NON-NLS-2$
    Select select = new Select();
View Full Code Here
544
545
546
547
548
549
550
551
552
553
554
      new ElementSymbol("myG.x"), //$NON-NLS-1$
      CompareCriteria.EQ,
      new ElementSymbol("myH.x")); //$NON-NLS-1$
    ArrayList<Criteria> crits = new ArrayList<Criteria>();
    crits.add(jcrit);   
    JoinPredicate jp = new JoinPredicate(g, h, JoinType.JOIN_FULL_OUTER, crits);
    From from = new From();
    from.addClause(jp);

    AliasSymbol as = new AliasSymbol("myA", new ElementSymbol("myG.a")); //$NON-NLS-1$ //$NON-NLS-2$
    Select select = new Select();
View Full Code Here
TOP

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

  • org.teiid.dqp.internal.datamgr.TestJoinImpl
  • org.teiid.query.optimizer.relational.RelationalPlanner
  • org.teiid.query.optimizer.relational.rules.RuleCollapseSource
  • org.teiid.query.optimizer.xml.XMLQueryPlanner
  • org.teiid.query.parser.TestOptionsAndHints
  • org.teiid.query.parser.TestParser
  • org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor
  • org.teiid.query.resolver.util.ResolverUtil
  • org.teiid.query.sql.lang.TestJoinPredicate
  • org.teiid.query.sql.visitor.TestGroupCollectorVisitor
    • 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.