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

org.teiid.query.sql.lang.OrderBy
Represents the ORDER BY clause of a query. The ORDER BY clause states what order the rows of a result should be returned in. Each element in the ORDER BY represents a sort that is completed in the order listed. The optional keywords ASC and DESC can be put after each element to specify whether the sort is ascending or descending.

      throws TeiidComponentException, QueryPlannerException, QueryResolverException {
    PlanNode originalNode = unionSource;
    //branches other than the first need to have their projected column names updated
    PlanNode sortNode = NodeEditor.findNodePreOrder(unionSource, NodeConstants.Types.SORT, NodeConstants.Types.SOURCE);
    List<SingleElementSymbol> sortOrder = null;
    OrderBy orderBy = null;
    if (sortNode != null) {
      orderBy = (OrderBy)sortNode.getProperty(Info.SORT_ORDER);
      sortOrder = orderBy.getSortKeys();
    }
    List<SingleElementSymbol> projectCols = FrameUtil.findTopCols(unionSource);
    for (int i = 0; i < virtualElements.size(); i++) {
      ElementSymbol virtualElem = virtualElements.get(i);
      SingleElementSymbol projectedSymbol = projectCols.get(i);
      if (!projectedSymbol.getShortCanonicalName().equals(virtualElem.getShortCanonicalName())) {
        if (sortOrder != null) {
          int sortIndex = sortOrder.indexOf(projectedSymbol);
          if (sortIndex > -1) {
            updateSymbolName(sortOrder, sortIndex, virtualElem, sortOrder.get(sortIndex));
            orderBy.getOrderByItems().get(sortIndex).setSymbol(sortOrder.get(sortIndex));
          }
        }
        updateSymbolName(projectCols, i, virtualElem, projectedSymbol);
      }
    }

View Full Code Here


    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);


    Query query = new Query(select, from, crit, orderBy, null);
    helpTest("SELECT a FROM db.g WHERE b = aString ORDER BY c",  //$NON-NLS-1$
         "SELECT a FROM db.g WHERE b = aString ORDER BY c",  //$NON-NLS-1$
         query);

