}
@Test
public void testOrderByString() {
String statement = "SELECT * FROM " + COMPLEX_TYPE + " ORDER BY " + UnitTestTypeSystemCreator.PROP_ID_STRING;
ObjectList res = doQuery(statement);
assertEquals(5, res.getObjects().size());
assertTrue(resultContainsAtPos("alpha", 0, res));
assertTrue(resultContainsAtPos("beta", 1, res));
assertTrue(resultContainsAtPos("delta", 2, res));
assertTrue(resultContainsAtPos("epsilon", 3, res));
assertTrue(resultContainsAtPos("gamma", 4, res));
statement = "SELECT * FROM " + COMPLEX_TYPE + " ORDER BY " + UnitTestTypeSystemCreator.PROP_ID_STRING + " DESC";
res = doQuery(statement);
assertEquals(5, res.getObjects().size());
assertTrue(resultContainsAtPos("alpha", 4, res));
assertTrue(resultContainsAtPos("beta", 3, res));
assertTrue(resultContainsAtPos("delta", 2, res));
assertTrue(resultContainsAtPos("epsilon", 1, res));
assertTrue(resultContainsAtPos("gamma", 0, res));