Examples of OrderBy

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

2748
2749
2750
2751
2752
2753
2754
2755
2756
       
        assertEquals(1, CommandCollectorVisitor.getCommands(command).size());
    }
    @Test public void testOrderBy_J658a() {
        Query resolvedQuery = (Query) helpResolve("SELECT pm1.g1.e1, e2, e3 as x, (5+2) as y FROM pm1.g1 ORDER BY e3"); //$NON-NLS-1$
        OrderBy orderBy = resolvedQuery.getOrderBy();
        int[] expectedPositions = new int[] {2};
        helpTestOrderBy(orderBy, expectedPositions);
    }
View Full Code Here

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

85
86
87
88
89
90
91
92
93
94
95
    // valid elements for criteria and order by
    Collection<ElementSymbol> validCriteriaElements = collectValidCriteriaElements(group, metadata);

    Criteria crit = query.getCriteria();
    OrderBy orderBy = query.getOrderBy();
       
        List<Command> commands = CommandCollectorVisitor.getCommands(query);
        for (Command subCommand : commands) {
            QueryResolver.setChildMetadata(subCommand, command);
           
View Full Code Here

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

713
714
715
716
717
718
719
720
721
722
723
724
        }
        if(obj.getLimit() != null) {
            handleValidationError(QueryPlugin.Util.getString("ValidationVisitor.limit_not_valid_for_xml"), obj); //$NON-NLS-1$
        }
        if (obj.getOrderBy() != null) {
          OrderBy orderBy = obj.getOrderBy();
          for (OrderByItem item : orderBy.getOrderByItems()) {
        if (!(item.getSymbol() instanceof ElementSymbol)) {
          handleValidationError(QueryPlugin.Util.getString("ValidationVisitor.orderby_expression_xml"), obj); //$NON-NLS-1$
        }
      }
         }
View Full Code Here

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

545
546
547
548
549
550
551
552
553
554
        option.setNoCache(true);
        helpTest(option, "OPTION NOCACHE");     //$NON-NLS-1$
    }
   
  public void testOrderBy1() {
    OrderBy ob = new OrderBy();
    ob.addVariable(new ElementSymbol("e1")); //$NON-NLS-1$
   
    helpTest(ob, "ORDER BY e1");     //$NON-NLS-1$
  }
View Full Code Here

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

152
153
154
155
156
157
158
        this.comparator.setNullOrdering(nullOrderings);
    }
   
    public SortUtility(TupleSource ts, List expressions, List<Boolean> types,
      Mode mode, BufferManager bufferManager, String connectionID, List schema) {
    this(ts, new OrderBy(expressions, types).getOrderByItems(), mode, bufferManager, connectionID, schema);
  }
View Full Code Here

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

552
553
554
555
556
557
558
559
560
561
562
   
    helpTest(ob, "ORDER BY e1");     //$NON-NLS-1$
  }

  public void testOrderBy2() {
    OrderBy ob = new OrderBy();
    ob.addVariable(new ElementSymbol("e1")); //$NON-NLS-1$
    ob.addVariable(new AliasSymbol("x", new ElementSymbol("e2"))); //$NON-NLS-1$ //$NON-NLS-2$
   
    helpTest(ob, "ORDER BY e1, x");     //$NON-NLS-1$
  }
View Full Code Here

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

560
561
562
563
564
565
566
567
568
569
570
   
    helpTest(ob, "ORDER BY e1, x");     //$NON-NLS-1$
  }

  public void testOrderBy3() {
    OrderBy ob = new OrderBy();
    ob.addVariable(new ElementSymbol("e1"), OrderBy.DESC); //$NON-NLS-1$
    ob.addVariable(new ElementSymbol("x"), OrderBy.DESC); //$NON-NLS-1$
   
    helpTest(ob, "ORDER BY e1 DESC, x DESC");     //$NON-NLS-1$
  }
View Full Code Here

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

588
589
590
591
592
593
594
595
596
597
598
599
    from.addGroup(new GroupSymbol("m.g")); //$NON-NLS-1$
    CompareCriteria cc = new CompareCriteria(new ElementSymbol("e1"), CompareCriteria.EQ, new Constant(new Integer(5))); //$NON-NLS-1$
    GroupBy groupBy = new GroupBy();
    groupBy.addSymbol(new ElementSymbol("e1")); //$NON-NLS-1$
    CompareCriteria having = new CompareCriteria(new ElementSymbol("e1"), CompareCriteria.GT, new Constant(new Integer(0))); //$NON-NLS-1$
    OrderBy orderBy = new OrderBy();
    orderBy.addVariable(new ElementSymbol("e1")); //$NON-NLS-1$
   
    Query query = new Query();
    query.setSelect(select);
    query.setFrom(from);
    query.setCriteria(cc);
View Full Code Here

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

610
611
612
613
614
615
616
617
618
619
620
621
    From from = new From();
    from.addGroup(new GroupSymbol("m.g")); //$NON-NLS-1$
    GroupBy groupBy = new GroupBy();
    groupBy.addSymbol(new ElementSymbol("e1")); //$NON-NLS-1$
    CompareCriteria having = new CompareCriteria(new ElementSymbol("e1"), CompareCriteria.GT, new Constant(new Integer(0))); //$NON-NLS-1$
    OrderBy orderBy = new OrderBy();
    orderBy.addVariable(new ElementSymbol("e1")); //$NON-NLS-1$
   
    Query query = new Query();
    query.setSelect(select);
    query.setFrom(from);
    query.setGroupBy(groupBy);
View Full Code Here

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

630
631
632
633
634
635
636
637
638
639
640
641
    select.addSymbol(new AllSymbol());
    From from = new From();
    from.addGroup(new GroupSymbol("m.g")); //$NON-NLS-1$
    CompareCriteria cc = new CompareCriteria(new ElementSymbol("e1"), CompareCriteria.EQ, new Constant(new Integer(5))); //$NON-NLS-1$
    CompareCriteria having = new CompareCriteria(new ElementSymbol("e1"), CompareCriteria.GT, new Constant(new Integer(0))); //$NON-NLS-1$
    OrderBy orderBy = new OrderBy();
    orderBy.addVariable(new ElementSymbol("e1")); //$NON-NLS-1$
   
    Query query = new Query();
    query.setSelect(select);
    query.setFrom(from);
    query.setCriteria(cc);
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.