View Full Code Here

  @Test public void testOrderByDesc(){
    ArrayList elements = new ArrayList();
    elements.add(new ElementSymbol("c")); //$NON-NLS-1$
    ArrayList orderTypes = new ArrayList();
    orderTypes.add(Boolean.FALSE);
    OrderBy orderBy = new OrderBy(elements, orderTypes);
    
    Query query = getOrderByQuery(orderBy);
    helpTest("SELECT a FROM db.g WHERE b = aString ORDER BY c desc",  //$NON-NLS-1$
         "SELECT a FROM db.g WHERE b = aString ORDER BY c DESC",  //$NON-NLS-1$
         query);

View Full Code Here

  /** SELECT a FROM db.g WHERE b = aString order by c,d*/
  @Test public void testOrderBys(){
    ArrayList elements = new ArrayList();
    elements.add(new ElementSymbol("c")); //$NON-NLS-1$
    elements.add(new ElementSymbol("d")); //$NON-NLS-1$
    OrderBy orderBy = new OrderBy(elements);


    Query query = getOrderByQuery(orderBy);
    helpTest("SELECT a FROM db.g WHERE b = aString ORDER BY c,d",  //$NON-NLS-1$
         "SELECT a FROM db.g WHERE b = aString ORDER BY c, d",  //$NON-NLS-1$
         query);

View Full Code Here

    elements.add(new ElementSymbol("c")); //$NON-NLS-1$
    elements.add(new ElementSymbol("d")); //$NON-NLS-1$
    ArrayList orderTypes = new ArrayList();
    orderTypes.add(Boolean.FALSE);
    orderTypes.add(Boolean.FALSE);
    OrderBy orderBy = new OrderBy(elements, orderTypes);


    Query query = getOrderByQuery(orderBy);
    helpTest("SELECT a FROM db.g WHERE b = aString ORDER BY c desc,d desc",  //$NON-NLS-1$
         "SELECT a FROM db.g WHERE b = aString ORDER BY c DESC, d DESC",  //$NON-NLS-1$
         query);

View Full Code Here

    elements.add(new ElementSymbol("c")); //$NON-NLS-1$
    elements.add(new ElementSymbol("d")); //$NON-NLS-1$
    ArrayList orderTypes = new ArrayList();
    orderTypes.add(Boolean.FALSE);
    orderTypes.add(Boolean.TRUE);
    OrderBy orderBy = new OrderBy(elements, orderTypes);


    Query query = getOrderByQuery(orderBy);
    helpTest("SELECT a FROM db.g WHERE b = aString ORDER BY c desc,d",  //$NON-NLS-1$
         "SELECT a FROM db.g WHERE b = aString ORDER BY c DESC, d",  //$NON-NLS-1$
         query);

View Full Code Here

         "SELECT a FROM db.g WHERE b = aString ORDER BY c DESC, d",  //$NON-NLS-1$
         query);
  }  
  
  @Test public void testOrderByNullOrdering(){
    OrderBy orderBy = new OrderBy();
    OrderByItem item = new OrderByItem(new ElementSymbol("c"), true);
    item.setNullOrdering(NullOrdering.FIRST);
    orderBy.getOrderByItems().add(item);
    item = new OrderByItem(new ElementSymbol("d"), false);
    item.setNullOrdering(NullOrdering.LAST);
    orderBy.getOrderByItems().add(item);


    Query query = getOrderByQuery(orderBy);
    helpTest("SELECT a FROM db.g WHERE b = aString ORDER BY c NULLS FIRST,d desc nulls last",  //$NON-NLS-1$
         "SELECT a FROM db.g WHERE b = aString ORDER BY c NULLS FIRST, d DESC NULLS LAST",  //$NON-NLS-1$
         query);

View Full Code Here

        Select select = new Select();
        ElementSymbol c1 = new ElementSymbol("c1", false); //$NON-NLS-1$
        select.addSymbol(c1);
        select.addSymbol(new ElementSymbol("c2", false));         //$NON-NLS-1$


        OrderBy orderBy = new OrderBy();
        orderBy.addVariable(c1);


        Query query = new Query();
        query.setSelect(select);
        query.setFrom(from);
        query.setOrderBy(orderBy);

View Full Code Here

        
    Select select = new Select();
    select.addSymbol(new ElementSymbol("x")); //$NON-NLS-1$
    select.addSymbol(new ElementSymbol("y")); //$NON-NLS-1$


    OrderBy orderby = new OrderBy();
    orderby.addVariable(new ElementSymbol("1"), true); //$NON-NLS-1$


    Query query = new Query();
    query.setSelect(select);
    query.setFrom(from);
    query.setOrderBy(orderby);

View Full Code Here

        
    Select select = new Select();
    select.addSymbol(new ElementSymbol("x")); //$NON-NLS-1$
    select.addSymbol(new ElementSymbol("y")); //$NON-NLS-1$


    OrderBy orderby = new OrderBy();
    orderby.addVariable(new ExpressionSymbol("expr", new Constant(1)), true); //$NON-NLS-1$


    Query query = new Query();
    query.setSelect(select);
    query.setFrom(from);
    query.setOrderBy(orderby);

View Full Code Here

0 1 2 3 4

TOP

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

org.teiid.query.optimizer.relational.PlanToProcessConverter

org.teiid.query.optimizer.relational.rules.FrameUtil

org.teiid.query.optimizer.relational.rules.RuleAssignOutputElements

org.teiid.query.optimizer.relational.rules.RuleCollapseSource

org.teiid.query.optimizer.relational.rules.RuleImplementJoinStrategy

org.teiid.query.optimizer.relational.rules.RuleMergeCriteria

org.teiid.query.optimizer.relational.rules.RuleMergeVirtual

org.teiid.query.optimizer.relational.rules.RulePlanSorts

org.teiid.query.optimizer.relational.rules.RulePushAggregates

org.teiid.query.optimizer.relational.rules.RuleRaiseNull

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.