@Test
public void testExpandPathMultipleWithOrder() throws Exception {

    String original = "+Employee department Department employees +Employee ORDER BY 1.name 2.name 3.name";
    String exp1 = "Employee department Department employees Employee ORDER BY 1.name 2.name 3.name";
    String exp2 = "Employee department Department employees Manager ORDER BY 1.name 2.name 3.name";
    String exp3 = "Employee department Department employees CEO ORDER BY 1.name 2.name 3.name";
    String exp4 = "Manager department Department employees Employee ORDER BY 1.name 2.name 3.name";
    String exp5 = "Manager department Department employees Manager ORDER BY 1.name 2.name 3.name";
    String exp6 = "Manager department Department employees CEO ORDER BY 1.name 2.name 3.name";
    String exp7 = "CEO department Department employees Employee ORDER BY 1.name 2.name 3.name";
    String exp8 = "CEO department Department employees Manager ORDER BY 1.name 2.name 3.name";
    String exp9 = "CEO department Department employees CEO ORDER BY 1.name 2.name 3.name";
    Assert.assertEquals(new LinkedHashSet(Arrays.asList(exp1, exp2, exp3, exp4, exp5, exp6, exp7, exp8, exp9)), QueryGenUtil.expandPath(os, original));
}