public void testOrderByPath() throws Exception {
createTwoArtistsTwoPaintings();
String ejbql1 = "SELECT p FROM Painting p ORDER BY p.toArtist.artistName ASC";
EJBQLQuery query1 = new EJBQLQuery(ejbql1);
List<?> results1 = context.performQuery(query1);
assertEquals(2, results1.size());
assertEquals(33005, Cayenne.intPKForObject((Persistent) results1.get(0)));
assertEquals(33006, Cayenne.intPKForObject((Persistent) results1.get(1)));
String ejbql2 = "SELECT p FROM Painting p ORDER BY p.toArtist.artistName DESC";
EJBQLQuery query2 = new EJBQLQuery(ejbql2);
List<?> results2 = context.performQuery(query2);
assertEquals(2, results2.size());
assertEquals(33006, Cayenne.intPKForObject((Persistent) results2.get(0)));