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