Bug 132805 Set descending to outer group will affect inner group.
Description: Set descending to outer group will affect inner group. Steps to reproduce: 1. New a sample datasource and dataset from orders. 2. Drag the dataset to Layout. 3. Add a group on ordernumber, interval 10, descending. 4. Add another group on orderdate, interval day 2, ascending. 5. Preview. Expected result: Data are grouped correctly. Actual result: Inner group didn't work unless you set outer group's sort to asc.
data/org.eclipse.birt.data/src/org/eclipse/birt/data/engine/impl/QueryExecutor.java
odiQuery.setGrouping( Arrays.asList( groupSpecs));
			}		
			
			List sorts = this.baseQueryDefn.getSorts();
			if ( sorts != null && !sorts.isEmpty( ) )
			{
				IQuery.SortSpec[] sortSpecs = new IQuery.SortSpec[ sorts.size() ];
				Iterator it = sorts.iterator();
				for ( int i = 0; it.hasNext(); i++ )
				{
					ISortDefinition src = (ISortDefinition) it.next();
					int sortIndex = -1;
					String sortKey = src.getColumn();
					if( sortKey == null )
						sortKey = src.getExpression().getText();
					else 
					{
						sortKey = getColumnRefExpression(sortKey);
					}
					temporaryComputedColumns.add(new ComputedColumn( "_{$TEMP_SORT_"+i+"$}_", sortKey, DataType.ANY_TYPE));
					sortIndex = -1; 
					sortKey = String.valueOf("_{$TEMP_SORT_"+i+"$}_");
					
					IQuery.SortSpec dest = new IQuery.SortSpec( sortIndex,
							sortKey,
							src.getSortDirection( ) == ISortDefinition.SORT_ASC );
					sortSpecs[i] = dest;
				}
				odiQuery.setOrdering( Arrays.asList( sortSpecs));
			}